[
https://issues.apache.org/jira/browse/IGNITE-22773?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Konstantin Orlov updated IGNITE-22773:
--------------------------------------
Ignite Flags: (was: Docs Required,Release Notes Required)
> 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
> Priority: Major
> Labels: ignite-3
> Fix For: 3.0.0-beta2
>
> Time Spent: 10m
> Remaining Estimate: 0h
>
> {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)
