[jira] [Commented] (IGNITE-12277) Index usage is not applicable for mixed IN and EQUALS queries.

["Ignite TC Bot (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/IGNITE-12277?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16963980#comment-16963980 ] 

Ignite TC Bot commented on IGNITE-12277:
----------------------------------------

{panel:title=Branch: [pull/7029/head] Base: [master] : Possible Blockers (1)|borderStyle=dashed|borderColor=#ccc|titleBGColor=#F7D6C1}
{color:#d04437}Thin client: Python{color} [[tests 0 Exit Code |https://ci.ignite.apache.org/viewLog.html?buildId=4739740]]

{panel}
[TeamCity *--> Run :: All* Results|https://ci.ignite.apache.org/viewLog.html?buildId=4739591&buildTypeId=IgniteTests24Java8_RunAll]

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