You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ignite.apache.org by "Alexei Scherbakov (JIRA)" <ji...@apache.org> on 2016/07/08 11:10:10 UTC
[jira] [Created] (IGNITE-3453) Query engine picks incorrect index
in certain configurations.
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)