[ https://issues.apache.org/jira/browse/IGNITE-14354?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Amelchev Nikita updated IGNITE-14354: ------------------------------------- Ignite Flags: Release Notes Required (was: Docs Required,Release Notes Required) Release Note: SQL: Fixed optimization in case of constants in subquery. > 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 > Fix For: 2.13 > > Time Spent: 20m > 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)