Skip to content

Commit 3f5f778

Browse files
vdimirvdimir
committed
up reference
1 parent d7d3632 commit 3f5f778

File tree

4 files changed

+46
-46
lines changed

4 files changed

+46
-46
lines changed

‎tests/queries/0_stateless/03707_analyzer_convert_outer_any_to_inner.reference‎

Lines changed: 8 additions & 8 deletions
Original file line numberDiff line numberDiff line change
@@ -22,18 +22,18 @@ Positions: 3 0 1
2222
Locality: UNSPECIFIED
2323
Expression: equals(__table2.__table1.name, __table1.name)
2424
Expression:
25-
Actions: INPUT : 0 -> __table2.__table1.name String : 0
26-
INPUT : 1 -> __table1.name String : 1
27-
INPUT :: 2 -> __table2 Nullable(Int64) : 2
28-
INPUT :: 3 -> __table1.uid Int16 : 3
25+
Actions: INPUT :: 0 -> __table2 Nullable(Int64) : 0
26+
INPUT : 1 -> __table2.__table1.name String : 1
27+
INPUT :: 2 -> __table1.uid Int16 : 2
28+
INPUT : 3 -> __table1.name String : 3
2929
INPUT :: 4 -> __table1.age Int16 : 4
30-
FUNCTION equals(__table2.__table1.name :: 0, __table1.name : 1) -> equals(__table2.__table1.name, __table1.name) UInt8 : 5
31-
Positions: 2 3 1 4
30+
FUNCTION equals(__table2.__table1.name :: 1, __table1.name : 3) -> equals(__table2.__table1.name, __table1.name) UInt8 : 5
31+
Positions: 0 2 3 4
3232
Expression Sources:
33-
__table2.__table1.name: {0}
34-
__table1.name: {1}
3533
__table2: {0}
34+
__table2.__table1.name: {0}
3635
__table1.uid: {1}
36+
__table1.name: {1}
3737
__table1.age: {1}
3838
Expression ((Create renaming actions for scalar subquery + (Create correlated subquery result alias + (Project names + Projection))))
3939
Actions: INPUT : 0 -> sum(__table3.age) Int64 : 0

‎tests/queries/0_stateless/03707_analyzer_convert_outer_any_to_inner.sql‎

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -1,6 +1,6 @@
11
SET enable_analyzer = 1;
22
SET enable_parallel_replicas = 0;
3-
SET query_plan_join_swap_table = 0; -- Changes query plan
3+
SET query_plan_join_swap_table = 0, query_plan_optimize_join_order_limit = 1; -- Changes query plan
44

55
CREATE TABLE users (uid Int16, name String, age Int16) ENGINE=Memory;
66

‎tests/queries/0_stateless/03708_analyzer_convert_any_outer_to_inner_2.reference‎

Lines changed: 36 additions & 36 deletions
Original file line numberDiff line numberDiff line change
@@ -27,19 +27,19 @@ Positions: 5 0 1 2 3
2727
Locality: UNSPECIFIED
2828
Expression: equals(__table1.name, __table2.name)
2929
Expression:
30-
Actions: INPUT : 0 -> __table1.name String : 0
31-
INPUT : 1 -> __table2.name String : 1
32-
INPUT :: 2 -> __table1.uid Int16 : 2
33-
INPUT :: 3 -> __table1.age Int16 : 3
34-
INPUT :: 4 -> __table2.age_sum Nullable(Int64) : 4
35-
FUNCTION equals(__table1.name : 0, __table2.name : 1) -> equals(__table1.name, __table2.name) UInt8 : 5
36-
Positions: 2 0 3 4 1
30+
Actions: INPUT :: 0 -> __table1.uid Int16 : 0
31+
INPUT : 1 -> __table1.name String : 1
32+
INPUT :: 2 -> __table1.age Int16 : 2
33+
INPUT :: 3 -> __table2.age_sum Nullable(Int64) : 3
34+
INPUT : 4 -> __table2.name String : 4
35+
FUNCTION equals(__table1.name : 1, __table2.name : 4) -> equals(__table1.name, __table2.name) UInt8 : 5
36+
Positions: 0 1 2 3 4
3737
Expression Sources:
38-
__table1.name: {0}
39-
__table2.name: {1}
4038
__table1.uid: {0}
39+
__table1.name: {0}
4140
__table1.age: {0}
4241
__table2.age_sum: {1}
42+
__table2.name: {1}
4343
Expression (Change column names to column identifiers)
4444
Actions: INPUT : 0 -> uid Int16 : 0
4545
INPUT : 1 -> name String : 1
@@ -102,19 +102,19 @@ Positions: 5 0 1 2 3
102102
Locality: UNSPECIFIED
103103
Expression: equals(__table1.name, __table2.name)
104104
Expression:
105-
Actions: INPUT : 0 -> __table1.name String : 0
106-
INPUT : 1 -> __table2.name String : 1
107-
INPUT :: 2 -> __table1.uid Int16 : 2
108-
INPUT :: 3 -> __table1.age Int16 : 3
109-
INPUT :: 4 -> __table2.age_sum Nullable(Int64) : 4
110-
FUNCTION equals(__table1.name : 0, __table2.name : 1) -> equals(__table1.name, __table2.name) UInt8 : 5
111-
Positions: 2 0 3 4 1
105+
Actions: INPUT :: 0 -> __table1.uid Int16 : 0
106+
INPUT : 1 -> __table1.name String : 1
107+
INPUT :: 2 -> __table1.age Int16 : 2
108+
INPUT :: 3 -> __table2.age_sum Nullable(Int64) : 3
109+
INPUT : 4 -> __table2.name String : 4
110+
FUNCTION equals(__table1.name : 1, __table2.name : 4) -> equals(__table1.name, __table2.name) UInt8 : 5
111+
Positions: 0 1 2 3 4
112112
Expression Sources:
113-
__table1.name: {0}
114-
__table2.name: {1}
115113
__table1.uid: {0}
114+
__table1.name: {0}
116115
__table1.age: {0}
117116
__table2.age_sum: {1}
117+
__table2.name: {1}
118118
Expression (Change column names to column identifiers)
119119
Actions: INPUT : 0 -> uid Int16 : 0
120120
INPUT : 1 -> name String : 1
@@ -179,19 +179,19 @@ Positions: 5 0 1 2 3
179179
Locality: UNSPECIFIED
180180
Expression: equals(__table1.name, __table2.name)
181181
Expression:
182-
Actions: INPUT : 0 -> __table1.name String : 0
183-
INPUT : 1 -> __table2.name String : 1
184-
INPUT :: 2 -> __table1.uid Int16 : 2
185-
INPUT :: 3 -> __table1.age Int16 : 3
186-
INPUT :: 4 -> __table2.age_sum Nullable(Int64) : 4
187-
FUNCTION equals(__table1.name : 0, __table2.name : 1) -> equals(__table1.name, __table2.name) UInt8 : 5
188-
Positions: 2 0 3 4 1
182+
Actions: INPUT :: 0 -> __table1.uid Int16 : 0
183+
INPUT : 1 -> __table1.name String : 1
184+
INPUT :: 2 -> __table1.age Int16 : 2
185+
INPUT :: 3 -> __table2.age_sum Nullable(Int64) : 3
186+
INPUT : 4 -> __table2.name String : 4
187+
FUNCTION equals(__table1.name : 1, __table2.name : 4) -> equals(__table1.name, __table2.name) UInt8 : 5
188+
Positions: 0 1 2 3 4
189189
Expression Sources:
190-
__table1.name: {0}
191-
__table2.name: {1}
192190
__table1.uid: {0}
191+
__table1.name: {0}
193192
__table1.age: {0}
194193
__table2.age_sum: {1}
194+
__table2.name: {1}
195195
Expression (Change column names to column identifiers)
196196
Actions: INPUT : 0 -> uid Int16 : 0
197197
INPUT : 1 -> name String : 1
@@ -256,19 +256,19 @@ Positions: 5 0 1 2 3
256256
Locality: UNSPECIFIED
257257
Expression: equals(__table1.name, __table2.name)
258258
Expression:
259-
Actions: INPUT : 0 -> __table1.name String : 0
260-
INPUT : 1 -> __table2.name String : 1
261-
INPUT :: 2 -> __table1.uid Int16 : 2
262-
INPUT :: 3 -> __table1.age Int16 : 3
263-
INPUT :: 4 -> __table2.age_sum Nullable(Int64) : 4
264-
FUNCTION equals(__table1.name : 0, __table2.name : 1) -> equals(__table1.name, __table2.name) UInt8 : 5
265-
Positions: 2 0 3 4 1
259+
Actions: INPUT :: 0 -> __table1.uid Int16 : 0
260+
INPUT : 1 -> __table1.name String : 1
261+
INPUT :: 2 -> __table1.age Int16 : 2
262+
INPUT :: 3 -> __table2.age_sum Nullable(Int64) : 3
263+
INPUT : 4 -> __table2.name String : 4
264+
FUNCTION equals(__table1.name : 1, __table2.name : 4) -> equals(__table1.name, __table2.name) UInt8 : 5
265+
Positions: 0 1 2 3 4
266266
Expression Sources:
267-
__table1.name: {0}
268-
__table2.name: {1}
269267
__table1.uid: {0}
268+
__table1.name: {0}
270269
__table1.age: {0}
271270
__table2.age_sum: {1}
271+
__table2.name: {1}
272272
Expression (Change column names to column identifiers)
273273
Actions: INPUT : 0 -> uid Int16 : 0
274274
INPUT : 1 -> name String : 1

‎tests/queries/0_stateless/03708_analyzer_convert_any_outer_to_inner_2.sql‎

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -1,6 +1,6 @@
11
SET enable_analyzer = 1;
22
SET enable_parallel_replicas = 0;
3-
SET query_plan_join_swap_table = 0; -- Changes query plan
3+
SET query_plan_join_swap_table = 0, query_plan_optimize_join_order_limit = 1; -- Changes query plan
44

55
CREATE TABLE users (uid Int16, name String, age Int16) ENGINE=Memory;
66

0 commit comments

Comments
 (0)