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