[jira] [Assigned] (IGNITE-14354) Regression when using SELECT (EXISTS (...))

["Sergey Dorozhkin (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/IGNITE-14354?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Sergey Dorozhkin reassigned IGNITE-14354:
-----------------------------------------

    Assignee: Sergey Dorozhkin

> Regression when using SELECT (EXISTS (...))
> -------------------------------------------
>
>                 Key: IGNITE-14354
>                 URL: https://issues.apache.org/jira/browse/IGNITE-14354
>             Project: Ignite
>          Issue Type: Bug
>          Components: sql
>    Affects Versions: 2.10
>            Reporter: Lukas Eder
>            Assignee: Sergey Dorozhkin
>            Priority: Major
>
> This worked as expected in 2.9.1:
>  
> {code:java}
> CREATE TABLE t (i int PRIMARY KEY, j int);
> SELECT (EXISTS (SELECT 1 FROM t WHERE t.i = 1)); 
> {code}
> In version 2.10, I'm getting:
> {code:java}
> SQL Error [1001] [42000]: Failed to parse query. Column "EXISTS1" not found; SQL statement:
> SELECT
> (EXISTS1)
> FROM SYSTEM_RANGE(1, 1) __Z0 
>  LEFT OUTER JOIN PUBLIC.T __Z1 
>  ON __Z1.I = 1 [42122-197]{code}
> The workaround is to project an asterisk:
> {code:java}
> SELECT (EXISTS (SELECT * FROM t WHERE t.i = 1));{code}



--
This message was sent by Atlassian Jira
(v8.3.4#803005)