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

[Lukas Eder (Jira)]

Lukas Eder created IGNITE-14354:
-----------------------------------

             Summary: 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


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)