[
https://issues.apache.org/jira/browse/IGNITE-12277?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16964719#comment-16964719
]
Ivan Pavlukhin commented on IGNITE-12277:
-----------------------------------------
[~zstan], thank you for contribution! Merged to master.
> 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: 20m
> 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)
