You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ignite.apache.org by "Vladimir Ozerov (JIRA)" <ji...@apache.org> on 2018/03/16 14:38:00 UTC
[jira] [Updated] (IGNITE-3453) Query engine picks incorrect index
in certain configurations.
[ https://issues.apache.org/jira/browse/IGNITE-3453?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Vladimir Ozerov updated IGNITE-3453:
------------------------------------
Labels: sql-performance (was: performance)
> 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
> Components: sql
> Reporter: Alexei Scherbakov
> Priority: Major
> Labels: sql-performance
> 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
(v7.6.3#76005)