ignite-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Alexei Scherbakov (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (IGNITE-3453) Query engine picks incorrect index in certain configurations.
Date Fri, 08 Jul 2016 11:10:10 GMT

     [ https://issues.apache.org/jira/browse/IGNITE-3453?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Alexei Scherbakov updated IGNITE-3453:
--------------------------------------
    Attachment: Example.java

> 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)

Mime
View raw message