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

["Yury Gerzhedovich (Jira)" <ji...@apache.org>]

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

Yury Gerzhedovich edited comment on IGNITE-14354 at 11/1/21, 10:31 AM:
-----------------------------------------------------------------------

[~stalkxt] , you are the assignee for the ticket and the ticket is in a progress state. Is it an actual state?


was (Author: jooger):
Sergey Dorozhkin, you are the assignee for the ticket and the ticket is in a progress state. Is it an actual state?

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