[jira] [Commented] (IGNITE-5749) SQL: add ANY condition support.

["Andrew Mashenkov (JIRA)" <ji...@apache.org>]

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

Andrew Mashenkov commented on IGNITE-5749:
------------------------------------------

Assume, there is some difficulties to support ALL condition for non-collocated data and such queries can be very slow.
Looks like in case of non-collocated data IGNITE-5359 should be done at first.

> SQL: add ANY condition support.
> -------------------------------
>
>                 Key: IGNITE-5749
>                 URL: https://issues.apache.org/jira/browse/IGNITE-5749
>             Project: Ignite
>          Issue Type: Bug
>          Components: sql
>            Reporter: Andrew Mashenkov
>             Fix For: 2.2
>
>
> H2 supports ALL,ANY,SOME (same as ANY) conditions.
> Ignite seems supports ANY condition as well and rewrite it with IN condition.
> But using ALL condition results with a error.
> Seems, we can add support of ALL condition for queries with collocated flag without serious changes in code. 



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)