Mikhail Pochatkin created IGNITE-22773:
------------------------------------------
Summary: Create SQL test for disjoint case
Key: IGNITE-22773
URL: https://issues.apache.org/jira/browse/IGNITE-22773
Project: Ignite
Issue Type: Improvement
Components: sql
Reporter: Mikhail Pochatkin
Assignee: Konstantin Orlov
{code:java}
# Self join, different predicates that produce disjoint set of partitions
N1
SELECT /*+ DISABLE_RULE('NestedLoopJoinConverter', 'HashJoinConverter',
'CorrelatedNestedLoopJoin') */ * FROM t1_n1n2n3 as t1, t1_n1n2n3 as t2 WHERE
t1.id = t2.id and t1.id = 1 and t2.id = 42
---
Fragment#0 root
executionNodes: [N1]
remoteFragments: [1]
exchangeSourceNodes: {1=[N2, N3]}
tree:
Receiver(sourceFragment=1, exchange=1, distribution=single)Fragment#1
targetNodes: [N1]
executionNodes: [N2, N3]
tables: [T1_N1N2N3, T1_N1N2N3]
partitions: {N2=[1:3], N3=[2:3]}
tree:
Sender(targetFragment=0, exchange=1, distribution=single)
MergeJoin
Sort
TableScan(name=PUBLIC.T1_N1N2N3, source=2, partitions=3,
distribution=affinity[table: T1_N1N2N3, columns: [ID]])
Sort
TableScan(name=PUBLIC.T1_N1N2N3, source=3, partitions=3,
distribution=affinity[table: T1_N1N2N3, columns: [ID]])
--- {code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
