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

[Ignite TC Bot (Jira)]

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

Ignite TC Bot commented on IGNITE-14354:
----------------------------------------

{panel:title=Branch: [pull/9585/head] Base: [master] : No blockers 
found!|borderStyle=dashed|borderColor=#ccc|titleBGColor=#D6F7C1}{panel}
{panel:title=Branch: [pull/9585/head] Base: [master] : New Tests 
(7)|borderStyle=dashed|borderColor=#ccc|titleBGColor=#D6F7C1}
{color:#00008b}Queries 1{color} [[tests 
7|https://ci.ignite.apache.org/viewLog.html?buildId=6286319]]
* {color:#013220}IgniteBinaryCacheQueryTestSuite: 
GridSubqueryJoinOptimizerSelfTest.testAndClause - PASSED{color}
* {color:#013220}IgniteBinaryCacheQueryTestSuite: 
GridSubqueryJoinOptimizerSelfTest.testNotInClause - PASSED{color}
* {color:#013220}IgniteBinaryCacheQueryTestSuite: 
GridSubqueryJoinOptimizerSelfTest.testConstantSubQuery - PASSED{color}
* {color:#013220}IgniteBinaryCacheQueryTestSuite: 
GridSubqueryJoinOptimizerSelfTest.testOperationWithSubQuery - PASSED{color}
* {color:#013220}IgniteBinaryCacheQueryTestSuite: 
GridSubqueryJoinOptimizerSelfTest.testExistsClause6 - PASSED{color}
* {color:#013220}IgniteBinaryCacheQueryTestSuite: 
GridSubqueryJoinOptimizerSelfTest.testInCause - PASSED{color}
* {color:#013220}IgniteBinaryCacheQueryTestSuite: 
GridSubqueryJoinOptimizerSelfTest.testWhereInClause - PASSED{color}

{panel}
[TeamCity *--> Run :: All* 
Results|https://ci.ignite.apache.org/viewLog.html?buildId=6285867&buildTypeId=IgniteTests24Java8_RunAll]

> 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: Vladimir Ermakov
>            Priority: Major
>          Time Spent: 10m
>  Remaining Estimate: 0h
>
> 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.20.1#820001)