[jira] [Commented] (IGNITE-2563) Queries: ArrayIndexOutOfBoundsException when using BOOL_AND

["Roman Shtykh (JIRA)" <ji...@apache.org>]

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

Roman Shtykh commented on IGNITE-2563:
--------------------------------------

Caused by the mismatch of what is supported in H2 and Ignite.

> Queries: ArrayIndexOutOfBoundsException when using BOOL_AND
> -----------------------------------------------------------
>
>                 Key: IGNITE-2563
>                 URL: https://issues.apache.org/jira/browse/IGNITE-2563
>             Project: Ignite
>          Issue Type: Bug
>          Components: cache
>    Affects Versions: 1.1.4
>            Reporter: Pavel Tupitsyn
>            Assignee: Roman Shtykh
>             Fix For: 1.6
>
>
> The following fields query causes an exception at GridSqlAggregateFunction.ctor(boolean distinct, int typeId).
> typeId is 12.
> {code}
> select bool_and (T0._key < ?) from "".Person as T0 where (T0._key > ?)
> {code}
> The query is valid and executes correctly in the H2 console.
> Looks like we do not support BOOL_AND aggregate. There should be a user-friendly exception describing the problem. Current exception message is "12".



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)