[
https://issues.apache.org/jira/browse/IGNITE-15983?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17466772#comment-17466772
]
Ignite TC Bot commented on IGNITE-15983:
----------------------------------------
{panel:title=Branch: [pull/9707/head] Base: [master] : No blockers
found!|borderStyle=dashed|borderColor=#ccc|titleBGColor=#D6F7C1}{panel}
{panel:title=Branch: [pull/9707/head] Base: [master] : New Tests
(2)|borderStyle=dashed|borderColor=#ccc|titleBGColor=#D6F7C1}
{color:#00008b}Queries 1{color} [[tests
2|https://ci.ignite.apache.org/viewLog.html?buildId=6347467]]
* {color:#013220}IgniteBinaryCacheQueryTestSuite:
GridSubqueryJoinOptimizerSelfTest.testExistsOperatorWithSubqueryUnderSelect -
PASSED{color}
* {color:#013220}IgniteBinaryCacheQueryTestSuite:
GridSubqueryJoinOptimizerSelfTest.testDifferentOperatorsWithSubqueryUnderSelect
- PASSED{color}
{panel}
[TeamCity *--> Run :: All*
Results|https://ci.ignite.apache.org/viewLog.html?buildId=6347490&buildTypeId=IgniteTests24Java8_RunAll]
> Regression when using SELECT (EXISTS (...)) part 2
> --------------------------------------------------
>
> Key: IGNITE-15983
> URL: https://issues.apache.org/jira/browse/IGNITE-15983
> Project: Ignite
> Issue Type: Bug
> Components: sql
> Reporter: Vladimir Ermakov
> Assignee: Vladimir Ermakov
> Priority: Major
> Time Spent: 10m
> Remaining Estimate: 0h
>
> In the task https://issues.apache.org/jira/browse/IGNITE-14354 erroneous
> queries were not fully corrected.
> So, a query like
> {code:java}
> CREATE TABLE t (i int PRIMARY KEY, j int);
> SELECT (EXISTS (SELECT 1 FROM t WHERE t.i = 1)); {code}
> now passes, when a query
> {code:java}
> CREATE TABLE t (i int PRIMARY KEY, j int);
> SELECT (EXISTS (SELECT i FROM t WHERE t.i = 1)); {code}
> still fails.
> The original cause of the error must be fixed.
--
This message was sent by Atlassian Jira
(v8.20.1#820001)