Stanilovsky Evgeny created IGNITE-12277: -------------------------------------------
Summary: 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 Fix For: 2.8 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)