[
https://issues.apache.org/jira/browse/IGNITE-28903?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Evgeny Stanilovsky updated IGNITE-28903:
----------------------------------------
Description:
CorrelatesIntegrationTest#testCorrelatesCollision
second test need to passed also with no merge join hint :
{noformat}
assertQuery("SELECT /*+ NO_MERGE_JOIN */ * FROM test1 WHERE "
{noformat}
full:
{noformat}
sql("CREATE TABLE test1 (a INTEGER, b INTEGER) WITH " + atomicity());
sql("CREATE TABLE test2 (a INTEGER, c INTEGER) WITH " + atomicity());
sql("INSERT INTO test1 VALUES (11, 1), (12, 2), (13, 3)");
sql("INSERT INTO test2 VALUES (11, 1), (12, 1), (13, 4)");
// Collision by correlate variables in both, left and right hands.
assertQuery("SELECT /*+ NO_MERGE_JOIN */ * FROM test1 WHERE " +
"EXISTS(SELECT * FROM test2 WHERE (SELECT test1.a)=test2.a AND
(SELECT test1.b)<>test2.c) " +
"AND NOT EXISTS(SELECT * FROM test2 WHERE (SELECT test1.a)=test2.a
AND (SELECT test1.b)<test2.c)")
.returns(12, 2)
.check();
{noformat}
was:
CorrelatesIntegrationTest#testCorrelatesCollision
second test need to passed also with no merge join hint :
{noformat}
assertQuery("SELECT /*+ NO_MERGE_JOIN */ * FROM test1 WHERE "
{noformat}
> Calcite. Query with NO_MERGE_JOIN is failed to execute
> ------------------------------------------------------
>
> Key: IGNITE-28903
> URL: https://issues.apache.org/jira/browse/IGNITE-28903
> Project: Ignite
> Issue Type: Bug
> Components: sql
> Affects Versions: 2.18
> Reporter: Evgeny Stanilovsky
> Priority: Major
> Labels: ignite-2, ise
>
> CorrelatesIntegrationTest#testCorrelatesCollision
> second test need to passed also with no merge join hint :
> {noformat}
> assertQuery("SELECT /*+ NO_MERGE_JOIN */ * FROM test1 WHERE "
> {noformat}
> full:
> {noformat}
> sql("CREATE TABLE test1 (a INTEGER, b INTEGER) WITH " + atomicity());
> sql("CREATE TABLE test2 (a INTEGER, c INTEGER) WITH " + atomicity());
> sql("INSERT INTO test1 VALUES (11, 1), (12, 2), (13, 3)");
> sql("INSERT INTO test2 VALUES (11, 1), (12, 1), (13, 4)");
> // Collision by correlate variables in both, left and right hands.
> assertQuery("SELECT /*+ NO_MERGE_JOIN */ * FROM test1 WHERE " +
> "EXISTS(SELECT * FROM test2 WHERE (SELECT test1.a)=test2.a AND
> (SELECT test1.b)<>test2.c) " +
> "AND NOT EXISTS(SELECT * FROM test2 WHERE (SELECT
> test1.a)=test2.a AND (SELECT test1.b)<test2.c)")
> .returns(12, 2)
> .check();
> {noformat}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
