[jira] [Created] (IGNITE-3453) Query engine picks incorrect index in certain configurations.

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

[jira] [Created] (IGNITE-3453) Query engine picks incorrect index in certain configurations.

Anton Vinogradov (Jira)
Alexei Scherbakov created IGNITE-3453:
-----------------------------------------

             Summary: Query engine picks incorrect index in certain configurations.
                 Key: IGNITE-3453
                 URL: https://issues.apache.org/jira/browse/IGNITE-3453
             Project: Ignite
          Issue Type: Bug
            Reporter: Alexei Scherbakov
         Attachments: Example.java

Index selection depends on index name ordering, not the argument type.

Index 1 (name idx_1):
countryId:Integer, regionId:Integer, cityId:Integer

Index 2 (name idx_0):
countryId:Integer, regionId:Integer, nation:String

For query:
select id, countryId, cityId from Person where countryId=? and regionId=? and cityId=? params 1,1,1

the index 2 is picked incorrectly and only two first fields are used.

See full reproducer in the attachment.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)