This is an automated email from the ASF dual-hosted git repository.
starocean999 pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/doris.git
The following commit(s) were added to refs/heads/master by this push:
new d48744d072d [fix](test)fix out file of test_leading (#64605)
d48744d072d is described below
commit d48744d072d14436f58065023305c0c579b91486
Author: starocean999 <[email protected]>
AuthorDate: Thu Jun 25 14:47:06 2026 +0800
[fix](test)fix out file of test_leading (#64605)
---
.../data/query_p0/hint/test_leading.out | 390 ++++++++-------------
.../suites/query_p0/hint/test_leading.groovy | 109 +++---
2 files changed, 205 insertions(+), 294 deletions(-)
diff --git a/regression-test/data/query_p0/hint/test_leading.out
b/regression-test/data/query_p0/hint/test_leading.out
index 8b7760623a8..3f261238049 100644
--- a/regression-test/data/query_p0/hint/test_leading.out
+++ b/regression-test/data/query_p0/hint/test_leading.out
@@ -2149,14 +2149,11 @@
-- !select92_1 --
PhysicalResultSink
---hashAgg[GLOBAL]
-----PhysicalDistribute[DistributionSpecGather]
-------hashAgg[LOCAL]
---------hashJoin[INNER_JOIN broadcast] hashCondition=((t2.c2 = t3.c3))
otherCondition=()
-----------hashJoin[INNER_JOIN bucketShuffle] hashCondition=((t1.c1 = t2.c2))
otherCondition=()
-------------PhysicalOlapScan[t1]
-------------PhysicalOlapScan[t2]
-----------PhysicalOlapScan[t3]
+--hashJoin[INNER_JOIN broadcast] hashCondition=((t2.c2 = t3.c3))
otherCondition=()
+----hashJoin[INNER_JOIN bucketShuffle] hashCondition=((t1.c1 = t2.c2))
otherCondition=()
+------PhysicalOlapScan[t1]
+------PhysicalOlapScan[t2]
+----PhysicalOlapScan[t3]
Hint log:
Used: leading(t1 shuffle t2 broadcast t3 )
@@ -2165,14 +2162,11 @@ SyntaxError:
-- !select92_2 --
PhysicalResultSink
---hashAgg[GLOBAL]
-----PhysicalDistribute[DistributionSpecGather]
-------hashAgg[LOCAL]
---------hashJoin[INNER_JOIN bucketShuffle] hashCondition=((t1.c1 = t2.c2))
otherCondition=()
-----------PhysicalOlapScan[t1]
-----------hashJoin[INNER_JOIN broadcast] hashCondition=((t2.c2 = t3.c3))
otherCondition=()
-------------PhysicalOlapScan[t2]
-------------PhysicalOlapScan[t3]
+--hashJoin[INNER_JOIN bucketShuffle] hashCondition=((t1.c1 = t2.c2))
otherCondition=()
+----PhysicalOlapScan[t1]
+----hashJoin[INNER_JOIN broadcast] hashCondition=((t2.c2 = t3.c3))
otherCondition=()
+------PhysicalOlapScan[t2]
+------PhysicalOlapScan[t3]
Hint log:
Used: leading(t1 shuffle { t2 broadcast t3 } )
@@ -2181,14 +2175,11 @@ SyntaxError:
-- !select92_3 --
PhysicalResultSink
---hashAgg[GLOBAL]
-----PhysicalDistribute[DistributionSpecGather]
-------hashAgg[LOCAL]
---------hashJoin[INNER_JOIN bucketShuffle] hashCondition=((t1.c1 = t2.c2))
otherCondition=()
-----------PhysicalOlapScan[t1]
-----------hashJoin[INNER_JOIN broadcast] hashCondition=((t2.c2 = t3.c3))
otherCondition=()
-------------PhysicalOlapScan[t3]
-------------PhysicalOlapScan[t2]
+--hashJoin[INNER_JOIN bucketShuffle] hashCondition=((t1.c1 = t2.c2))
otherCondition=()
+----PhysicalOlapScan[t1]
+----hashJoin[INNER_JOIN broadcast] hashCondition=((t2.c2 = t3.c3))
otherCondition=()
+------PhysicalOlapScan[t3]
+------PhysicalOlapScan[t2]
Hint log:
Used: leading(t1 shuffle { t3 broadcast t2 } )
@@ -2197,14 +2188,11 @@ SyntaxError:
-- !select92_4 --
PhysicalResultSink
---hashAgg[GLOBAL]
-----PhysicalDistribute[DistributionSpecGather]
-------hashAgg[LOCAL]
---------hashJoin[INNER_JOIN broadcast] hashCondition=((t2.c2 = t3.c3))
otherCondition=()
-----------hashJoin[INNER_JOIN bucketShuffle] hashCondition=((t1.c1 = t2.c2))
otherCondition=()
-------------PhysicalOlapScan[t2]
-------------PhysicalOlapScan[t1]
-----------PhysicalOlapScan[t3]
+--hashJoin[INNER_JOIN broadcast] hashCondition=((t2.c2 = t3.c3))
otherCondition=()
+----hashJoin[INNER_JOIN bucketShuffle] hashCondition=((t1.c1 = t2.c2))
otherCondition=()
+------PhysicalOlapScan[t2]
+------PhysicalOlapScan[t1]
+----PhysicalOlapScan[t3]
Hint log:
Used: leading(t2 shuffle t1 broadcast t3 )
@@ -2213,14 +2201,11 @@ SyntaxError:
-- !select92_5 --
PhysicalResultSink
---hashAgg[GLOBAL]
-----PhysicalDistribute[DistributionSpecGather]
-------hashAgg[LOCAL]
---------hashJoin[INNER_JOIN bucketShuffle] hashCondition=((t1.c1 = t2.c2) and
(t2.c2 = t3.c3)) otherCondition=()
-----------PhysicalOlapScan[t2]
-----------hashJoin[INNER_JOIN broadcast] hashCondition=((t1.c1 = t3.c3))
otherCondition=()
-------------PhysicalOlapScan[t1]
-------------PhysicalOlapScan[t3]
+--hashJoin[INNER_JOIN bucketShuffle] hashCondition=((t1.c1 = t2.c2) and (t2.c2
= t3.c3)) otherCondition=()
+----PhysicalOlapScan[t2]
+----hashJoin[INNER_JOIN broadcast] hashCondition=((t1.c1 = t3.c3))
otherCondition=()
+------PhysicalOlapScan[t1]
+------PhysicalOlapScan[t3]
Hint log:
Used: leading(t2 shuffle { t1 broadcast t3 } )
@@ -2229,14 +2214,11 @@ SyntaxError:
-- !select92_6 --
PhysicalResultSink
---hashAgg[GLOBAL]
-----PhysicalDistribute[DistributionSpecGather]
-------hashAgg[LOCAL]
---------hashJoin[INNER_JOIN bucketShuffle] hashCondition=((t1.c1 = t2.c2) and
(t2.c2 = t3.c3)) otherCondition=()
-----------PhysicalOlapScan[t2]
-----------hashJoin[INNER_JOIN broadcast] hashCondition=((t1.c1 = t3.c3))
otherCondition=()
-------------PhysicalOlapScan[t3]
-------------PhysicalOlapScan[t1]
+--hashJoin[INNER_JOIN bucketShuffle] hashCondition=((t1.c1 = t2.c2) and (t2.c2
= t3.c3)) otherCondition=()
+----PhysicalOlapScan[t2]
+----hashJoin[INNER_JOIN broadcast] hashCondition=((t1.c1 = t3.c3))
otherCondition=()
+------PhysicalOlapScan[t3]
+------PhysicalOlapScan[t1]
Hint log:
Used: leading(t2 shuffle { t3 broadcast t1 } )
@@ -2245,14 +2227,11 @@ SyntaxError:
-- !select93_1 --
PhysicalResultSink
---hashAgg[GLOBAL]
-----PhysicalDistribute[DistributionSpecGather]
-------hashAgg[LOCAL]
---------hashJoin[INNER_JOIN broadcast] hashCondition=((t2.c2 = t3.c3))
otherCondition=()
-----------hashJoin[INNER_JOIN broadcast] hashCondition=((t1.c1 = t2.c2))
otherCondition=()
-------------PhysicalOlapScan[t1]
-------------PhysicalOlapScan[t2]
-----------PhysicalOlapScan[t3]
+--hashJoin[INNER_JOIN broadcast] hashCondition=((t2.c2 = t3.c3))
otherCondition=()
+----hashJoin[INNER_JOIN broadcast] hashCondition=((t1.c1 = t2.c2))
otherCondition=()
+------PhysicalOlapScan[t1]
+------PhysicalOlapScan[t2]
+----PhysicalOlapScan[t3]
Hint log:
Used: leading(t1 broadcast t2 broadcast t3 )
@@ -2261,14 +2240,11 @@ SyntaxError:
-- !select93_2 --
PhysicalResultSink
---hashAgg[GLOBAL]
-----PhysicalDistribute[DistributionSpecGather]
-------hashAgg[LOCAL]
---------hashJoin[INNER_JOIN broadcast] hashCondition=((t1.c1 = t2.c2))
otherCondition=()
-----------PhysicalOlapScan[t1]
-----------hashJoin[INNER_JOIN broadcast] hashCondition=((t2.c2 = t3.c3))
otherCondition=()
-------------PhysicalOlapScan[t2]
-------------PhysicalOlapScan[t3]
+--hashJoin[INNER_JOIN broadcast] hashCondition=((t1.c1 = t2.c2))
otherCondition=()
+----PhysicalOlapScan[t1]
+----hashJoin[INNER_JOIN broadcast] hashCondition=((t2.c2 = t3.c3))
otherCondition=()
+------PhysicalOlapScan[t2]
+------PhysicalOlapScan[t3]
Hint log:
Used: leading(t1 broadcast { t2 broadcast t3 } )
@@ -2277,14 +2253,11 @@ SyntaxError:
-- !select93_3 --
PhysicalResultSink
---hashAgg[GLOBAL]
-----PhysicalDistribute[DistributionSpecGather]
-------hashAgg[LOCAL]
---------hashJoin[INNER_JOIN broadcast] hashCondition=((t1.c1 = t2.c2))
otherCondition=()
-----------PhysicalOlapScan[t1]
-----------hashJoin[INNER_JOIN broadcast] hashCondition=((t2.c2 = t3.c3))
otherCondition=()
-------------PhysicalOlapScan[t3]
-------------PhysicalOlapScan[t2]
+--hashJoin[INNER_JOIN broadcast] hashCondition=((t1.c1 = t2.c2))
otherCondition=()
+----PhysicalOlapScan[t1]
+----hashJoin[INNER_JOIN broadcast] hashCondition=((t2.c2 = t3.c3))
otherCondition=()
+------PhysicalOlapScan[t3]
+------PhysicalOlapScan[t2]
Hint log:
Used: leading(t1 broadcast { t3 broadcast t2 } )
@@ -2293,14 +2266,11 @@ SyntaxError:
-- !select93_4 --
PhysicalResultSink
---hashAgg[GLOBAL]
-----PhysicalDistribute[DistributionSpecGather]
-------hashAgg[LOCAL]
---------hashJoin[INNER_JOIN broadcast] hashCondition=((t2.c2 = t3.c3))
otherCondition=()
-----------hashJoin[INNER_JOIN broadcast] hashCondition=((t1.c1 = t2.c2))
otherCondition=()
-------------PhysicalOlapScan[t2]
-------------PhysicalOlapScan[t1]
-----------PhysicalOlapScan[t3]
+--hashJoin[INNER_JOIN broadcast] hashCondition=((t2.c2 = t3.c3))
otherCondition=()
+----hashJoin[INNER_JOIN broadcast] hashCondition=((t1.c1 = t2.c2))
otherCondition=()
+------PhysicalOlapScan[t2]
+------PhysicalOlapScan[t1]
+----PhysicalOlapScan[t3]
Hint log:
Used: leading(t2 broadcast t1 broadcast t3 )
@@ -2309,14 +2279,11 @@ SyntaxError:
-- !select93_5 --
PhysicalResultSink
---hashAgg[GLOBAL]
-----PhysicalDistribute[DistributionSpecGather]
-------hashAgg[LOCAL]
---------hashJoin[INNER_JOIN broadcast] hashCondition=((t1.c1 = t2.c2) and
(t2.c2 = t3.c3)) otherCondition=()
-----------PhysicalOlapScan[t2]
-----------hashJoin[INNER_JOIN broadcast] hashCondition=((t1.c1 = t3.c3))
otherCondition=()
-------------PhysicalOlapScan[t1]
-------------PhysicalOlapScan[t3]
+--hashJoin[INNER_JOIN broadcast] hashCondition=((t1.c1 = t2.c2) and (t2.c2 =
t3.c3)) otherCondition=()
+----PhysicalOlapScan[t2]
+----hashJoin[INNER_JOIN broadcast] hashCondition=((t1.c1 = t3.c3))
otherCondition=()
+------PhysicalOlapScan[t1]
+------PhysicalOlapScan[t3]
Hint log:
Used: leading(t2 broadcast { t1 broadcast t3 } )
@@ -2325,14 +2292,11 @@ SyntaxError:
-- !select93_6 --
PhysicalResultSink
---hashAgg[GLOBAL]
-----PhysicalDistribute[DistributionSpecGather]
-------hashAgg[LOCAL]
---------hashJoin[INNER_JOIN broadcast] hashCondition=((t1.c1 = t2.c2) and
(t2.c2 = t3.c3)) otherCondition=()
-----------PhysicalOlapScan[t2]
-----------hashJoin[INNER_JOIN broadcast] hashCondition=((t1.c1 = t3.c3))
otherCondition=()
-------------PhysicalOlapScan[t3]
-------------PhysicalOlapScan[t1]
+--hashJoin[INNER_JOIN broadcast] hashCondition=((t1.c1 = t2.c2) and (t2.c2 =
t3.c3)) otherCondition=()
+----PhysicalOlapScan[t2]
+----hashJoin[INNER_JOIN broadcast] hashCondition=((t1.c1 = t3.c3))
otherCondition=()
+------PhysicalOlapScan[t3]
+------PhysicalOlapScan[t1]
Hint log:
Used: leading(t2 broadcast { t3 broadcast t1 } )
@@ -2341,14 +2305,11 @@ SyntaxError:
-- !select94_2 --
PhysicalResultSink
---hashAgg[GLOBAL]
-----PhysicalDistribute[DistributionSpecGather]
-------hashAgg[LOCAL]
---------hashJoin[INNER_JOIN bucketShuffle] hashCondition=((t2.c2 = t3.c3))
otherCondition=()
-----------hashJoin[INNER_JOIN bucketShuffle] hashCondition=((t1.c1 = t2.c2))
otherCondition=()
-------------PhysicalOlapScan[t1]
-------------PhysicalOlapScan[t2]
-----------PhysicalOlapScan[t3]
+--hashJoin[INNER_JOIN bucketShuffle] hashCondition=((t2.c2 = t3.c3))
otherCondition=()
+----hashJoin[INNER_JOIN bucketShuffle] hashCondition=((t1.c1 = t2.c2))
otherCondition=()
+------PhysicalOlapScan[t1]
+------PhysicalOlapScan[t2]
+----PhysicalOlapScan[t3]
Hint log:
Used: leading(t1 shuffle t2 shuffle t3 )
@@ -2357,14 +2318,11 @@ SyntaxError:
-- !select94_2 --
PhysicalResultSink
---hashAgg[GLOBAL]
-----PhysicalDistribute[DistributionSpecGather]
-------hashAgg[LOCAL]
---------hashJoin[INNER_JOIN bucketShuffle] hashCondition=((t1.c1 = t2.c2))
otherCondition=()
-----------PhysicalOlapScan[t1]
-----------hashJoin[INNER_JOIN bucketShuffle] hashCondition=((t2.c2 = t3.c3))
otherCondition=()
-------------PhysicalOlapScan[t2]
-------------PhysicalOlapScan[t3]
+--hashJoin[INNER_JOIN bucketShuffle] hashCondition=((t1.c1 = t2.c2))
otherCondition=()
+----PhysicalOlapScan[t1]
+----hashJoin[INNER_JOIN bucketShuffle] hashCondition=((t2.c2 = t3.c3))
otherCondition=()
+------PhysicalOlapScan[t2]
+------PhysicalOlapScan[t3]
Hint log:
Used: leading(t1 shuffle { t2 shuffle t3 } )
@@ -2373,14 +2331,11 @@ SyntaxError:
-- !select94_2 --
PhysicalResultSink
---hashAgg[GLOBAL]
-----PhysicalDistribute[DistributionSpecGather]
-------hashAgg[LOCAL]
---------hashJoin[INNER_JOIN bucketShuffle] hashCondition=((t1.c1 = t2.c2))
otherCondition=()
-----------PhysicalOlapScan[t1]
-----------hashJoin[INNER_JOIN bucketShuffle] hashCondition=((t2.c2 = t3.c3))
otherCondition=()
-------------PhysicalOlapScan[t3]
-------------PhysicalOlapScan[t2]
+--hashJoin[INNER_JOIN bucketShuffle] hashCondition=((t1.c1 = t2.c2))
otherCondition=()
+----PhysicalOlapScan[t1]
+----hashJoin[INNER_JOIN bucketShuffle] hashCondition=((t2.c2 = t3.c3))
otherCondition=()
+------PhysicalOlapScan[t3]
+------PhysicalOlapScan[t2]
Hint log:
Used: leading(t1 shuffle { t3 shuffle t2 } )
@@ -2389,14 +2344,11 @@ SyntaxError:
-- !select94_2 --
PhysicalResultSink
---hashAgg[GLOBAL]
-----PhysicalDistribute[DistributionSpecGather]
-------hashAgg[LOCAL]
---------hashJoin[INNER_JOIN bucketShuffle] hashCondition=((t2.c2 = t3.c3))
otherCondition=()
-----------hashJoin[INNER_JOIN bucketShuffle] hashCondition=((t1.c1 = t2.c2))
otherCondition=()
-------------PhysicalOlapScan[t2]
-------------PhysicalOlapScan[t1]
-----------PhysicalOlapScan[t3]
+--hashJoin[INNER_JOIN bucketShuffle] hashCondition=((t2.c2 = t3.c3))
otherCondition=()
+----hashJoin[INNER_JOIN bucketShuffle] hashCondition=((t1.c1 = t2.c2))
otherCondition=()
+------PhysicalOlapScan[t2]
+------PhysicalOlapScan[t1]
+----PhysicalOlapScan[t3]
Hint log:
Used: leading(t2 shuffle t1 shuffle t3 )
@@ -2405,14 +2357,11 @@ SyntaxError:
-- !select94_2 --
PhysicalResultSink
---hashAgg[GLOBAL]
-----PhysicalDistribute[DistributionSpecGather]
-------hashAgg[LOCAL]
---------hashJoin[INNER_JOIN bucketShuffle] hashCondition=((t1.c1 = t2.c2) and
(t2.c2 = t3.c3)) otherCondition=()
-----------PhysicalOlapScan[t2]
-----------hashJoin[INNER_JOIN bucketShuffle] hashCondition=((t1.c1 = t3.c3))
otherCondition=()
-------------PhysicalOlapScan[t1]
-------------PhysicalOlapScan[t3]
+--hashJoin[INNER_JOIN bucketShuffle] hashCondition=((t1.c1 = t2.c2) and (t2.c2
= t3.c3)) otherCondition=()
+----PhysicalOlapScan[t2]
+----hashJoin[INNER_JOIN bucketShuffle] hashCondition=((t1.c1 = t3.c3))
otherCondition=()
+------PhysicalOlapScan[t1]
+------PhysicalOlapScan[t3]
Hint log:
Used: leading(t2 shuffle { t1 shuffle t3 } )
@@ -2421,14 +2370,11 @@ SyntaxError:
-- !select94_2 --
PhysicalResultSink
---hashAgg[GLOBAL]
-----PhysicalDistribute[DistributionSpecGather]
-------hashAgg[LOCAL]
---------hashJoin[INNER_JOIN bucketShuffle] hashCondition=((t1.c1 = t2.c2) and
(t2.c2 = t3.c3)) otherCondition=()
-----------PhysicalOlapScan[t2]
-----------hashJoin[INNER_JOIN bucketShuffle] hashCondition=((t1.c1 = t3.c3))
otherCondition=()
-------------PhysicalOlapScan[t3]
-------------PhysicalOlapScan[t1]
+--hashJoin[INNER_JOIN bucketShuffle] hashCondition=((t1.c1 = t2.c2) and (t2.c2
= t3.c3)) otherCondition=()
+----PhysicalOlapScan[t2]
+----hashJoin[INNER_JOIN bucketShuffle] hashCondition=((t1.c1 = t3.c3))
otherCondition=()
+------PhysicalOlapScan[t3]
+------PhysicalOlapScan[t1]
Hint log:
Used: leading(t2 shuffle { t3 shuffle t1 } )
@@ -2437,14 +2383,11 @@ SyntaxError:
-- !select95_1 --
PhysicalResultSink
---hashAgg[GLOBAL]
-----PhysicalDistribute[DistributionSpecGather]
-------hashAgg[LOCAL]
---------hashJoin[INNER_JOIN broadcast] hashCondition=((t2.c2 = t3.c3))
otherCondition=()
-----------hashJoin[INNER_JOIN broadcast] hashCondition=((t1.c1 = t2.c2))
otherCondition=()
-------------PhysicalOlapScan[t1]
-------------PhysicalOlapScan[t2]
-----------PhysicalOlapScan[t3]
+--hashJoin[INNER_JOIN broadcast] hashCondition=((t2.c2 = t3.c3))
otherCondition=()
+----hashJoin[INNER_JOIN broadcast] hashCondition=((t1.c1 = t2.c2))
otherCondition=()
+------PhysicalOlapScan[t1]
+------PhysicalOlapScan[t2]
+----PhysicalOlapScan[t3]
Hint log:
Used: leading(t1 broadcast t2 broadcast t3 )
@@ -2453,14 +2396,11 @@ SyntaxError:
-- !select95_4 --
PhysicalResultSink
---hashAgg[GLOBAL]
-----PhysicalDistribute[DistributionSpecGather]
-------hashAgg[LOCAL]
---------hashJoin[INNER_JOIN broadcast] hashCondition=((t2.c2 = t3.c3))
otherCondition=()
-----------hashJoin[INNER_JOIN broadcast] hashCondition=((t1.c1 = t2.c2))
otherCondition=()
-------------PhysicalOlapScan[t2]
-------------PhysicalOlapScan[t1]
-----------PhysicalOlapScan[t3]
+--hashJoin[INNER_JOIN broadcast] hashCondition=((t2.c2 = t3.c3))
otherCondition=()
+----hashJoin[INNER_JOIN broadcast] hashCondition=((t1.c1 = t2.c2))
otherCondition=()
+------PhysicalOlapScan[t2]
+------PhysicalOlapScan[t1]
+----PhysicalOlapScan[t3]
Hint log:
Used: leading(t2 broadcast t1 broadcast t3 )
@@ -2469,14 +2409,11 @@ SyntaxError:
-- !select95_8 --
PhysicalResultSink
---hashAgg[GLOBAL]
-----PhysicalDistribute[DistributionSpecGather]
-------hashAgg[LOCAL]
---------hashJoin[INNER_JOIN broadcast] hashCondition=((t2.c2 = t3.c3))
otherCondition=()
-----------PhysicalOlapScan[t3]
-----------hashJoin[INNER_JOIN broadcast] hashCondition=((t1.c1 = t2.c2))
otherCondition=()
-------------PhysicalOlapScan[t1]
-------------PhysicalOlapScan[t2]
+--hashJoin[INNER_JOIN broadcast] hashCondition=((t2.c2 = t3.c3))
otherCondition=()
+----PhysicalOlapScan[t3]
+----hashJoin[INNER_JOIN broadcast] hashCondition=((t1.c1 = t2.c2))
otherCondition=()
+------PhysicalOlapScan[t1]
+------PhysicalOlapScan[t2]
Hint log:
Used: leading(t3 broadcast { t1 broadcast t2 } )
@@ -2485,14 +2422,11 @@ SyntaxError:
-- !select95_9 --
PhysicalResultSink
---hashAgg[GLOBAL]
-----PhysicalDistribute[DistributionSpecGather]
-------hashAgg[LOCAL]
---------hashJoin[INNER_JOIN broadcast] hashCondition=((t2.c2 = t3.c3))
otherCondition=()
-----------PhysicalOlapScan[t3]
-----------hashJoin[INNER_JOIN broadcast] hashCondition=((t1.c1 = t2.c2))
otherCondition=()
-------------PhysicalOlapScan[t2]
-------------PhysicalOlapScan[t1]
+--hashJoin[INNER_JOIN broadcast] hashCondition=((t2.c2 = t3.c3))
otherCondition=()
+----PhysicalOlapScan[t3]
+----hashJoin[INNER_JOIN broadcast] hashCondition=((t1.c1 = t2.c2))
otherCondition=()
+------PhysicalOlapScan[t2]
+------PhysicalOlapScan[t1]
Hint log:
Used: leading(t3 broadcast { t2 broadcast t1 } )
@@ -2501,14 +2435,11 @@ SyntaxError:
-- !select96_1 --
PhysicalResultSink
---hashAgg[GLOBAL]
-----PhysicalDistribute[DistributionSpecGather]
-------hashAgg[LOCAL]
---------hashJoin[INNER_JOIN broadcast] hashCondition=((t2.c2 = t3.c3))
otherCondition=()
-----------hashJoin[INNER_JOIN bucketShuffle] hashCondition=((t1.c1 = t2.c2))
otherCondition=()
-------------PhysicalOlapScan[t1]
-------------PhysicalOlapScan[t2]
-----------PhysicalOlapScan[t3]
+--hashJoin[INNER_JOIN broadcast] hashCondition=((t2.c2 = t3.c3))
otherCondition=()
+----hashJoin[INNER_JOIN bucketShuffle] hashCondition=((t1.c1 = t2.c2))
otherCondition=()
+------PhysicalOlapScan[t1]
+------PhysicalOlapScan[t2]
+----PhysicalOlapScan[t3]
Hint log:
Used: leading(t1 shuffle t2 broadcast t3 )
@@ -2517,14 +2448,11 @@ SyntaxError:
-- !select96_4 --
PhysicalResultSink
---hashAgg[GLOBAL]
-----PhysicalDistribute[DistributionSpecGather]
-------hashAgg[LOCAL]
---------hashJoin[INNER_JOIN broadcast] hashCondition=((t2.c2 = t3.c3))
otherCondition=()
-----------hashJoin[INNER_JOIN bucketShuffle] hashCondition=((t1.c1 = t2.c2))
otherCondition=()
-------------PhysicalOlapScan[t2]
-------------PhysicalOlapScan[t1]
-----------PhysicalOlapScan[t3]
+--hashJoin[INNER_JOIN broadcast] hashCondition=((t2.c2 = t3.c3))
otherCondition=()
+----hashJoin[INNER_JOIN bucketShuffle] hashCondition=((t1.c1 = t2.c2))
otherCondition=()
+------PhysicalOlapScan[t2]
+------PhysicalOlapScan[t1]
+----PhysicalOlapScan[t3]
Hint log:
Used: leading(t2 shuffle t1 broadcast t3 )
@@ -2533,14 +2461,11 @@ SyntaxError:
-- !select96_8 --
PhysicalResultSink
---hashAgg[GLOBAL]
-----PhysicalDistribute[DistributionSpecGather]
-------hashAgg[LOCAL]
---------hashJoin[INNER_JOIN bucketShuffle] hashCondition=((t2.c2 = t3.c3))
otherCondition=()
-----------PhysicalOlapScan[t3]
-----------hashJoin[INNER_JOIN broadcast] hashCondition=((t1.c1 = t2.c2))
otherCondition=()
-------------PhysicalOlapScan[t1]
-------------PhysicalOlapScan[t2]
+--hashJoin[INNER_JOIN bucketShuffle] hashCondition=((t2.c2 = t3.c3))
otherCondition=()
+----PhysicalOlapScan[t3]
+----hashJoin[INNER_JOIN broadcast] hashCondition=((t1.c1 = t2.c2))
otherCondition=()
+------PhysicalOlapScan[t1]
+------PhysicalOlapScan[t2]
Hint log:
Used: leading(t3 shuffle { t1 broadcast t2 } )
@@ -2549,14 +2474,11 @@ SyntaxError:
-- !select96_9 --
PhysicalResultSink
---hashAgg[GLOBAL]
-----PhysicalDistribute[DistributionSpecGather]
-------hashAgg[LOCAL]
---------hashJoin[INNER_JOIN bucketShuffle] hashCondition=((t2.c2 = t3.c3))
otherCondition=()
-----------PhysicalOlapScan[t3]
-----------hashJoin[INNER_JOIN broadcast] hashCondition=((t1.c1 = t2.c2))
otherCondition=()
-------------PhysicalOlapScan[t2]
-------------PhysicalOlapScan[t1]
+--hashJoin[INNER_JOIN bucketShuffle] hashCondition=((t2.c2 = t3.c3))
otherCondition=()
+----PhysicalOlapScan[t3]
+----hashJoin[INNER_JOIN broadcast] hashCondition=((t1.c1 = t2.c2))
otherCondition=()
+------PhysicalOlapScan[t2]
+------PhysicalOlapScan[t1]
Hint log:
Used: leading(t3 shuffle { t2 broadcast t1 } )
@@ -2565,14 +2487,11 @@ SyntaxError:
-- !select97_1 --
PhysicalResultSink
---hashAgg[GLOBAL]
-----PhysicalDistribute[DistributionSpecGather]
-------hashAgg[LOCAL]
---------hashJoin[INNER_JOIN bucketShuffle] hashCondition=((t2.c2 = t3.c3))
otherCondition=()
-----------hashJoin[INNER_JOIN broadcast] hashCondition=((t1.c1 = t2.c2))
otherCondition=()
-------------PhysicalOlapScan[t1]
-------------PhysicalOlapScan[t2]
-----------PhysicalOlapScan[t3]
+--hashJoin[INNER_JOIN bucketShuffle] hashCondition=((t2.c2 = t3.c3))
otherCondition=()
+----hashJoin[INNER_JOIN broadcast] hashCondition=((t1.c1 = t2.c2))
otherCondition=()
+------PhysicalOlapScan[t1]
+------PhysicalOlapScan[t2]
+----PhysicalOlapScan[t3]
Hint log:
Used: leading(t1 broadcast t2 shuffle t3 )
@@ -2581,14 +2500,11 @@ SyntaxError:
-- !select97_4 --
PhysicalResultSink
---hashAgg[GLOBAL]
-----PhysicalDistribute[DistributionSpecGather]
-------hashAgg[LOCAL]
---------hashJoin[INNER_JOIN bucketShuffle] hashCondition=((t2.c2 = t3.c3))
otherCondition=()
-----------hashJoin[INNER_JOIN broadcast] hashCondition=((t1.c1 = t2.c2))
otherCondition=()
-------------PhysicalOlapScan[t2]
-------------PhysicalOlapScan[t1]
-----------PhysicalOlapScan[t3]
+--hashJoin[INNER_JOIN bucketShuffle] hashCondition=((t2.c2 = t3.c3))
otherCondition=()
+----hashJoin[INNER_JOIN broadcast] hashCondition=((t1.c1 = t2.c2))
otherCondition=()
+------PhysicalOlapScan[t2]
+------PhysicalOlapScan[t1]
+----PhysicalOlapScan[t3]
Hint log:
Used: leading(t2 broadcast t1 shuffle t3 )
@@ -2597,14 +2513,11 @@ SyntaxError:
-- !select97_8 --
PhysicalResultSink
---hashAgg[GLOBAL]
-----PhysicalDistribute[DistributionSpecGather]
-------hashAgg[LOCAL]
---------hashJoin[INNER_JOIN broadcast] hashCondition=((t2.c2 = t3.c3))
otherCondition=()
-----------PhysicalOlapScan[t3]
-----------hashJoin[INNER_JOIN bucketShuffle] hashCondition=((t1.c1 = t2.c2))
otherCondition=()
-------------PhysicalOlapScan[t1]
-------------PhysicalOlapScan[t2]
+--hashJoin[INNER_JOIN broadcast] hashCondition=((t2.c2 = t3.c3))
otherCondition=()
+----PhysicalOlapScan[t3]
+----hashJoin[INNER_JOIN bucketShuffle] hashCondition=((t1.c1 = t2.c2))
otherCondition=()
+------PhysicalOlapScan[t1]
+------PhysicalOlapScan[t2]
Hint log:
Used: leading(t3 broadcast { t1 shuffle t2 } )
@@ -2613,14 +2526,11 @@ SyntaxError:
-- !select97_9 --
PhysicalResultSink
---hashAgg[GLOBAL]
-----PhysicalDistribute[DistributionSpecGather]
-------hashAgg[LOCAL]
---------hashJoin[INNER_JOIN broadcast] hashCondition=((t2.c2 = t3.c3))
otherCondition=()
-----------PhysicalOlapScan[t3]
-----------hashJoin[INNER_JOIN bucketShuffle] hashCondition=((t1.c1 = t2.c2))
otherCondition=()
-------------PhysicalOlapScan[t2]
-------------PhysicalOlapScan[t1]
+--hashJoin[INNER_JOIN broadcast] hashCondition=((t2.c2 = t3.c3))
otherCondition=()
+----PhysicalOlapScan[t3]
+----hashJoin[INNER_JOIN bucketShuffle] hashCondition=((t1.c1 = t2.c2))
otherCondition=()
+------PhysicalOlapScan[t2]
+------PhysicalOlapScan[t1]
Hint log:
Used: leading(t3 broadcast { t2 shuffle t1 } )
diff --git a/regression-test/suites/query_p0/hint/test_leading.groovy
b/regression-test/suites/query_p0/hint/test_leading.groovy
index 0b5800bef63..a158bc9086d 100644
--- a/regression-test/suites/query_p0/hint/test_leading.groovy
+++ b/regression-test/suites/query_p0/hint/test_leading.groovy
@@ -31,6 +31,7 @@ suite("test_leading") {
sql 'set enable_nereids_distribute_planner=false'
sql "set ignore_shape_nodes='PhysicalProject'"
sql 'set runtime_filter_mode=OFF'
+ sql 'set topn_lazy_materialization_threshold=0'
// create tables
sql """drop table if exists t1;"""
@@ -939,136 +940,136 @@ suite("test_leading") {
// only distribute hint + single hint
// unused
explain {
- sql """shape plan select count(*) from t1 right outer join [broadcast]
t2 on c1 = c2;"""
+ sql """shape plan select * from t1 right outer join [broadcast] t2 on
c1 = c2;"""
contains("UnUsed: [broadcast]_1")
}
// only distribute hint + multi hints
explain {
- sql """shape plan select count(*) from t1 right outer join [broadcast]
t2 on c1 = c2 join[shuffle] t3 on c2 = c3;"""
+ sql """shape plan select * from t1 right outer join [broadcast] t2 on
c1 = c2 join[shuffle] t3 on c2 = c3;"""
contains("UnUsed: [broadcast]_1")
}
explain {
- sql """shape plan select count(*) from t1 join [shuffle] t2 on c1 = c2
right outer join[broadcast] t3 on c2 = c3;"""
+ sql """shape plan select * from t1 join [shuffle] t2 on c1 = c2 right
outer join[broadcast] t3 on c2 = c3;"""
contains("UnUsed: [broadcast]_2")
}
// leading + distribute hint outside leading + single hint
explain {
- sql """shape plan select /*+ leading(t1 t2 t3) */ count(*) from t1
join [broadcast] t2 on c1 = c2 join[shuffle] t3 on c2 = c3;"""
+ sql """shape plan select /*+ leading(t1 t2 t3) */ * from t1 join
[broadcast] t2 on c1 = c2 join[shuffle] t3 on c2 = c3;"""
contains("UnUsed: [broadcast]_1 [shuffle]_2")
}
explain {
- sql """shape plan select /*+ leading(t1 t2 t3) */ count(*) from t1
right outer join [broadcast] t2 on c1 = c2 join[shuffle] t3 on c2 = c3;"""
+ sql """shape plan select /*+ leading(t1 t2 t3) */ * from t1 right
outer join [broadcast] t2 on c1 = c2 join[shuffle] t3 on c2 = c3;"""
contains("UnUsed: [broadcast]_1 [shuffle]_2")
}
explain {
- sql """shape plan select /*+ leading(t1 t2 t3) */ count(*) from t1
join [broadcast] t2 on c1 = c2 right outer join[shuffle] t3 on c2 = c3;"""
+ sql """shape plan select /*+ leading(t1 t2 t3) */ * from t1 join
[broadcast] t2 on c1 = c2 right outer join[shuffle] t3 on c2 = c3;"""
contains("UnUsed: [broadcast]_1 [shuffle]_2")
}
explain {
- sql """shape plan select /*+ leading(t1 t2 t3) */ count(*) from t1
join [shuffle] t2 on c1 = c2 right outer join[broadcast] t3 on c2 = c3;"""
+ sql """shape plan select /*+ leading(t1 t2 t3) */ * from t1 join
[shuffle] t2 on c1 = c2 right outer join[broadcast] t3 on c2 = c3;"""
contains("UnUsed: [shuffle]_1 [broadcast]_2")
}
// leading + distribute hint inside leading + single hint
// inner join
- qt_select92_1 """explain shape plan select /*+ leading(t1 shuffle t2
broadcast t3) */ count(*) from t1 join t2 on c1 = c2 join t3 on c2 = c3;"""
- qt_select92_2 """explain shape plan select /*+ leading(t1 shuffle {t2
broadcast t3}) */ count(*) from t1 join t2 on c1 = c2 join t3 on c2 = c3;"""
- qt_select92_3 """explain shape plan select /*+ leading(t1 shuffle {t3
broadcast t2}) */ count(*) from t1 join t2 on c1 = c2 join t3 on c2 = c3;"""
- qt_select92_4 """explain shape plan select /*+ leading(t2 shuffle t1
broadcast t3) */ count(*) from t1 join t2 on c1 = c2 join t3 on c2 = c3;"""
- qt_select92_5 """explain shape plan select /*+ leading(t2 shuffle {t1
broadcast t3}) */ count(*) from t1 join t2 on c1 = c2 join t3 on c2 = c3;"""
- qt_select92_6 """explain shape plan select /*+ leading(t2 shuffle {t3
broadcast t1}) */ count(*) from t1 join t2 on c1 = c2 join t3 on c2 = c3;"""
-
- qt_select93_1 """explain shape plan select /*+ leading(t1 broadcast t2
broadcast t3) */ count(*) from t1 join t2 on c1 = c2 join t3 on c2 = c3;"""
- qt_select93_2 """explain shape plan select /*+ leading(t1 broadcast {t2
broadcast t3}) */ count(*) from t1 join t2 on c1 = c2 join t3 on c2 = c3;"""
- qt_select93_3 """explain shape plan select /*+ leading(t1 broadcast {t3
broadcast t2}) */ count(*) from t1 join t2 on c1 = c2 join t3 on c2 = c3;"""
- qt_select93_4 """explain shape plan select /*+ leading(t2 broadcast t1
broadcast t3) */ count(*) from t1 join t2 on c1 = c2 join t3 on c2 = c3;"""
- qt_select93_5 """explain shape plan select /*+ leading(t2 broadcast {t1
broadcast t3}) */ count(*) from t1 join t2 on c1 = c2 join t3 on c2 = c3;"""
- qt_select93_6 """explain shape plan select /*+ leading(t2 broadcast {t3
broadcast t1}) */ count(*) from t1 join t2 on c1 = c2 join t3 on c2 = c3;"""
-
- qt_select94_2 """explain shape plan select /*+ leading(t1 shuffle t2
shuffle t3) */ count(*) from t1 join t2 on c1 = c2 join t3 on c2 = c3;"""
- qt_select94_2 """explain shape plan select /*+ leading(t1 shuffle {t2
shuffle t3}) */ count(*) from t1 join t2 on c1 = c2 join t3 on c2 = c3;"""
- qt_select94_2 """explain shape plan select /*+ leading(t1 shuffle {t3
shuffle t2}) */ count(*) from t1 join t2 on c1 = c2 join t3 on c2 = c3;"""
- qt_select94_2 """explain shape plan select /*+ leading(t2 shuffle t1
shuffle t3) */ count(*) from t1 join t2 on c1 = c2 join t3 on c2 = c3;"""
- qt_select94_2 """explain shape plan select /*+ leading(t2 shuffle {t1
shuffle t3}) */ count(*) from t1 join t2 on c1 = c2 join t3 on c2 = c3;"""
- qt_select94_2 """explain shape plan select /*+ leading(t2 shuffle {t3
shuffle t1}) */ count(*) from t1 join t2 on c1 = c2 join t3 on c2 = c3;"""
+ qt_select92_1 """explain shape plan select /*+ leading(t1 shuffle t2
broadcast t3) */ * from t1 join t2 on c1 = c2 join t3 on c2 = c3;"""
+ qt_select92_2 """explain shape plan select /*+ leading(t1 shuffle {t2
broadcast t3}) */ * from t1 join t2 on c1 = c2 join t3 on c2 = c3;"""
+ qt_select92_3 """explain shape plan select /*+ leading(t1 shuffle {t3
broadcast t2}) */ * from t1 join t2 on c1 = c2 join t3 on c2 = c3;"""
+ qt_select92_4 """explain shape plan select /*+ leading(t2 shuffle t1
broadcast t3) */ * from t1 join t2 on c1 = c2 join t3 on c2 = c3;"""
+ qt_select92_5 """explain shape plan select /*+ leading(t2 shuffle {t1
broadcast t3}) */ * from t1 join t2 on c1 = c2 join t3 on c2 = c3;"""
+ qt_select92_6 """explain shape plan select /*+ leading(t2 shuffle {t3
broadcast t1}) */ * from t1 join t2 on c1 = c2 join t3 on c2 = c3;"""
+
+ qt_select93_1 """explain shape plan select /*+ leading(t1 broadcast t2
broadcast t3) */ * from t1 join t2 on c1 = c2 join t3 on c2 = c3;"""
+ qt_select93_2 """explain shape plan select /*+ leading(t1 broadcast {t2
broadcast t3}) */ * from t1 join t2 on c1 = c2 join t3 on c2 = c3;"""
+ qt_select93_3 """explain shape plan select /*+ leading(t1 broadcast {t3
broadcast t2}) */ * from t1 join t2 on c1 = c2 join t3 on c2 = c3;"""
+ qt_select93_4 """explain shape plan select /*+ leading(t2 broadcast t1
broadcast t3) */ * from t1 join t2 on c1 = c2 join t3 on c2 = c3;"""
+ qt_select93_5 """explain shape plan select /*+ leading(t2 broadcast {t1
broadcast t3}) */ * from t1 join t2 on c1 = c2 join t3 on c2 = c3;"""
+ qt_select93_6 """explain shape plan select /*+ leading(t2 broadcast {t3
broadcast t1}) */ * from t1 join t2 on c1 = c2 join t3 on c2 = c3;"""
+
+ qt_select94_2 """explain shape plan select /*+ leading(t1 shuffle t2
shuffle t3) */ * from t1 join t2 on c1 = c2 join t3 on c2 = c3;"""
+ qt_select94_2 """explain shape plan select /*+ leading(t1 shuffle {t2
shuffle t3}) */ * from t1 join t2 on c1 = c2 join t3 on c2 = c3;"""
+ qt_select94_2 """explain shape plan select /*+ leading(t1 shuffle {t3
shuffle t2}) */ * from t1 join t2 on c1 = c2 join t3 on c2 = c3;"""
+ qt_select94_2 """explain shape plan select /*+ leading(t2 shuffle t1
shuffle t3) */ * from t1 join t2 on c1 = c2 join t3 on c2 = c3;"""
+ qt_select94_2 """explain shape plan select /*+ leading(t2 shuffle {t1
shuffle t3}) */ * from t1 join t2 on c1 = c2 join t3 on c2 = c3;"""
+ qt_select94_2 """explain shape plan select /*+ leading(t2 shuffle {t3
shuffle t1}) */ * from t1 join t2 on c1 = c2 join t3 on c2 = c3;"""
// outer join
- qt_select95_1 """explain shape plan select /*+ leading(t1 broadcast t2
broadcast t3) */ count(*) from t1 left outer join t2 on c1 = c2 join t3 on c2 =
c3;"""
+ qt_select95_1 """explain shape plan select /*+ leading(t1 broadcast t2
broadcast t3) */ * from t1 left outer join t2 on c1 = c2 join t3 on c2 = c3;"""
explain {
- sql """shape plan select /*+ leading(t1 broadcast {t2 t3}) */ count(*)
from t1 left outer join t2 on c1 = c2 join t3 on c2 = c3;"""
+ sql """shape plan select /*+ leading(t1 broadcast {t2 t3}) */ * from
t1 left outer join t2 on c1 = c2 join t3 on c2 = c3;"""
contains("UnUsed: leading(t1 broadcast { t2 t3 })")
}
explain {
- sql """shape plan select /*+ leading(t1 broadcast {t3 t2}) */ count(*)
from t1 left outer join t2 on c1 = c2 join t3 on c2 = c3;"""
+ sql """shape plan select /*+ leading(t1 broadcast {t3 t2}) */ * from
t1 left outer join t2 on c1 = c2 join t3 on c2 = c3;"""
contains("UnUsed: leading(t1 broadcast { t3 t2 })")
}
- qt_select95_4 """explain shape plan select /*+ leading(t2 broadcast t1
broadcast t3) */ count(*) from t1 left outer join t2 on c1 = c2 join t3 on c2 =
c3;"""
+ qt_select95_4 """explain shape plan select /*+ leading(t2 broadcast t1
broadcast t3) */ * from t1 left outer join t2 on c1 = c2 join t3 on c2 = c3;"""
explain {
- sql """shape plan select /*+ leading(t2 broadcast {t1 t3}) */ count(*)
from t1 left outer join t2 on c1 = c2 join t3 on c2 = c3;"""
+ sql """shape plan select /*+ leading(t2 broadcast {t1 t3}) */ * from
t1 left outer join t2 on c1 = c2 join t3 on c2 = c3;"""
contains("UnUsed: leading(t2 broadcast { t1 t3 })")
}
explain {
- sql """shape plan select /*+ leading(t2 broadcast {t3 t1}) */ count(*)
from t1 left outer join t2 on c1 = c2 join t3 on c2 = c3;"""
+ sql """shape plan select /*+ leading(t2 broadcast {t3 t1}) */ * from
t1 left outer join t2 on c1 = c2 join t3 on c2 = c3;"""
contains("UnUsed: leading(t2 broadcast { t3 t1 })")
}
explain {
- sql """shape plan select /*+ leading(t3 broadcast t1 t2) */ count(*)
from t1 left outer join t2 on c1 = c2 join t3 on c2 = c3;"""
+ sql """shape plan select /*+ leading(t3 broadcast t1 t2) */ * from t1
left outer join t2 on c1 = c2 join t3 on c2 = c3;"""
contains("UnUsed: leading(t3 broadcast t1 t2)")
}
- qt_select95_8 """explain shape plan select /*+ leading(t3 broadcast {t1
broadcast t2}) */ count(*) from t1 left outer join t2 on c1 = c2 join t3 on c2
= c3;"""
- qt_select95_9 """explain shape plan select /*+ leading(t3 broadcast {t2
broadcast t1}) */ count(*) from t1 left outer join t2 on c1 = c2 join t3 on c2
= c3;"""
+ qt_select95_8 """explain shape plan select /*+ leading(t3 broadcast {t1
broadcast t2}) */ * from t1 left outer join t2 on c1 = c2 join t3 on c2 = c3;"""
+ qt_select95_9 """explain shape plan select /*+ leading(t3 broadcast {t2
broadcast t1}) */ * from t1 left outer join t2 on c1 = c2 join t3 on c2 = c3;"""
- qt_select96_1 """explain shape plan select /*+ leading(t1 shuffle t2
broadcast t3) */ count(*) from t1 left outer join t2 on c1 = c2 join t3 on c2 =
c3;"""
+ qt_select96_1 """explain shape plan select /*+ leading(t1 shuffle t2
broadcast t3) */ * from t1 left outer join t2 on c1 = c2 join t3 on c2 = c3;"""
explain {
- sql """shape plan select /*+ leading(t1 shuffle {t2 broadcast t3}) */
count(*) from t1 left outer join t2 on c1 = c2 join t3 on c2 = c3;"""
+ sql """shape plan select /*+ leading(t1 shuffle {t2 broadcast t3}) */
* from t1 left outer join t2 on c1 = c2 join t3 on c2 = c3;"""
contains("UnUsed: leading(t1 shuffle { t2 broadcast t3 })")
}
explain {
- sql """shape plan select /*+ leading(t1 shuffle {t3 broadcast t2}) */
count(*) from t1 left outer join t2 on c1 = c2 join t3 on c2 = c3;"""
+ sql """shape plan select /*+ leading(t1 shuffle {t3 broadcast t2}) */
* from t1 left outer join t2 on c1 = c2 join t3 on c2 = c3;"""
contains("UnUsed: leading(t1 shuffle { t3 broadcast t2 })")
}
- qt_select96_4 """explain shape plan select /*+ leading(t2 shuffle t1
broadcast t3) */ count(*) from t1 left outer join t2 on c1 = c2 join t3 on c2 =
c3;"""
+ qt_select96_4 """explain shape plan select /*+ leading(t2 shuffle t1
broadcast t3) */ * from t1 left outer join t2 on c1 = c2 join t3 on c2 = c3;"""
explain {
- sql """shape plan select /*+ leading(t2 shuffle {t1 broadcast t3}) */
count(*) from t1 left outer join t2 on c1 = c2 join t3 on c2 = c3;"""
+ sql """shape plan select /*+ leading(t2 shuffle {t1 broadcast t3}) */
* from t1 left outer join t2 on c1 = c2 join t3 on c2 = c3;"""
contains("UnUsed: leading(t2 shuffle { t1 broadcast t3 })")
}
explain {
- sql """shape plan select /*+ leading(t2 shuffle {t3 broadcast t1}) */
count(*) from t1 left outer join t2 on c1 = c2 join t3 on c2 = c3;"""
+ sql """shape plan select /*+ leading(t2 shuffle {t3 broadcast t1}) */
* from t1 left outer join t2 on c1 = c2 join t3 on c2 = c3;"""
contains("UnUsed: leading(t2 shuffle { t3 broadcast t1 })")
}
explain {
- sql """shape plan select /*+ leading(t3 shuffle t1 broadcast t2) */
count(*) from t1 left outer join t2 on c1 = c2 join t3 on c2 = c3;"""
+ sql """shape plan select /*+ leading(t3 shuffle t1 broadcast t2) */ *
from t1 left outer join t2 on c1 = c2 join t3 on c2 = c3;"""
contains("UnUsed: leading(t3 shuffle t1 broadcast t2)")
}
- qt_select96_8 """explain shape plan select /*+ leading(t3 shuffle {t1
broadcast t2}) */ count(*) from t1 left outer join t2 on c1 = c2 join t3 on c2
= c3;"""
- qt_select96_9 """explain shape plan select /*+ leading(t3 shuffle {t2
broadcast t1}) */ count(*) from t1 left outer join t2 on c1 = c2 join t3 on c2
= c3;"""
+ qt_select96_8 """explain shape plan select /*+ leading(t3 shuffle {t1
broadcast t2}) */ * from t1 left outer join t2 on c1 = c2 join t3 on c2 = c3;"""
+ qt_select96_9 """explain shape plan select /*+ leading(t3 shuffle {t2
broadcast t1}) */ * from t1 left outer join t2 on c1 = c2 join t3 on c2 = c3;"""
- qt_select97_1 """explain shape plan select /*+ leading(t1 broadcast t2
shuffle t3) */ count(*) from t1 left outer join t2 on c1 = c2 join t3 on c2 =
c3;"""
+ qt_select97_1 """explain shape plan select /*+ leading(t1 broadcast t2
shuffle t3) */ * from t1 left outer join t2 on c1 = c2 join t3 on c2 = c3;"""
explain {
- sql """shape plan select /*+ leading(t1 broadcast {t2 shuffle t3}) */
count(*) from t1 left outer join t2 on c1 = c2 join t3 on c2 = c3;"""
+ sql """shape plan select /*+ leading(t1 broadcast {t2 shuffle t3}) */
* from t1 left outer join t2 on c1 = c2 join t3 on c2 = c3;"""
contains("UnUsed: leading(t1 broadcast { t2 shuffle t3 })")
}
explain {
- sql """shape plan select /*+ leading(t1 broadcast {t3 shuffle t2}) */
count(*) from t1 left outer join t2 on c1 = c2 join t3 on c2 = c3;"""
+ sql """shape plan select /*+ leading(t1 broadcast {t3 shuffle t2}) */
* from t1 left outer join t2 on c1 = c2 join t3 on c2 = c3;"""
contains("UnUsed: leading(t1 broadcast { t3 shuffle t2 })")
}
- qt_select97_4 """explain shape plan select /*+ leading(t2 broadcast t1
shuffle t3) */ count(*) from t1 left outer join t2 on c1 = c2 join t3 on c2 =
c3;"""
+ qt_select97_4 """explain shape plan select /*+ leading(t2 broadcast t1
shuffle t3) */ * from t1 left outer join t2 on c1 = c2 join t3 on c2 = c3;"""
explain {
- sql """shape plan select /*+ leading(t2 broadcast {t1 shuffle t3}) */
count(*) from t1 left outer join t2 on c1 = c2 join t3 on c2 = c3;"""
+ sql """shape plan select /*+ leading(t2 broadcast {t1 shuffle t3}) */
* from t1 left outer join t2 on c1 = c2 join t3 on c2 = c3;"""
contains("UnUsed: leading(t2 broadcast { t1 shuffle t3 })")
}
explain {
- sql """shape plan select /*+ leading(t2 broadcast {t3 shuffle t1}) */
count(*) from t1 left outer join t2 on c1 = c2 join t3 on c2 = c3;"""
+ sql """shape plan select /*+ leading(t2 broadcast {t3 shuffle t1}) */
* from t1 left outer join t2 on c1 = c2 join t3 on c2 = c3;"""
contains("UnUsed: leading(t2 broadcast { t3 shuffle t1 })")
}
explain {
- sql """shape plan select /*+ leading(t3 broadcast t1 shuffle t2) */
count(*) from t1 left outer join t2 on c1 = c2 join t3 on c2 = c3;"""
+ sql """shape plan select /*+ leading(t3 broadcast t1 shuffle t2) */ *
from t1 left outer join t2 on c1 = c2 join t3 on c2 = c3;"""
contains("UnUsed: leading(t3 broadcast t1 shuffle t2)")
}
- qt_select97_8 """explain shape plan select /*+ leading(t3 broadcast {t1
shuffle t2}) */ count(*) from t1 left outer join t2 on c1 = c2 join t3 on c2 =
c3;"""
- qt_select97_9 """explain shape plan select /*+ leading(t3 broadcast {t2
shuffle t1}) */ count(*) from t1 left outer join t2 on c1 = c2 join t3 on c2 =
c3;"""
+ qt_select97_8 """explain shape plan select /*+ leading(t3 broadcast {t1
shuffle t2}) */ * from t1 left outer join t2 on c1 = c2 join t3 on c2 = c3;"""
+ qt_select97_9 """explain shape plan select /*+ leading(t3 broadcast {t2
shuffle t1}) */ * from t1 left outer join t2 on c1 = c2 join t3 on c2 = c3;"""
// distribute hint + leading hint
// only distribute hint + single hint
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
