[
https://issues.apache.org/jira/browse/IGNITE-12277?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16963987#comment-16963987
]
Stanilovsky Evgeny commented on IGNITE-12277:
---------------------------------------------
[~jooger] can u or someone else check and if all ok - merge it ? Thanks !
> Index usage is not applicable for mixed IN and EQUALS queries.
> --------------------------------------------------------------
>
> Key: IGNITE-12277
> URL: https://issues.apache.org/jira/browse/IGNITE-12277
> Project: Ignite
> Issue Type: Bug
> Components: sql
> Affects Versions: 2.7.6
> Reporter: Stanilovsky Evgeny
> Assignee: Stanilovsky Evgeny
> Priority: Major
> Labels: sql
> Fix For: 2.8
>
> Time Spent: 10m
> Remaining Estimate: 0h
>
> create table test(pk int, a int, b int);
> create index idx on test(a);
> select * from test where a in(r1 ...r2) <- index usage passed here, explain
> show correctness.
> select * from test where a in(r1 ...r2) and b = r3 <- index usage failed
> here, but there is no rejection for using it.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
