====
---- QUERY
#########################################################
# Additonal test cases for Decimal Min Max Filters
# Covers the following:
# 1.  Inner Join with broadcast (2 tables) with 4 predicates
#     all results in decimal min-max filter
# 2.  Inner Join with broadcast (2 tables) with 4 predicates
#     3 results in decimal min=max filter; 1 doesn't
# 3.  Inner Join with Shuffle (3 tables)
# 4.  Right outer join (2 tables)
# 5.  Left Semi join (2 tables)
# 6.  Right Semi join (2 tables)
#
# Test case 1.1: Decimal Min-max filters multiple 4 bytes
#########################################################
SET RUNTIME_FILTER_WAIT_TIME_MS=$RUNTIME_FILTER_WAIT_TIME_MS;
select STRAIGHT_JOIN a.d5_0, a.d5_1, a.d5_3, a.d5_5
from decimal_rtf_tbl a
join [BROADCAST] decimal_rtf_tiny_tbl b
where a.d5_0 = b.d5_0
and a.d5_1 = b.d5_1
and a.d5_3 = b.d5_3
and a.d5_5 = b.d5_5
order by 1
---- RESULTS: VERIFY_IS_EQUAL_SORTED
1,1.0,1.000,0.00000
2,0.2,0.200,0.20000
3,0.3,0.030,0.03000
4,0.4,0.004,0.00400
5,0.5,0.005,0.00050
6,0.6,0.006,0.00006
11,1.1,0.011,0.00011
18,1.8,0.018,0.00018
19,1.9,0.019,0.00019
27,2.7,0.027,0.00027
28,2.8,0.028,0.00028
29,2.9,0.029,0.00029
38,3.8,0.038,0.00038
39,3.9,0.039,0.00039
49,4.9,0.049,0.00049
78,7.8,0.078,0.00078
89,8.9,0.089,0.00089
91,9.1,0.091,0.00091
167,16.7,0.167,0.00167
178,17.8,0.178,0.00178
222,22.2,0.222,0.00222
223,22.3,0.223,0.00223
333,33.3,0.333,0.00333
334,33.4,0.334,0.00334
444,44.4,0.444,0.00444
445,44.5,0.445,0.00445
555,55.5,0.555,0.00555
556,55.6,0.556,0.00556
666,66.6,0.666,0.00666
667,66.7,0.667,0.00667
777,77.7,0.777,0.00777
888,88.8,0.888,0.00888
999,99.9,0.999,0.00999
1111,111.1,1.111,0.01111
1112,111.2,1.112,0.01112
7789,778.9,7.789,0.07789
8891,889.1,8.891,0.08891
9912,991.2,9.912,0.09912
---- TYPES
DECIMAL, DECIMAL, DECIMAL, DECIMAL
---- RUNTIME_PROFILE
aggregation(SUM, ProbeRows): 102
====
---- QUERY
#########################################################
# Test case 1.2: Decimal Min-max filters multiple 4 bytes
#########################################################
SET RUNTIME_FILTER_WAIT_TIME_MS=$RUNTIME_FILTER_WAIT_TIME_MS;
select STRAIGHT_JOIN a.d9_0, a.d9_1, a.d9_5, a.d9_9
from decimal_rtf_tbl a
join [BROADCAST] decimal_rtf_tiny_tbl b
where a.d9_0 = b.d9_0
and a.d9_1 = b.d9_1
and a.d9_5 = b.d9_5
and a.d9_9 = b.d9_9
order by 1
---- RESULTS: VERIFY_IS_EQUAL_SORTED
1,1.0,1.00000,0.000000000
2,0.2,0.20000,0.200000000
3,0.3,0.03000,0.030000000
4,0.4,0.00400,0.004000000
5,0.5,0.00050,0.000500000
6,0.6,0.00006,0.000060000
11,1.1,0.00011,0.000000011
18,1.8,0.00018,0.000000018
19,1.9,0.00019,0.000000019
27,2.7,0.00027,0.000000027
28,2.8,0.00028,0.000000028
29,2.9,0.00029,0.000000029
38,3.8,0.00038,0.000000038
39,3.9,0.00039,0.000000039
49,4.9,0.00049,0.000000049
78,7.8,0.00078,0.000078000
89,8.9,0.00089,0.000008900
91,9.1,0.00091,0.000000910
167,16.7,0.00167,0.000000167
178,17.8,0.00178,0.000000178
222,22.2,0.00222,0.000000222
223,22.3,0.00223,0.000000223
333,33.3,0.00333,0.000000333
334,33.4,0.00334,0.000000334
444,44.4,0.00444,0.000000444
445,44.5,0.00445,0.000000445
555,55.5,0.00555,0.000000555
556,55.6,0.00556,0.000000556
666,66.6,0.00666,0.000000666
667,66.7,0.00667,0.000000667
777,77.7,0.00777,0.000000777
888,88.8,0.00888,0.000000888
999,99.9,0.00999,0.000000999
1111,111.1,0.01111,0.000001111
1112,111.2,0.01112,0.000001112
7789,778.9,0.07789,0.000007789
8891,889.1,0.08891,0.000008891
9912,991.2,0.09912,0.000009912
---- TYPES
DECIMAL, DECIMAL, DECIMAL, DECIMAL
---- RUNTIME_PROFILE
aggregation(SUM, ProbeRows): 99
====
---- QUERY
#########################################################
# Test case 1.3: Decimal Min-max filters multiple 8 bytes
#########################################################
SET RUNTIME_FILTER_WAIT_TIME_MS=$RUNTIME_FILTER_WAIT_TIME_MS;
select STRAIGHT_JOIN a.d14_0, a.d14_1, a.d14_7, a.d14_14
from decimal_rtf_tbl a
join [BROADCAST] decimal_rtf_tiny_tbl b
where a.d14_0 = b.d14_0
and a.d14_1 = b.d14_1
and a.d14_7 = b.d14_7
and a.d14_14 = b.d14_14
order by 1
---- RESULTS: VERIFY_IS_EQUAL_SORTED
1,1.0,1.0000000,0.00000000000000
2,0.2,0.2000000,0.20000000000000
3,0.3,0.0300000,0.03000000000000
4,0.4,0.0040000,0.00400000000000
5,0.5,0.0005000,0.00050000000000
6,0.6,0.0000600,0.00006000000000
11,1.1,0.0000011,0.00000001100000
18,1.8,0.0000018,0.00000000000018
19,1.9,0.0000019,0.00000000000019
27,2.7,0.0000027,0.00000000000027
28,2.8,0.0000028,0.00000000000028
29,2.9,0.0000029,0.00000000000029
38,3.8,0.0000038,0.00000000000038
39,3.9,0.0000039,0.00000000000039
49,4.9,0.0000049,0.00000000000049
78,7.8,0.0000780,0.00007800000000
89,8.9,0.0000089,0.00000890000000
91,9.1,0.0000091,0.00000091000000
167,16.7,0.0000167,0.00000000000167
178,17.8,0.0000178,0.00000000000178
222,22.2,0.0000222,0.00000000000222
223,22.3,0.0000223,0.00000002230000
333,33.3,0.0000333,0.00000000000333
334,33.4,0.0000334,0.00000000334000
444,44.4,0.0000444,0.00000000000444
445,44.5,0.0000445,0.00000000044500
555,55.5,0.0000555,0.00000000000555
556,55.6,0.0000556,0.00000000005560
666,66.6,0.0000666,0.00000000000666
667,66.7,0.0000667,0.00000000000667
777,77.7,0.0000777,0.00000000000777
888,88.8,0.0000888,0.00000000000888
999,99.9,0.0000999,0.00000000000999
1111,111.1,0.0001111,0.00000000001111
1112,111.2,0.0001112,0.00000000001112
7789,778.9,0.0007789,0.00000000007789
8891,889.1,0.0008891,0.00000000008891
9912,991.2,0.0009912,0.00000000009912
---- TYPES
DECIMAL, DECIMAL, DECIMAL, DECIMAL
---- RUNTIME_PROFILE
aggregation(SUM, ProbeRows): 97
====
---- QUERY
#########################################################
# Test case 1.4: Decimal Min-max filters multiple 8 bytes
#########################################################
SET RUNTIME_FILTER_WAIT_TIME_MS=$RUNTIME_FILTER_WAIT_TIME_MS;
select STRAIGHT_JOIN a.d18_0, a.d18_1, a.d18_9, a.d18_18
from decimal_rtf_tbl a
join [BROADCAST] decimal_rtf_tiny_tbl b
where a.d18_0 = b.d18_0
and a.d18_1 = b.d18_1
and a.d18_9 = b.d18_9
and a.d18_18 = b.d18_18
order by 1
---- RESULTS: VERIFY_IS_EQUAL_SORTED
1,1.0,1.000000000,0.000000000000000000
2,0.2,0.200000000,0.200000000000000000
3,0.3,0.030000000,0.030000000000000000
4,0.4,0.004000000,0.004000000000000000
5,0.5,0.000500000,0.000500000000000000
6,0.6,0.000060000,0.000060000000000000
11,1.1,0.000000011,0.000000011000000000
18,1.8,0.000000018,0.000000000000000018
19,1.9,0.000000019,0.000000000000000019
27,2.7,0.000000027,0.000000000000000027
28,2.8,0.000000028,0.000000000000000028
29,2.9,0.000000029,0.000000000000000029
38,3.8,0.000000038,0.000000000000000038
39,3.9,0.000000039,0.000000000000000039
49,4.9,0.000000049,0.000000000000000049
78,7.8,0.000078000,0.000078000000000000
89,8.9,0.000008900,0.000008900000000000
91,9.1,0.000000910,0.000000910000000000
167,16.7,0.000000167,0.000000000000000167
178,17.8,0.000000178,0.000000000000000178
222,22.2,0.000000222,0.000000000000000222
223,22.3,0.000000223,0.000000022300000000
333,33.3,0.000000333,0.000000000000000333
334,33.4,0.000000334,0.000000003340000000
444,44.4,0.000000444,0.000000000000000444
445,44.5,0.000000445,0.000000000445000000
555,55.5,0.000000555,0.000000000000000555
556,55.6,0.000000556,0.000000000055600000
666,66.6,0.000000666,0.000000000000000666
667,66.7,0.000000667,0.000000000006670000
777,77.7,0.000000777,0.000000000000000777
888,88.8,0.000000888,0.000000000000000888
999,99.9,0.000000999,0.000000000000000999
1111,111.1,0.000001111,0.000000000000001111
1112,111.2,0.000001112,0.000000000000001112
7789,778.9,0.000007789,0.000000000007789000
8891,889.1,0.000008891,0.000000000000889100
9912,991.2,0.000009912,0.000000000000099120
---- TYPES
DECIMAL, DECIMAL, DECIMAL, DECIMAL
---- RUNTIME_PROFILE
aggregation(SUM, ProbeRows): 99
====
---- QUERY
##########################################################
# Test case 1.5: Decimal Min-max filters multiple 16 bytes
##########################################################
SET RUNTIME_FILTER_WAIT_TIME_MS=$RUNTIME_FILTER_WAIT_TIME_MS;
select STRAIGHT_JOIN a.d28_0, a.d28_1, a.d28_14, a.d28_28
from decimal_rtf_tbl a
join [BROADCAST] decimal_rtf_tiny_tbl b
where a.d28_0 = b.d28_0
and a.d28_1 = b.d28_1
and a.d28_14 = b.d28_14
and a.d28_28 = b.d28_28
order by 1
---- RESULTS: VERIFY_IS_EQUAL_SORTED
1,1.0,1.00000000000000,0.0000000000000000000000000000
2,0.2,0.20000000000000,0.2000000000000000000000000000
3,0.3,0.03000000000000,0.0300000000000000000000000000
4,0.4,0.00400000000000,0.0040000000000000000000000000
5,0.5,0.00050000000000,0.0005000000000000000000000000
6,0.6,0.00006000000000,0.0000600000000000000000000000
11,1.1,0.00000001100000,0.0000000110000000000000000000
18,1.8,0.00000000000018,0.0000000000000000000000000018
19,1.9,0.00000000000019,0.0000000000000000000000000019
27,2.7,0.00000000000027,0.0000000000000000000000000027
28,2.8,0.00000000000028,0.0000000000000000000000000028
29,2.9,0.00000000000029,0.0000000000000000000000000029
38,3.8,0.00000000000038,0.0000000000000000000000000038
39,3.9,0.00000000000039,0.0000000000000000000000000039
49,4.9,0.00000000000049,0.0000000000000000000000000049
78,7.8,0.00007800000000,0.0000780000000000000000000000
89,8.9,0.00000890000000,0.0000089000000000000000000000
91,9.1,0.00000091000000,0.0000009100000000000000000000
167,16.7,0.00000000000167,0.0000000000000000000000001670
178,17.8,0.00000000000178,0.0000000000000000000000000178
222,22.2,0.00000000000222,0.0000000000000000222000000000
223,22.3,0.00000002230000,0.0000000223000000000000000000
333,33.3,0.00000000000333,0.0000000000000000033300000000
334,33.4,0.00000000334000,0.0000000033400000000000000000
444,44.4,0.00000000000444,0.0000000000000000004440000000
445,44.5,0.00000000044500,0.0000000004450000000000000000
555,55.5,0.00000000000555,0.0000000000000000000555000000
556,55.6,0.00000000005560,0.0000000000556000000000000000
666,66.6,0.00000000000666,0.0000000000000000000066600000
667,66.7,0.00000000000667,0.0000000000066700000000000000
777,77.7,0.00000000000777,0.0000000000000000000007770000
888,88.8,0.00000000000888,0.0000000000000000000000888000
999,99.9,0.00000000000999,0.0000000000000000000000099900
1111,111.1,0.00000000001111,0.0000000000000000000000001111
1112,111.2,0.00000000001112,0.0000000000000011120000000000
7789,778.9,0.00000000007789,0.0000000000077890000000000000
8891,889.1,0.00000000008891,0.0000000000008891000000000000
9912,991.2,0.00000000009912,0.0000000000000991200000000000
---- TYPES
DECIMAL, DECIMAL, DECIMAL, DECIMAL
---- RUNTIME_PROFILE
aggregation(SUM, ProbeRows): 97
====
---- QUERY
##########################################################
# Test case 1.6: Decimal Min-max filters multiple 16 bytes
##########################################################
SET RUNTIME_FILTER_WAIT_TIME_MS=$RUNTIME_FILTER_WAIT_TIME_MS;
select STRAIGHT_JOIN a.d38_0, a.d38_1, a.d38_19, a.d38_38
from decimal_rtf_tbl a
join [BROADCAST] decimal_rtf_tiny_tbl b
where a.d38_0 = b.d38_0
and a.d38_1 = b.d38_1
and a.d38_19 = b.d38_19
and a.d38_38 = b.d38_38
order by 1
---- RESULTS: VERIFY_IS_EQUAL_SORTED
1,1.0,1.0000000000000000000,0.00000000000000000000000000000000000000
2,0.2,0.2000000000000000000,0.20000000000000000000000000000000000000
3,0.3,0.0300000000000000000,0.03000000000000000000000000000000000000
4,0.4,0.0040000000000000000,0.00400000000000000000000000000000000000
5,0.5,0.0005000000000000000,0.00050000000000000000000000000000000000
6,0.6,0.0000600000000000000,0.00006000000000000000000000000000000000
11,1.1,0.0000000110000000000,0.00000001100000000000000000000000000000
18,1.8,0.0000000000000000018,0.00000000000000000000000000001800000000
19,1.9,0.0000000000000000019,0.00000000000000000000000000000190000000
27,2.7,0.0000000000000000027,0.00000000000000000000000000000027000000
28,2.8,0.0000000000000000028,0.00000000000000000000000000000002800000
29,2.9,0.0000000000000000029,0.00000000000000000000000000000000290000
38,3.8,0.0000000000000000038,0.00000000000000000000000000000000038000
39,3.9,0.0000000000000000039,0.00000000000000000000000000000000003900
49,4.9,0.0000000000000000049,0.00000000000000000000000000000000000490
78,7.8,0.0000780000000000000,0.00007800000000000000000000000000000000
89,8.9,0.0000089000000000000,0.00000890000000000000000000000000000000
91,9.1,0.0000009100000000000,0.00000091000000000000000000000000000000
167,16.7,0.0000000000000000167,0.00000000000000000000000016700000000000
178,17.8,0.0000000000000000178,0.00000000000000000000000001780000000000
222,22.2,0.0000000000000000222,0.00000000000000002220000000000000000000
223,22.3,0.0000000223000000000,0.00000002230000000000000000000000000000
333,33.3,0.0000000000000000333,0.00000000000000000333000000000000000000
334,33.4,0.0000000033400000000,0.00000000334000000000000000000000000000
444,44.4,0.0000000000000000444,0.00000000000000000044400000000000000000
445,44.5,0.0000000004450000000,0.00000000044500000000000000000000000000
555,55.5,0.0000000000000000555,0.00000000000000000005550000000000000000
556,55.6,0.0000000000556000000,0.00000000005560000000000000000000000000
666,66.6,0.0000000000000000666,0.00000000000000000000666000000000000000
667,66.7,0.0000000000066700000,0.00000000000667000000000000000000000000
777,77.7,0.0000000000000000777,0.00000000000000000000077700000000000000
888,88.8,0.0000000000000000888,0.00000000000000000000008880000000000000
999,99.9,0.0000000000000000999,0.00000000000000000000000999000000000000
1111,111.1,0.0000000000000001111,0.00000000000000000000000000000000001111
1112,111.2,0.0000000000000011120,0.00000000000000111200000000000000000000
7789,778.9,0.0000000000077890000,0.00000000000778900000000000000000000000
8891,889.1,0.0000000000008891000,0.00000000000088910000000000000000000000
9912,991.2,0.0000000000000991200,0.00000000000009912000000000000000000000
---- TYPES
DECIMAL, DECIMAL, DECIMAL, DECIMAL
---- RUNTIME_PROFILE
aggregation(SUM, ProbeRows): 97
====
---- QUERY
####################################################
# Test case 2.1: Decimal Min-max filters multiple
#   d5_0 = d9_0 uses cast and will not use minmax
#   filters.  The other 3 will.
####################################################
SET RUNTIME_FILTER_WAIT_TIME_MS=$RUNTIME_FILTER_WAIT_TIME_MS;
select STRAIGHT_JOIN a.d5_0, a.d5_1, a.d5_3, a.d5_5
from decimal_rtf_tbl a
join [BROADCAST] decimal_rtf_tiny_tbl b
where a.d5_0 = b.d9_0
and a.d5_1 = b.d5_1
and a.d5_3 = b.d5_3
and a.d5_5 = b.d5_5
order by 1
---- RESULTS: VERIFY_IS_EQUAL_SORTED
1,1.0,1.000,0.00000
2,0.2,0.200,0.20000
3,0.3,0.030,0.03000
4,0.4,0.004,0.00400
5,0.5,0.005,0.00050
6,0.6,0.006,0.00006
11,1.1,0.011,0.00011
18,1.8,0.018,0.00018
19,1.9,0.019,0.00019
27,2.7,0.027,0.00027
28,2.8,0.028,0.00028
29,2.9,0.029,0.00029
38,3.8,0.038,0.00038
39,3.9,0.039,0.00039
49,4.9,0.049,0.00049
78,7.8,0.078,0.00078
89,8.9,0.089,0.00089
91,9.1,0.091,0.00091
167,16.7,0.167,0.00167
178,17.8,0.178,0.00178
222,22.2,0.222,0.00222
223,22.3,0.223,0.00223
333,33.3,0.333,0.00333
334,33.4,0.334,0.00334
444,44.4,0.444,0.00444
445,44.5,0.445,0.00445
555,55.5,0.555,0.00555
556,55.6,0.556,0.00556
666,66.6,0.666,0.00666
667,66.7,0.667,0.00667
777,77.7,0.777,0.00777
888,88.8,0.888,0.00888
999,99.9,0.999,0.00999
1111,111.1,1.111,0.01111
1112,111.2,1.112,0.01112
7789,778.9,7.789,0.07789
8891,889.1,8.891,0.08891
9912,991.2,9.912,0.09912
---- TYPES
DECIMAL, DECIMAL, DECIMAL, DECIMAL
---- RUNTIME_PROFILE
aggregation(SUM, ProbeRows): 102
====
---- QUERY
####################################################
# Test case 2.2: Decimal Min-max filters multiple
#   d9_1 = d14_1 uses cast and will not use minmax
#   filters.  The other 3 will.
####################################################
SET RUNTIME_FILTER_WAIT_TIME_MS=$RUNTIME_FILTER_WAIT_TIME_MS;
select STRAIGHT_JOIN a.d9_0, a.d9_1, a.d9_5, a.d9_9
from decimal_rtf_tbl a
join [BROADCAST] decimal_rtf_tiny_tbl b
where a.d9_0 = b.d9_0
and a.d9_1 = b.d14_1
and a.d9_5 = b.d9_5
and a.d9_9 = b.d9_9
order by 1
---- RESULTS: VERIFY_IS_EQUAL_SORTED
1,1.0,1.00000,0.000000000
2,0.2,0.20000,0.200000000
3,0.3,0.03000,0.030000000
4,0.4,0.00400,0.004000000
5,0.5,0.00050,0.000500000
6,0.6,0.00006,0.000060000
11,1.1,0.00011,0.000000011
18,1.8,0.00018,0.000000018
19,1.9,0.00019,0.000000019
27,2.7,0.00027,0.000000027
28,2.8,0.00028,0.000000028
29,2.9,0.00029,0.000000029
38,3.8,0.00038,0.000000038
39,3.9,0.00039,0.000000039
49,4.9,0.00049,0.000000049
78,7.8,0.00078,0.000078000
89,8.9,0.00089,0.000008900
91,9.1,0.00091,0.000000910
167,16.7,0.00167,0.000000167
178,17.8,0.00178,0.000000178
222,22.2,0.00222,0.000000222
223,22.3,0.00223,0.000000223
333,33.3,0.00333,0.000000333
334,33.4,0.00334,0.000000334
444,44.4,0.00444,0.000000444
445,44.5,0.00445,0.000000445
555,55.5,0.00555,0.000000555
556,55.6,0.00556,0.000000556
666,66.6,0.00666,0.000000666
667,66.7,0.00667,0.000000667
777,77.7,0.00777,0.000000777
888,88.8,0.00888,0.000000888
999,99.9,0.00999,0.000000999
1111,111.1,0.01111,0.000001111
1112,111.2,0.01112,0.000001112
7789,778.9,0.07789,0.000007789
8891,889.1,0.08891,0.000008891
9912,991.2,0.09912,0.000009912
---- TYPES
DECIMAL, DECIMAL, DECIMAL, DECIMAL
---- RUNTIME_PROFILE
aggregation(SUM, ProbeRows): 99
====
---- QUERY
####################################################
# Test case 2.3: Decimal Min-max filters multiple
#   d14_7 = d18_9 uses cast and will not use minmax
#   filters.  The other 3 will.
####################################################
SET RUNTIME_FILTER_WAIT_TIME_MS=$RUNTIME_FILTER_WAIT_TIME_MS;
select STRAIGHT_JOIN a.d14_0, a.d14_1, a.d14_7, a.d14_14
from decimal_rtf_tbl a
join [BROADCAST] decimal_rtf_tiny_tbl b
where a.d14_0 = b.d14_0
and a.d14_1 = b.d14_1
and a.d14_7 = b.d18_9
and a.d14_14 = b.d14_14
order by 1
---- RESULTS: VERIFY_IS_EQUAL_SORTED
1,1.0,1.0000000,0.00000000000000
2,0.2,0.2000000,0.20000000000000
3,0.3,0.0300000,0.03000000000000
4,0.4,0.0040000,0.00400000000000
5,0.5,0.0005000,0.00050000000000
6,0.6,0.0000600,0.00006000000000
78,7.8,0.0000780,0.00007800000000
89,8.9,0.0000089,0.00000890000000
---- TYPES
DECIMAL, DECIMAL, DECIMAL, DECIMAL
---- RUNTIME_PROFILE
aggregation(SUM, ProbeRows): 107
====
---- QUERY
####################################################
# Test case 2.4: Decimal Min-max filters multiple
#   d18_18 = d28_28 uses cast and will not use minmax
#   filters.  The other 3 will.
####################################################
SET RUNTIME_FILTER_WAIT_TIME_MS=$RUNTIME_FILTER_WAIT_TIME_MS;
select STRAIGHT_JOIN a.d18_0, a.d18_1, a.d18_9, a.d18_18
from decimal_rtf_tbl a
join [BROADCAST] decimal_rtf_tiny_tbl b
where a.d18_0 = b.d18_0
and a.d18_1 = b.d18_1
and a.d18_9 = b.d18_9
and a.d18_18 = b.d28_28
order by 1
---- RESULTS: VERIFY_IS_EQUAL_SORTED
1,1.0,1.000000000,0.000000000000000000
2,0.2,0.200000000,0.200000000000000000
3,0.3,0.030000000,0.030000000000000000
4,0.4,0.004000000,0.004000000000000000
5,0.5,0.000500000,0.000500000000000000
6,0.6,0.000060000,0.000060000000000000
11,1.1,0.000000011,0.000000011000000000
78,7.8,0.000078000,0.000078000000000000
89,8.9,0.000008900,0.000008900000000000
91,9.1,0.000000910,0.000000910000000000
223,22.3,0.000000223,0.000000022300000000
334,33.4,0.000000334,0.000000003340000000
445,44.5,0.000000445,0.000000000445000000
556,55.6,0.000000556,0.000000000055600000
667,66.7,0.000000667,0.000000000006670000
1112,111.2,0.000001112,0.000000000000001112
7789,778.9,0.000007789,0.000000000007789000
8891,889.1,0.000008891,0.000000000000889100
9912,991.2,0.000009912,0.000000000000099120
---- TYPES
DECIMAL, DECIMAL, DECIMAL, DECIMAL
---- RUNTIME_PROFILE
aggregation(SUM, ProbeRows): 102
====
---- QUERY
####################################################
# Test case 2.5: Decimal Min-max filters multiple
#   d28_0 = d38_0 uses cast and will not use minmax
#   filters.  The other 3 will.
####################################################
SET RUNTIME_FILTER_WAIT_TIME_MS=$RUNTIME_FILTER_WAIT_TIME_MS;
select STRAIGHT_JOIN a.d28_0, a.d28_1, a.d28_14, a.d28_28
from decimal_rtf_tbl a
join [BROADCAST] decimal_rtf_tiny_tbl b
where a.d28_0 = b.d38_0
and a.d28_1 = b.d28_1
and a.d28_14 = b.d28_14
and a.d28_28 = b.d28_28
order by 1
---- RESULTS: VERIFY_IS_EQUAL_SORTED
1,1.0,1.00000000000000,0.0000000000000000000000000000
2,0.2,0.20000000000000,0.2000000000000000000000000000
3,0.3,0.03000000000000,0.0300000000000000000000000000
4,0.4,0.00400000000000,0.0040000000000000000000000000
5,0.5,0.00050000000000,0.0005000000000000000000000000
6,0.6,0.00006000000000,0.0000600000000000000000000000
11,1.1,0.00000001100000,0.0000000110000000000000000000
18,1.8,0.00000000000018,0.0000000000000000000000000018
19,1.9,0.00000000000019,0.0000000000000000000000000019
27,2.7,0.00000000000027,0.0000000000000000000000000027
28,2.8,0.00000000000028,0.0000000000000000000000000028
29,2.9,0.00000000000029,0.0000000000000000000000000029
38,3.8,0.00000000000038,0.0000000000000000000000000038
39,3.9,0.00000000000039,0.0000000000000000000000000039
49,4.9,0.00000000000049,0.0000000000000000000000000049
78,7.8,0.00007800000000,0.0000780000000000000000000000
89,8.9,0.00000890000000,0.0000089000000000000000000000
91,9.1,0.00000091000000,0.0000009100000000000000000000
167,16.7,0.00000000000167,0.0000000000000000000000001670
178,17.8,0.00000000000178,0.0000000000000000000000000178
222,22.2,0.00000000000222,0.0000000000000000222000000000
223,22.3,0.00000002230000,0.0000000223000000000000000000
333,33.3,0.00000000000333,0.0000000000000000033300000000
334,33.4,0.00000000334000,0.0000000033400000000000000000
444,44.4,0.00000000000444,0.0000000000000000004440000000
445,44.5,0.00000000044500,0.0000000004450000000000000000
555,55.5,0.00000000000555,0.0000000000000000000555000000
556,55.6,0.00000000005560,0.0000000000556000000000000000
666,66.6,0.00000000000666,0.0000000000000000000066600000
667,66.7,0.00000000000667,0.0000000000066700000000000000
777,77.7,0.00000000000777,0.0000000000000000000007770000
888,88.8,0.00000000000888,0.0000000000000000000000888000
999,99.9,0.00000000000999,0.0000000000000000000000099900
1111,111.1,0.00000000001111,0.0000000000000000000000001111
1112,111.2,0.00000000001112,0.0000000000000011120000000000
7789,778.9,0.00000000007789,0.0000000000077890000000000000
8891,889.1,0.00000000008891,0.0000000000008891000000000000
9912,991.2,0.00000000009912,0.0000000000000991200000000000
---- TYPES
DECIMAL, DECIMAL, DECIMAL, DECIMAL
---- RUNTIME_PROFILE
aggregation(SUM, ProbeRows): 97
====
---- QUERY
####################################################
# Test case 2.6: Decimal Min-max filters multiple
#   d38_1 = d5_1 uses cast and will not use minmax
#   filters.  The other 3 will.
####################################################
SET RUNTIME_FILTER_WAIT_TIME_MS=$RUNTIME_FILTER_WAIT_TIME_MS;
select STRAIGHT_JOIN a.d38_0, a.d38_1, a.d38_19, a.d38_38
from decimal_rtf_tbl a
join [BROADCAST] decimal_rtf_tiny_tbl b
where a.d38_0 = b.d38_0
and a.d38_1 = b.d5_1
and a.d38_19 = b.d38_19
and a.d38_38 = b.d38_38
order by 1
---- RESULTS: VERIFY_IS_EQUAL_SORTED
1,1.0,1.0000000000000000000,0.00000000000000000000000000000000000000
2,0.2,0.2000000000000000000,0.20000000000000000000000000000000000000
3,0.3,0.0300000000000000000,0.03000000000000000000000000000000000000
4,0.4,0.0040000000000000000,0.00400000000000000000000000000000000000
5,0.5,0.0005000000000000000,0.00050000000000000000000000000000000000
6,0.6,0.0000600000000000000,0.00006000000000000000000000000000000000
11,1.1,0.0000000110000000000,0.00000001100000000000000000000000000000
18,1.8,0.0000000000000000018,0.00000000000000000000000000001800000000
19,1.9,0.0000000000000000019,0.00000000000000000000000000000190000000
27,2.7,0.0000000000000000027,0.00000000000000000000000000000027000000
28,2.8,0.0000000000000000028,0.00000000000000000000000000000002800000
29,2.9,0.0000000000000000029,0.00000000000000000000000000000000290000
38,3.8,0.0000000000000000038,0.00000000000000000000000000000000038000
39,3.9,0.0000000000000000039,0.00000000000000000000000000000000003900
49,4.9,0.0000000000000000049,0.00000000000000000000000000000000000490
78,7.8,0.0000780000000000000,0.00007800000000000000000000000000000000
89,8.9,0.0000089000000000000,0.00000890000000000000000000000000000000
91,9.1,0.0000009100000000000,0.00000091000000000000000000000000000000
167,16.7,0.0000000000000000167,0.00000000000000000000000016700000000000
178,17.8,0.0000000000000000178,0.00000000000000000000000001780000000000
222,22.2,0.0000000000000000222,0.00000000000000002220000000000000000000
223,22.3,0.0000000223000000000,0.00000002230000000000000000000000000000
333,33.3,0.0000000000000000333,0.00000000000000000333000000000000000000
334,33.4,0.0000000033400000000,0.00000000334000000000000000000000000000
444,44.4,0.0000000000000000444,0.00000000000000000044400000000000000000
445,44.5,0.0000000004450000000,0.00000000044500000000000000000000000000
555,55.5,0.0000000000000000555,0.00000000000000000005550000000000000000
556,55.6,0.0000000000556000000,0.00000000005560000000000000000000000000
666,66.6,0.0000000000000000666,0.00000000000000000000666000000000000000
667,66.7,0.0000000000066700000,0.00000000000667000000000000000000000000
777,77.7,0.0000000000000000777,0.00000000000000000000077700000000000000
888,88.8,0.0000000000000000888,0.00000000000000000000008880000000000000
999,99.9,0.0000000000000000999,0.00000000000000000000000999000000000000
1111,111.1,0.0000000000000001111,0.00000000000000000000000000000000001111
1112,111.2,0.0000000000000011120,0.00000000000000111200000000000000000000
7789,778.9,0.0000000000077890000,0.00000000000778900000000000000000000000
8891,889.1,0.0000000000008891000,0.00000000000088910000000000000000000000
9912,991.2,0.0000000000000991200,0.00000000000009912000000000000000000000
---- TYPES
DECIMAL, DECIMAL, DECIMAL, DECIMAL
---- RUNTIME_PROFILE
aggregation(SUM, ProbeRows): 97
====

---- QUERY
######################################################################
# Test case 3.1: Two DecimalMinMaxFilters with shuffle join - 4 bytes
######################################################################
SET RUNTIME_FILTER_WAIT_TIME_MS=$RUNTIME_FILTER_WAIT_TIME_MS;
select straight_join a.d5_0
from decimal_rtf_tbl a
  inner join /* +shuffle */ decimal_rtf_tiny_tbl b on a.d5_0 = b.d5_0
  inner join /* +shuffle */ decimal_rtf_tiny_tbl c on b.d5_0 = c.d5_0
order by 1
---- RESULTS: VERIFY_IS_EQUAL_SORTED
1
2
3
4
5
6
11
18
19
27
28
29
38
39
49
78
89
91
167
178
222
223
333
334
444
445
555
556
666
667
777
888
999
1111
1112
7789
8891
9912
---- RUNTIME_PROFILE
aggregation(SUM, ProbeRows): 149
====
---- QUERY
######################################################################
# Test case 3.2: Two DecimalMinMaxFilters with shuffle join - 4 bytes
######################################################################
SET RUNTIME_FILTER_WAIT_TIME_MS=$RUNTIME_FILTER_WAIT_TIME_MS;
select straight_join a.d5_1
from decimal_rtf_tbl a
  inner join /* +shuffle */ decimal_rtf_tiny_tbl b on a.d5_1 = b.d5_1
  inner join /* +shuffle */ decimal_rtf_tiny_tbl c on b.d5_1 = c.d5_1
order by 1
---- RESULTS: VERIFY_IS_EQUAL_SORTED
0.2
0.3
0.4
0.5
0.6
1.0
1.1
1.8
1.9
2.7
2.8
2.9
3.8
3.9
4.9
7.8
8.9
9.1
16.7
17.8
22.2
22.3
33.3
33.4
44.4
44.5
55.5
55.6
66.6
66.7
77.7
88.8
99.9
111.1
111.2
778.9
889.1
991.2
---- RUNTIME_PROFILE
aggregation(SUM, ProbeRows): 148
====
---- QUERY
######################################################################
# Test case 3.3: Two DecimalMinMaxFilters with shuffle join - 4 bytes
######################################################################
SET RUNTIME_FILTER_WAIT_TIME_MS=$RUNTIME_FILTER_WAIT_TIME_MS;
select straight_join a.d5_3
from decimal_rtf_tbl a
  inner join /* +shuffle */ decimal_rtf_tiny_tbl b on a.d5_3 = b.d5_3
  inner join /* +shuffle */ decimal_rtf_tiny_tbl c on b.d5_3 = c.d5_3
order by 1
---- RESULTS: VERIFY_IS_EQUAL_SORTED
0.004
0.005
0.006
0.011
0.018
0.019
0.027
0.028
0.029
0.030
0.038
0.039
0.049
0.078
0.089
0.091
0.167
0.178
0.200
0.222
0.223
0.333
0.334
0.444
0.445
0.555
0.556
0.666
0.667
0.777
0.888
0.999
1.000
1.111
1.112
7.789
8.891
9.912
---- RUNTIME_PROFILE
aggregation(SUM, ProbeRows): 143
====
---- QUERY
#######################################################################
# Test case 3.4.1: Two DecimalMinMaxFilters with shuffle join - 4 bytes
#######################################################################
SET RUNTIME_FILTER_WAIT_TIME_MS=$RUNTIME_FILTER_WAIT_TIME_MS;
select straight_join a.d5_5
from decimal_rtf_tbl a
  inner join /* +shuffle */ decimal_rtf_tiny_tbl b on a.d5_5 = b.d5_5
  inner join /* +shuffle */ decimal_rtf_tiny_tbl c on b.d5_5 = c.d5_5
where a.d5_5 != 0
order by 1
---- RESULTS: VERIFY_IS_EQUAL_SORTED
0.00006
0.00011
0.00018
0.00019
0.00027
0.00028
0.00029
0.00038
0.00039
0.00049
0.00050
0.00078
0.00089
0.00091
0.00167
0.00178
0.00222
0.00223
0.00333
0.00334
0.00400
0.00444
0.00445
0.00555
0.00556
0.00666
0.00667
0.00777
0.00888
0.00999
0.01111
0.01112
0.03000
0.07789
0.08891
0.09912
0.20000
---- RUNTIME_PROFILE
aggregation(SUM, ProbeRows): 347
====
---- QUERY
#######################################################################
# Test case 3.4.2: Two DecimalMinMaxFilters with shuffle join - 4 bytes
#######################################################################
SET RUNTIME_FILTER_WAIT_TIME_MS=$RUNTIME_FILTER_WAIT_TIME_MS;
select straight_join count(a.d5_5)
from decimal_rtf_tbl a
  inner join /* +shuffle */ decimal_rtf_tiny_tbl b on a.d5_5 = b.d5_5
  inner join /* +shuffle */ decimal_rtf_tiny_tbl c on b.d5_5 = c.d5_5
where a.d5_5 = 0
---- RESULTS: VERIFY_IS_EQUAL_SORTED
180
---- RUNTIME_PROFILE
aggregation(SUM, ProbeRows): 360
====
---- QUERY
######################################################################
# Test case 3.5: Two DecimalMinMaxFilters with shuffle join - 8 bytes
######################################################################
SET RUNTIME_FILTER_WAIT_TIME_MS=$RUNTIME_FILTER_WAIT_TIME_MS;
select straight_join a.d9_0
from decimal_rtf_tbl a
  inner join /* +shuffle */ decimal_rtf_tiny_tbl b on a.d9_0 = b.d9_0
  inner join /* +shuffle */ decimal_rtf_tiny_tbl c on b.d9_0 = c.d9_0
order by 1
---- RESULTS: VERIFY_IS_EQUAL_SORTED
1
2
3
4
5
6
11
18
19
27
28
29
38
39
49
78
89
91
167
178
222
223
333
334
444
445
555
556
666
667
777
888
999
1111
1112
7789
8891
9912
---- RUNTIME_PROFILE
aggregation(SUM, ProbeRows): 149
====
---- QUERY
######################################################################
# Test case 3.6: Two DecimalMinMaxFilters with shuffle join - 4 bytes
######################################################################
SET RUNTIME_FILTER_WAIT_TIME_MS=$RUNTIME_FILTER_WAIT_TIME_MS;
select straight_join a.d9_1
from decimal_rtf_tbl a
  inner join /* +shuffle */ decimal_rtf_tiny_tbl b on a.d9_1 = b.d9_1
  inner join /* +shuffle */ decimal_rtf_tiny_tbl c on b.d9_1 = c.d9_1
order by 1
---- RESULTS: VERIFY_IS_EQUAL_SORTED
0.2
0.3
0.4
0.5
0.6
1.0
1.1
1.8
1.9
2.7
2.8
2.9
3.8
3.9
4.9
7.8
8.9
9.1
16.7
17.8
22.2
22.3
33.3
33.4
44.4
44.5
55.5
55.6
66.6
66.7
77.7
88.8
99.9
111.1
111.2
778.9
889.1
991.2
---- RUNTIME_PROFILE
aggregation(SUM, ProbeRows): 148
====
---- QUERY
######################################################################
# Test case 3.7: Two DecimalMinMaxFilters with shuffle join - 4 bytes
######################################################################
SET RUNTIME_FILTER_WAIT_TIME_MS=$RUNTIME_FILTER_WAIT_TIME_MS;
select straight_join a.d9_5
from decimal_rtf_tbl a
  inner join /* +shuffle */ decimal_rtf_tiny_tbl b on a.d9_5 = b.d9_5
  inner join /* +shuffle */ decimal_rtf_tiny_tbl c on b.d9_5 = c.d9_5
order by 1
---- RESULTS: VERIFY_IS_EQUAL_SORTED
0.00006
0.00011
0.00018
0.00019
0.00027
0.00028
0.00029
0.00038
0.00039
0.00049
0.00050
0.00078
0.00089
0.00091
0.00167
0.00178
0.00222
0.00223
0.00333
0.00334
0.00400
0.00444
0.00445
0.00555
0.00556
0.00666
0.00667
0.00777
0.00888
0.00999
0.01111
0.01112
0.03000
0.07789
0.08891
0.09912
0.20000
1.00000
---- RUNTIME_PROFILE
aggregation(SUM, ProbeRows): 174
====
---- QUERY
#######################################################################
# Test case 3.8.1: Two DecimalMinMaxFilters with shuffle join - 4 bytes
#######################################################################
SET RUNTIME_FILTER_WAIT_TIME_MS=$RUNTIME_FILTER_WAIT_TIME_MS;
select straight_join a.d9_9
from decimal_rtf_tbl a
  inner join /* +shuffle */ decimal_rtf_tiny_tbl b on a.d9_9 = b.d9_9
  inner join /* +shuffle */ decimal_rtf_tiny_tbl c on b.d9_9 = c.d9_9
where a.d9_9 != 0
order by 1
---- RESULTS: VERIFY_IS_EQUAL_SORTED
0.000000011
0.000000018
0.000000019
0.000000027
0.000000028
0.000000029
0.000000038
0.000000039
0.000000049
0.000000167
0.000000178
0.000000222
0.000000223
0.000000333
0.000000334
0.000000444
0.000000445
0.000000555
0.000000556
0.000000666
0.000000667
0.000000777
0.000000888
0.000000910
0.000000999
0.000001111
0.000001112
0.000007789
0.000008891
0.000008900
0.000009912
0.000060000
0.000078000
0.000500000
0.004000000
0.030000000
0.200000000
---- RUNTIME_PROFILE
aggregation(SUM, ProbeRows): 379
====
---- QUERY
#######################################################################
# Test case 3.8.2: Two DecimalMinMaxFilters with shuffle join - 4 bytes
#######################################################################
SET RUNTIME_FILTER_WAIT_TIME_MS=$RUNTIME_FILTER_WAIT_TIME_MS;
select straight_join count(a.d9_9)
from decimal_rtf_tbl a
  inner join /* +shuffle */ decimal_rtf_tiny_tbl b on a.d9_9 = b.d9_9
  inner join /* +shuffle */ decimal_rtf_tiny_tbl c on b.d9_9 = c.d9_9
where a.d9_9 = 0
---- RESULTS: VERIFY_IS_EQUAL_SORTED
306
---- RUNTIME_PROFILE
aggregation(SUM, ProbeRows): 612
====
---- QUERY
######################################################################
# Test case 3.9: Two DecimalMinMaxFilters with shuffle join - 8 bytes
######################################################################
SET RUNTIME_FILTER_WAIT_TIME_MS=$RUNTIME_FILTER_WAIT_TIME_MS;
select straight_join a.d14_0
from decimal_rtf_tbl a
  inner join /* +shuffle */ decimal_rtf_tiny_tbl b on a.d14_0 = b.d14_0
  inner join /* +shuffle */ decimal_rtf_tiny_tbl c on b.d14_0 = c.d14_0
order by 1
---- RESULTS: VERIFY_IS_EQUAL_SORTED
1
2
3
4
5
6
11
18
19
27
28
29
38
39
49
78
89
91
167
178
222
223
333
334
444
445
555
556
666
667
777
888
999
1111
1112
7789
8891
9912
---- RUNTIME_PROFILE
aggregation(SUM, ProbeRows): 149
====
---- QUERY
######################################################################
# Test case 3.10: Two DecimalMinMaxFilters with shuffle join - 8 bytes
######################################################################
SET RUNTIME_FILTER_WAIT_TIME_MS=$RUNTIME_FILTER_WAIT_TIME_MS;
select straight_join a.d14_1
from decimal_rtf_tbl a
  inner join /* +shuffle */ decimal_rtf_tiny_tbl b on a.d14_1 = b.d14_1
  inner join /* +shuffle */ decimal_rtf_tiny_tbl c on b.d14_1 = c.d14_1
order by 1
---- RESULTS: VERIFY_IS_EQUAL_SORTED
0.2
0.3
0.4
0.5
0.6
1.0
1.1
1.8
1.9
2.7
2.8
2.9
3.8
3.9
4.9
7.8
8.9
9.1
16.7
17.8
22.2
22.3
33.3
33.4
44.4
44.5
55.5
55.6
66.6
66.7
77.7
88.8
99.9
111.1
111.2
778.9
889.1
991.2
---- RUNTIME_PROFILE
aggregation(SUM, ProbeRows): 148
====
---- QUERY
######################################################################
# Test case 3.11: Two DecimalMinMaxFilters with shuffle join - 8 bytes
######################################################################
SET RUNTIME_FILTER_WAIT_TIME_MS=$RUNTIME_FILTER_WAIT_TIME_MS;
select straight_join a.d14_7
from decimal_rtf_tbl a
  inner join /* +shuffle */ decimal_rtf_tiny_tbl b on a.d14_7 = b.d14_7
  inner join /* +shuffle */ decimal_rtf_tiny_tbl c on b.d14_7 = c.d14_7
order by 1
---- RESULTS: VERIFY_IS_EQUAL_SORTED
0.0000011
0.0000018
0.0000019
0.0000027
0.0000028
0.0000029
0.0000038
0.0000039
0.0000049
0.0000089
0.0000091
0.0000167
0.0000178
0.0000222
0.0000223
0.0000333
0.0000334
0.0000444
0.0000445
0.0000555
0.0000556
0.0000600
0.0000666
0.0000667
0.0000777
0.0000780
0.0000888
0.0000999
0.0001111
0.0001112
0.0005000
0.0007789
0.0008891
0.0009912
0.0040000
0.0300000
0.2000000
1.0000000
---- RUNTIME_PROFILE
aggregation(SUM, ProbeRows): 235
====
---- QUERY
########################################################################
# Test case 3.12.1: Two DecimalMinMaxFilters with shuffle join - 8 bytes
########################################################################
SET RUNTIME_FILTER_WAIT_TIME_MS=$RUNTIME_FILTER_WAIT_TIME_MS;
select straight_join a.d14_14
from decimal_rtf_tbl a
  inner join /* +shuffle */ decimal_rtf_tiny_tbl b on a.d14_14 = b.d14_14
  inner join /* +shuffle */ decimal_rtf_tiny_tbl c on b.d14_14 = c.d14_14
where a.d14_14 != 0
order by 1
---- RESULTS: VERIFY_IS_EQUAL_SORTED
0.00000000000018
0.00000000000019
0.00000000000027
0.00000000000028
0.00000000000029
0.00000000000038
0.00000000000039
0.00000000000049
0.00000000000167
0.00000000000178
0.00000000000222
0.00000000000333
0.00000000000444
0.00000000000555
0.00000000000666
0.00000000000667
0.00000000000777
0.00000000000888
0.00000000000999
0.00000000001111
0.00000000001112
0.00000000005560
0.00000000007789
0.00000000008891
0.00000000009912
0.00000000044500
0.00000000334000
0.00000001100000
0.00000002230000
0.00000091000000
0.00000890000000
0.00006000000000
0.00007800000000
0.00050000000000
0.00400000000000
0.03000000000000
0.20000000000000
---- RUNTIME_PROFILE
aggregation(SUM, ProbeRows): 479
====
---- QUERY
########################################################################
# Test case 3.12.2: Two DecimalMinMaxFilters with shuffle join - 8 bytes
########################################################################
SET RUNTIME_FILTER_WAIT_TIME_MS=$RUNTIME_FILTER_WAIT_TIME_MS;
select straight_join count(a.d14_14)
from decimal_rtf_tbl a
  inner join /* +shuffle */ decimal_rtf_tiny_tbl b on a.d14_14 = b.d14_14
  inner join /* +shuffle */ decimal_rtf_tiny_tbl c on b.d14_14 = c.d14_14
where a.d14_14 = 0
---- RESULTS: VERIFY_IS_EQUAL_SORTED
441
---- RUNTIME_PROFILE
aggregation(SUM, ProbeRows): 882
====
---- QUERY
######################################################################
# Test case 3.13: Two DecimalMinMaxFilters with shuffle join - 8 bytes
######################################################################
SET RUNTIME_FILTER_WAIT_TIME_MS=$RUNTIME_FILTER_WAIT_TIME_MS;
select straight_join a.d18_0
from decimal_rtf_tbl a
  inner join /* +shuffle */ decimal_rtf_tiny_tbl b on a.d18_0 = b.d18_0
  inner join /* +shuffle */ decimal_rtf_tiny_tbl c on b.d18_0 = c.d18_0
order by 1
---- RESULTS: VERIFY_IS_EQUAL_SORTED
1
2
3
4
5
6
11
18
19
27
28
29
38
39
49
78
89
91
167
178
222
223
333
334
444
445
555
556
666
667
777
888
999
1111
1112
7789
8891
9912
---- RUNTIME_PROFILE
aggregation(SUM, ProbeRows): 149
====
---- QUERY
######################################################################
# Test case 3.14: Two DecimalMinMaxFilters with shuffle join - 8 bytes
######################################################################
SET RUNTIME_FILTER_WAIT_TIME_MS=$RUNTIME_FILTER_WAIT_TIME_MS;
select straight_join a.d18_1
from decimal_rtf_tbl a
  inner join /* +shuffle */ decimal_rtf_tiny_tbl b on a.d18_1 = b.d18_1
  inner join /* +shuffle */ decimal_rtf_tiny_tbl c on b.d18_1 = c.d18_1
order by 1
---- RESULTS: VERIFY_IS_EQUAL_SORTED
0.2
0.3
0.4
0.5
0.6
1.0
1.1
1.8
1.9
2.7
2.8
2.9
3.8
3.9
4.9
7.8
8.9
9.1
16.7
17.8
22.2
22.3
33.3
33.4
44.4
44.5
55.5
55.6
66.6
66.7
77.7
88.8
99.9
111.1
111.2
778.9
889.1
991.2
---- RUNTIME_PROFILE
aggregation(SUM, ProbeRows): 148
====
---- QUERY
######################################################################
# Test case 3.15: Two DecimalMinMaxFilters with shuffle join - 8 bytes
######################################################################
SET RUNTIME_FILTER_WAIT_TIME_MS=$RUNTIME_FILTER_WAIT_TIME_MS;
select straight_join a.d18_9
from decimal_rtf_tbl a
  inner join /* +shuffle */ decimal_rtf_tiny_tbl b on a.d18_9 = b.d18_9
  inner join /* +shuffle */ decimal_rtf_tiny_tbl c on b.d18_9 = c.d18_9
order by 1
---- RESULTS: VERIFY_IS_EQUAL_SORTED
0.000000011
0.000000018
0.000000019
0.000000027
0.000000028
0.000000029
0.000000038
0.000000039
0.000000049
0.000000167
0.000000178
0.000000222
0.000000223
0.000000333
0.000000334
0.000000444
0.000000445
0.000000555
0.000000556
0.000000666
0.000000667
0.000000777
0.000000888
0.000000910
0.000000999
0.000001111
0.000001112
0.000007789
0.000008891
0.000008900
0.000009912
0.000060000
0.000078000
0.000500000
0.004000000
0.030000000
0.200000000
1.000000000
---- RUNTIME_PROFILE
aggregation(SUM, ProbeRows): 296
====
---- QUERY
########################################################################
# Test case 3.16.1: Two DecimalMinMaxFilters with shuffle join - 8 bytes
########################################################################
SET RUNTIME_FILTER_WAIT_TIME_MS=$RUNTIME_FILTER_WAIT_TIME_MS;
select straight_join a.d18_18
from decimal_rtf_tbl a
  inner join /* +shuffle */ decimal_rtf_tiny_tbl b on a.d18_18 = b.d18_18
  inner join /* +shuffle */ decimal_rtf_tiny_tbl c on b.d18_18 = c.d18_18
where a.d18_18 != 0
order by 1
---- RESULTS: VERIFY_IS_EQUAL_SORTED
0.000000000000000018
0.000000000000000019
0.000000000000000027
0.000000000000000028
0.000000000000000029
0.000000000000000038
0.000000000000000039
0.000000000000000049
0.000000000000000167
0.000000000000000178
0.000000000000000222
0.000000000000000333
0.000000000000000444
0.000000000000000555
0.000000000000000666
0.000000000000000777
0.000000000000000888
0.000000000000000999
0.000000000000001111
0.000000000000001112
0.000000000000099120
0.000000000000889100
0.000000000006670000
0.000000000007789000
0.000000000055600000
0.000000000445000000
0.000000003340000000
0.000000011000000000
0.000000022300000000
0.000000910000000000
0.000008900000000000
0.000060000000000000
0.000078000000000000
0.000500000000000000
0.004000000000000000
0.030000000000000000
0.200000000000000000
---- RUNTIME_PROFILE
aggregation(SUM, ProbeRows): 536
====
---- QUERY
########################################################################
# Test case 3.16.2: Two DecimalMinMaxFilters with shuffle join - 8 bytes
########################################################################
SET RUNTIME_FILTER_WAIT_TIME_MS=$RUNTIME_FILTER_WAIT_TIME_MS;
select straight_join count(a.d18_18)
from decimal_rtf_tbl a
  inner join /* +shuffle */ decimal_rtf_tiny_tbl b on a.d18_18 = b.d18_18
  inner join /* +shuffle */ decimal_rtf_tiny_tbl c on b.d18_18 = c.d18_18
where a.d18_18 = 0
---- RESULTS: VERIFY_IS_EQUAL_SORTED
531
---- RUNTIME_PROFILE
aggregation(SUM, ProbeRows): 1062
====
---- QUERY
#######################################################################
# Test case 3.17: Two DecimalMinMaxFilters with shuffle join - 16 bytes
#######################################################################
SET RUNTIME_FILTER_WAIT_TIME_MS=$RUNTIME_FILTER_WAIT_TIME_MS;
select straight_join a.d28_0
from decimal_rtf_tbl a
  inner join /* +shuffle */ decimal_rtf_tiny_tbl b on a.d28_0 = b.d28_0
  inner join /* +shuffle */ decimal_rtf_tiny_tbl c on b.d28_0 = c.d28_0
order by 1
---- RESULTS: VERIFY_IS_EQUAL_SORTED
1
2
3
4
5
6
11
18
19
27
28
29
38
39
49
78
89
91
167
178
222
223
333
334
444
445
555
556
666
667
777
888
999
1111
1112
7789
8891
9912
---- RUNTIME_PROFILE
aggregation(SUM, ProbeRows): 149
====
---- QUERY
#######################################################################
# Test case 3.18: Two DecimalMinMaxFilters with shuffle join - 16 bytes
#######################################################################
SET RUNTIME_FILTER_WAIT_TIME_MS=$RUNTIME_FILTER_WAIT_TIME_MS;
select straight_join a.d28_1
from decimal_rtf_tbl a
  inner join /* +shuffle */ decimal_rtf_tiny_tbl b on a.d28_1 = b.d28_1
  inner join /* +shuffle */ decimal_rtf_tiny_tbl c on b.d28_1 = c.d28_1
order by 1
---- RESULTS: VERIFY_IS_EQUAL_SORTED
0.2
0.3
0.4
0.5
0.6
1.0
1.1
1.8
1.9
2.7
2.8
2.9
3.8
3.9
4.9
7.8
8.9
9.1
16.7
17.8
22.2
22.3
33.3
33.4
44.4
44.5
55.5
55.6
66.6
66.7
77.7
88.8
99.9
111.1
111.2
778.9
889.1
991.2
---- RUNTIME_PROFILE
aggregation(SUM, ProbeRows): 148
====
---- QUERY
#######################################################################
# Test case 3.19: Two DecimalMinMaxFilters with shuffle join - 16 bytes
#######################################################################
SET RUNTIME_FILTER_WAIT_TIME_MS=$RUNTIME_FILTER_WAIT_TIME_MS;
select straight_join a.d28_14
from decimal_rtf_tbl a
  inner join /* +shuffle */ decimal_rtf_tiny_tbl b on a.d28_14 = b.d28_14
  inner join /* +shuffle */ decimal_rtf_tiny_tbl c on b.d28_14 = c.d28_14
order by 1
---- RESULTS: VERIFY_IS_EQUAL_SORTED
0.00000000000018
0.00000000000019
0.00000000000027
0.00000000000028
0.00000000000029
0.00000000000038
0.00000000000039
0.00000000000049
0.00000000000167
0.00000000000178
0.00000000000222
0.00000000000333
0.00000000000444
0.00000000000555
0.00000000000666
0.00000000000667
0.00000000000777
0.00000000000888
0.00000000000999
0.00000000001111
0.00000000001112
0.00000000005560
0.00000000007789
0.00000000008891
0.00000000009912
0.00000000044500
0.00000000334000
0.00000001100000
0.00000002230000
0.00000091000000
0.00000890000000
0.00006000000000
0.00007800000000
0.00050000000000
0.00400000000000
0.03000000000000
0.20000000000000
1.00000000000000
---- RUNTIME_PROFILE
aggregation(SUM, ProbeRows): 424
====
---- QUERY
#########################################################################
# Test case 3.20.1: Two DecimalMinMaxFilters with shuffle join - 16 bytes
#########################################################################
SET RUNTIME_FILTER_WAIT_TIME_MS=$RUNTIME_FILTER_WAIT_TIME_MS;
select straight_join a.d28_28
from decimal_rtf_tbl a
  inner join /* +shuffle */ decimal_rtf_tiny_tbl b on a.d28_28 = b.d28_28
  inner join /* +shuffle */ decimal_rtf_tiny_tbl c on b.d28_28 = c.d28_28
where a.d28_28 != 0
order by 1
---- RESULTS: VERIFY_IS_EQUAL_SORTED
0.0000000000000000000000000018
0.0000000000000000000000000019
0.0000000000000000000000000027
0.0000000000000000000000000028
0.0000000000000000000000000029
0.0000000000000000000000000038
0.0000000000000000000000000039
0.0000000000000000000000000049
0.0000000000000000000000000178
0.0000000000000000000000001111
0.0000000000000000000000001670
0.0000000000000000000000099900
0.0000000000000000000000888000
0.0000000000000000000007770000
0.0000000000000000000066600000
0.0000000000000000000555000000
0.0000000000000000004440000000
0.0000000000000000033300000000
0.0000000000000000222000000000
0.0000000000000011120000000000
0.0000000000000991200000000000
0.0000000000008891000000000000
0.0000000000066700000000000000
0.0000000000077890000000000000
0.0000000000556000000000000000
0.0000000004450000000000000000
0.0000000033400000000000000000
0.0000000110000000000000000000
0.0000000223000000000000000000
0.0000009100000000000000000000
0.0000089000000000000000000000
0.0000600000000000000000000000
0.0000780000000000000000000000
0.0005000000000000000000000000
0.0040000000000000000000000000
0.0300000000000000000000000000
0.2000000000000000000000000000
---- RUNTIME_PROFILE
aggregation(SUM, ProbeRows): 656
====
---- QUERY
#########################################################################
# Test case 3.20.2: Two DecimalMinMaxFilters with shuffle join - 16 bytes
#########################################################################
SET RUNTIME_FILTER_WAIT_TIME_MS=$RUNTIME_FILTER_WAIT_TIME_MS;
select straight_join count(a.d28_28)
from decimal_rtf_tbl a
  inner join /* +shuffle */ decimal_rtf_tiny_tbl b on a.d28_28 = b.d28_28
  inner join /* +shuffle */ decimal_rtf_tiny_tbl c on b.d28_28 = c.d28_28
where a.d28_28 = 0
---- RESULTS: VERIFY_IS_EQUAL_SORTED
686
---- RUNTIME_PROFILE
aggregation(SUM, ProbeRows): 1372
====
---- QUERY
#######################################################################
# Test case 3.21: Two DecimalMinMaxFilters with shuffle join - 16 bytes
#######################################################################
SET RUNTIME_FILTER_WAIT_TIME_MS=$RUNTIME_FILTER_WAIT_TIME_MS;
select straight_join a.d38_0
from decimal_rtf_tbl a
  inner join /* +shuffle */ decimal_rtf_tiny_tbl b on a.d38_0 = b.d38_0
  inner join /* +shuffle */ decimal_rtf_tiny_tbl c on b.d38_0 = c.d38_0
order by 1
---- RESULTS: VERIFY_IS_EQUAL_SORTED
1
2
3
4
5
6
11
18
19
27
28
29
38
39
49
78
89
91
167
178
222
223
333
334
444
445
555
556
666
667
777
888
999
1111
1112
7789
8891
9912
---- RUNTIME_PROFILE
aggregation(SUM, ProbeRows): 149
====
---- QUERY
#######################################################################
# Test case 3.22: Two DecimalMinMaxFilters with shuffle join - 16 bytes
#######################################################################
SET RUNTIME_FILTER_WAIT_TIME_MS=$RUNTIME_FILTER_WAIT_TIME_MS;
select straight_join a.d38_1
from decimal_rtf_tbl a
  inner join /* +shuffle */ decimal_rtf_tiny_tbl b on a.d38_1 = b.d38_1
  inner join /* +shuffle */ decimal_rtf_tiny_tbl c on b.d38_1 = c.d38_1
order by 1
---- RESULTS: VERIFY_IS_EQUAL_SORTED
0.2
0.3
0.4
0.5
0.6
1.0
1.1
1.8
1.9
2.7
2.8
2.9
3.8
3.9
4.9
7.8
8.9
9.1
16.7
17.8
22.2
22.3
33.3
33.4
44.4
44.5
55.5
55.6
66.6
66.7
77.7
88.8
99.9
111.1
111.2
778.9
889.1
991.2
---- RUNTIME_PROFILE
aggregation(SUM, ProbeRows): 148
====
---- QUERY
#######################################################################
# Test case 3.23: Two DecimalMinMaxFilters with shuffle join - 16 bytes
#######################################################################
SET RUNTIME_FILTER_WAIT_TIME_MS=$RUNTIME_FILTER_WAIT_TIME_MS;
select straight_join a.d38_19
from decimal_rtf_tbl a
  inner join /* +shuffle */ decimal_rtf_tiny_tbl b on a.d38_19 = b.d38_19
  inner join /* +shuffle */ decimal_rtf_tiny_tbl c on b.d38_19 = c.d38_19
order by 1
---- RESULTS: VERIFY_IS_EQUAL_SORTED
0.0000000000000000018
0.0000000000000000019
0.0000000000000000027
0.0000000000000000028
0.0000000000000000029
0.0000000000000000038
0.0000000000000000039
0.0000000000000000049
0.0000000000000000167
0.0000000000000000178
0.0000000000000000222
0.0000000000000000333
0.0000000000000000444
0.0000000000000000555
0.0000000000000000666
0.0000000000000000777
0.0000000000000000888
0.0000000000000000999
0.0000000000000001111
0.0000000000000011120
0.0000000000000991200
0.0000000000008891000
0.0000000000066700000
0.0000000000077890000
0.0000000000556000000
0.0000000004450000000
0.0000000033400000000
0.0000000110000000000
0.0000000223000000000
0.0000009100000000000
0.0000089000000000000
0.0000600000000000000
0.0000780000000000000
0.0005000000000000000
0.0040000000000000000
0.0300000000000000000
0.2000000000000000000
1.0000000000000000000
---- RUNTIME_PROFILE
aggregation(SUM, ProbeRows): 529
====
---- QUERY
#########################################################################
# Test case 3.24.1: Two DecimalMinMaxFilters with shuffle join - 16 bytes
#########################################################################
SET RUNTIME_FILTER_WAIT_TIME_MS=$RUNTIME_FILTER_WAIT_TIME_MS;
select straight_join a.d38_38
from decimal_rtf_tbl a
  inner join /* +shuffle */ decimal_rtf_tiny_tbl b on a.d38_38 = b.d38_38
  inner join /* +shuffle */ decimal_rtf_tiny_tbl c on b.d38_38 = c.d38_38
where a.d38_38 != 0
order by 1
---- RESULTS: VERIFY_IS_EQUAL_SORTED
0.00000000000000000000000000000000000490
0.00000000000000000000000000000000001111
0.00000000000000000000000000000000003900
0.00000000000000000000000000000000038000
0.00000000000000000000000000000000290000
0.00000000000000000000000000000002800000
0.00000000000000000000000000000027000000
0.00000000000000000000000000000190000000
0.00000000000000000000000000001800000000
0.00000000000000000000000001780000000000
0.00000000000000000000000016700000000000
0.00000000000000000000000999000000000000
0.00000000000000000000008880000000000000
0.00000000000000000000077700000000000000
0.00000000000000000000666000000000000000
0.00000000000000000005550000000000000000
0.00000000000000000044400000000000000000
0.00000000000000000333000000000000000000
0.00000000000000002220000000000000000000
0.00000000000000111200000000000000000000
0.00000000000009912000000000000000000000
0.00000000000088910000000000000000000000
0.00000000000667000000000000000000000000
0.00000000000778900000000000000000000000
0.00000000005560000000000000000000000000
0.00000000044500000000000000000000000000
0.00000000334000000000000000000000000000
0.00000001100000000000000000000000000000
0.00000002230000000000000000000000000000
0.00000091000000000000000000000000000000
0.00000890000000000000000000000000000000
0.00006000000000000000000000000000000000
0.00007800000000000000000000000000000000
0.00050000000000000000000000000000000000
0.00400000000000000000000000000000000000
0.03000000000000000000000000000000000000
0.20000000000000000000000000000000000000
---- RUNTIME_PROFILE
aggregation(SUM, ProbeRows): 680
====
---- QUERY
#########################################################################
# Test case 3.24.2: Two DecimalMinMaxFilters with shuffle join - 16 bytes
#########################################################################
SET RUNTIME_FILTER_WAIT_TIME_MS=$RUNTIME_FILTER_WAIT_TIME_MS;
select straight_join count(a.d38_38)
from decimal_rtf_tbl a
  inner join /* +shuffle */ decimal_rtf_tiny_tbl b on a.d38_38 = b.d38_38
  inner join /* +shuffle */ decimal_rtf_tiny_tbl c on b.d38_38 = c.d38_38
where a.d38_38 = 0
---- RESULTS: VERIFY_IS_EQUAL_SORTED
732
---- RUNTIME_PROFILE
aggregation(SUM, ProbeRows): 1464
====

---- QUERY
######################################################################
# Test case 4.1: DecimalMinMaxFilters with right outer join - 4 bytes
######################################################################
SET RUNTIME_FILTER_WAIT_TIME_MS=$RUNTIME_FILTER_WAIT_TIME_MS;
select straight_join count(b.d5_0)
from decimal_rtf_tbl a
  right outer join decimal_rtf_tiny_tbl b on a.d5_0 = b.d5_0
---- RESULTS
40
---- RUNTIME_PROFILE
aggregation(SUM, ProbeRows): 111
====
---- QUERY
######################################################################
# Test case 4.2: DecimalMinMaxFilters with right outer join - 4 bytes
######################################################################
SET RUNTIME_FILTER_WAIT_TIME_MS=$RUNTIME_FILTER_WAIT_TIME_MS;
select straight_join count(b.d5_1)
from decimal_rtf_tbl a
  right outer join decimal_rtf_tiny_tbl b on a.d5_1 = b.d5_1
---- RESULTS
40
---- RUNTIME_PROFILE
aggregation(SUM, ProbeRows): 110
====
---- QUERY
######################################################################
# Test case 4.3: DecimalMinMaxFilters with right outer join - 4 bytes
######################################################################
SET RUNTIME_FILTER_WAIT_TIME_MS=$RUNTIME_FILTER_WAIT_TIME_MS;
select straight_join count(b.d5_3)
from decimal_rtf_tbl a
  right outer join decimal_rtf_tiny_tbl b on a.d5_3 = b.d5_3
---- RESULTS
40
---- RUNTIME_PROFILE
aggregation(SUM, ProbeRows): 105
====
---- QUERY
#######################################################################
# Test case 4.4.1: DecimalMinMaxFilters with right outer join - 4 bytes
#######################################################################
SET RUNTIME_FILTER_WAIT_TIME_MS=$RUNTIME_FILTER_WAIT_TIME_MS;
select straight_join count(b.d5_5)
from decimal_rtf_tbl a
  right outer join decimal_rtf_tiny_tbl b on a.d5_5 = b.d5_5
where a.d5_5 != 0
---- RESULTS
37
---- RUNTIME_PROFILE
aggregation(SUM, ProbeRows): 310
====
---- QUERY
#######################################################################
# Test case 4.4.2: DecimalMinMaxFilters with right outer join - 4 bytes
#######################################################################
SET RUNTIME_FILTER_WAIT_TIME_MS=$RUNTIME_FILTER_WAIT_TIME_MS;
select straight_join count(b.d5_5)
from decimal_rtf_tbl a
  right outer join decimal_rtf_tiny_tbl b on a.d5_5 = b.d5_5
where a.d5_5 = 0
---- RESULTS
180
---- RUNTIME_PROFILE
aggregation(SUM, ProbeRows): 180
====
---- QUERY
######################################################################
# Test case 4.5: DecimalMinMaxFilters with right outer join - 8 bytes
######################################################################
SET RUNTIME_FILTER_WAIT_TIME_MS=$RUNTIME_FILTER_WAIT_TIME_MS;
select straight_join count(b.d9_0)
from decimal_rtf_tbl a
  right outer join decimal_rtf_tiny_tbl b on a.d9_0 = b.d9_0
---- RESULTS
40
---- RUNTIME_PROFILE
aggregation(SUM, ProbeRows): 111
====
---- QUERY
######################################################################
# Test case 4.6: DecimalMinMaxFilters with right outer join - 4 bytes
######################################################################
SET RUNTIME_FILTER_WAIT_TIME_MS=$RUNTIME_FILTER_WAIT_TIME_MS;
select straight_join count(b.d9_1)
from decimal_rtf_tbl a
  right outer join decimal_rtf_tiny_tbl b on a.d9_1 = b.d9_1
---- RESULTS
40
---- RUNTIME_PROFILE
aggregation(SUM, ProbeRows): 110
====
---- QUERY
######################################################################
# Test case 4.7: DecimalMinMaxFilters with right outer join - 4 bytes
######################################################################
SET RUNTIME_FILTER_WAIT_TIME_MS=$RUNTIME_FILTER_WAIT_TIME_MS;
select straight_join count(b.d9_5)
from decimal_rtf_tbl a
  right outer join decimal_rtf_tiny_tbl b on a.d9_5 = b.d9_5
---- RESULTS
40
---- RUNTIME_PROFILE
aggregation(SUM, ProbeRows): 136
====
---- QUERY
#######################################################################
# Test case 4.8.1: DecimalMinMaxFilters with right outer join - 4 bytes
#######################################################################
SET RUNTIME_FILTER_WAIT_TIME_MS=$RUNTIME_FILTER_WAIT_TIME_MS;
select straight_join count(b.d9_9)
from decimal_rtf_tbl a
  right outer join decimal_rtf_tiny_tbl b on a.d9_9 = b.d9_9
where a.d9_9 != 0
---- RESULTS
37
---- RUNTIME_PROFILE
aggregation(SUM, ProbeRows): 342
====
---- QUERY
#######################################################################
# Test case 4.8.2: DecimalMinMaxFilters with right outer join - 4 bytes
#######################################################################
SET RUNTIME_FILTER_WAIT_TIME_MS=$RUNTIME_FILTER_WAIT_TIME_MS;
select straight_join count(b.d9_9)
from decimal_rtf_tbl a
  right outer join decimal_rtf_tiny_tbl b on a.d9_9 = b.d9_9
where a.d9_9 = 0
---- RESULTS
306
---- RUNTIME_PROFILE
aggregation(SUM, ProbeRows): 306
====
---- QUERY
######################################################################
# Test case 4.9: DecimalMinMaxFilters with right outer join - 8 bytes
######################################################################
SET RUNTIME_FILTER_WAIT_TIME_MS=$RUNTIME_FILTER_WAIT_TIME_MS;
select straight_join count(b.d14_0)
from decimal_rtf_tbl a
  right outer join decimal_rtf_tiny_tbl b on a.d14_0 = b.d14_0
---- RESULTS
40
---- RUNTIME_PROFILE
aggregation(SUM, ProbeRows): 111
====
---- QUERY
######################################################################
# Test case 4.10: DecimalMinMaxFilters with right outer join - 8 bytes
######################################################################
SET RUNTIME_FILTER_WAIT_TIME_MS=$RUNTIME_FILTER_WAIT_TIME_MS;
select straight_join count(b.d14_1)
from decimal_rtf_tbl a
  right outer join decimal_rtf_tiny_tbl b on a.d14_1 = b.d14_1
---- RESULTS
40
---- RUNTIME_PROFILE
aggregation(SUM, ProbeRows): 110
====
---- QUERY
######################################################################
# Test case 4.11: DecimalMinMaxFilters with right outer join - 8 bytes
######################################################################
SET RUNTIME_FILTER_WAIT_TIME_MS=$RUNTIME_FILTER_WAIT_TIME_MS;
select straight_join count(b.d14_7)
from decimal_rtf_tbl a
  right outer join decimal_rtf_tiny_tbl b on a.d14_7 = b.d14_7
---- RESULTS
40
---- RUNTIME_PROFILE
aggregation(SUM, ProbeRows): 197
====
---- QUERY
########################################################################
# Test case 4.12.1: DecimalMinMaxFilters with right outer join - 8 bytes
########################################################################
SET RUNTIME_FILTER_WAIT_TIME_MS=$RUNTIME_FILTER_WAIT_TIME_MS;
select straight_join count(b.d14_14)
from decimal_rtf_tbl a
  right outer join decimal_rtf_tiny_tbl b on a.d14_14 = b.d14_14
where a.d14_14 != 0
---- RESULTS
37
---- RUNTIME_PROFILE
aggregation(SUM, ProbeRows): 444
====
---- QUERY
########################################################################
# Test case 4.12.2: DecimalMinMaxFilters with right outer join - 8 bytes
########################################################################
SET RUNTIME_FILTER_WAIT_TIME_MS=$RUNTIME_FILTER_WAIT_TIME_MS;
select straight_join count(b.d14_14)
from decimal_rtf_tbl a
  right outer join decimal_rtf_tiny_tbl b on a.d14_14 = b.d14_14
where a.d14_14 = 0
---- RESULTS
441
---- RUNTIME_PROFILE
aggregation(SUM, ProbeRows): 441
====
---- QUERY
######################################################################
# Test case 4.13: DecimalMinMaxFilters with right outer join - 8 bytes
######################################################################
SET RUNTIME_FILTER_WAIT_TIME_MS=$RUNTIME_FILTER_WAIT_TIME_MS;
select straight_join count(b.d18_0)
from decimal_rtf_tbl a
  right outer join decimal_rtf_tiny_tbl b on a.d18_0 = b.d18_0
---- RESULTS
40
---- RUNTIME_PROFILE
aggregation(SUM, ProbeRows): 111
====
---- QUERY
######################################################################
# Test case 4.14: DecimalMinMaxFilters with right outer join - 8 bytes
######################################################################
SET RUNTIME_FILTER_WAIT_TIME_MS=$RUNTIME_FILTER_WAIT_TIME_MS;
select straight_join count(b.d18_1)
from decimal_rtf_tbl a
  right outer join decimal_rtf_tiny_tbl b on a.d18_1 = b.d18_1
---- RESULTS
40
---- RUNTIME_PROFILE
aggregation(SUM, ProbeRows): 110
====
---- QUERY
######################################################################
# Test case 4.15: DecimalMinMaxFilters with right outer join - 8 bytes
######################################################################
SET RUNTIME_FILTER_WAIT_TIME_MS=$RUNTIME_FILTER_WAIT_TIME_MS;
select straight_join count(b.d18_9)
from decimal_rtf_tbl a
  right outer join decimal_rtf_tiny_tbl b on a.d18_9 = b.d18_9
---- RESULTS
40
---- RUNTIME_PROFILE
aggregation(SUM, ProbeRows): 258
====
---- QUERY
########################################################################
# Test case 4.16.1: DecimalMinMaxFilters with right outer join - 8 bytes
########################################################################
SET RUNTIME_FILTER_WAIT_TIME_MS=$RUNTIME_FILTER_WAIT_TIME_MS;
select straight_join count(b.d18_18)
from decimal_rtf_tbl a
  right outer join decimal_rtf_tiny_tbl b on a.d18_18 = b.d18_18
where a.d18_18 != 0
---- RESULTS
37
---- RUNTIME_PROFILE
aggregation(SUM, ProbeRows): 501
====
---- QUERY
########################################################################
# Test case 4.16.2: DecimalMinMaxFilters with right outer join - 8 bytes
########################################################################
SET RUNTIME_FILTER_WAIT_TIME_MS=$RUNTIME_FILTER_WAIT_TIME_MS;
select straight_join count(b.d18_18)
from decimal_rtf_tbl a
  right outer join decimal_rtf_tiny_tbl b on a.d18_18 = b.d18_18
where a.d18_18 = 0
---- RESULTS
531
---- RUNTIME_PROFILE
aggregation(SUM, ProbeRows): 531
====
---- QUERY
#######################################################################
# Test case 4.17: DecimalMinMaxFilters with right outer join - 16 bytes
#######################################################################
SET RUNTIME_FILTER_WAIT_TIME_MS=$RUNTIME_FILTER_WAIT_TIME_MS;
select straight_join count(b.d28_0)
from decimal_rtf_tbl a
  right outer join decimal_rtf_tiny_tbl b on a.d28_0 = b.d28_0
---- RESULTS
40
---- RUNTIME_PROFILE
aggregation(SUM, ProbeRows): 111
====
---- QUERY
#######################################################################
# Test case 4.18: DecimalMinMaxFilters with right outer join - 16 bytes
#######################################################################
SET RUNTIME_FILTER_WAIT_TIME_MS=$RUNTIME_FILTER_WAIT_TIME_MS;
select straight_join count(b.d28_1)
from decimal_rtf_tbl a
  right outer join decimal_rtf_tiny_tbl b on a.d28_1 = b.d28_1
---- RESULTS
40
---- RUNTIME_PROFILE
aggregation(SUM, ProbeRows): 110
====
---- QUERY
#######################################################################
# Test case 4.19: DecimalMinMaxFilters with right outer join - 16 bytes
#######################################################################
SET RUNTIME_FILTER_WAIT_TIME_MS=$RUNTIME_FILTER_WAIT_TIME_MS;
select straight_join count(b.d28_14)
from decimal_rtf_tbl a
  right outer join decimal_rtf_tiny_tbl b on a.d28_14 = b.d28_14
---- RESULTS
40
---- RUNTIME_PROFILE
aggregation(SUM, ProbeRows): 386
====
---- QUERY
#########################################################################
# Test case 4.20.1: DecimalMinMaxFilters with right outer join - 16 bytes
#########################################################################
SET RUNTIME_FILTER_WAIT_TIME_MS=$RUNTIME_FILTER_WAIT_TIME_MS;
select straight_join count(b.d28_28)
from decimal_rtf_tbl a
  right outer join decimal_rtf_tiny_tbl b on a.d28_28 = b.d28_28
where a.d28_28 != 0
---- RESULTS
37
---- RUNTIME_PROFILE
aggregation(SUM, ProbeRows): 620
====
---- QUERY
#########################################################################
# Test case 4.20.2: DecimalMinMaxFilters with right outer join - 16 bytes
#########################################################################
SET RUNTIME_FILTER_WAIT_TIME_MS=$RUNTIME_FILTER_WAIT_TIME_MS;
select straight_join count(b.d28_28)
from decimal_rtf_tbl a
  right outer join decimal_rtf_tiny_tbl b on a.d28_28 = b.d28_28
where a.d28_28 = 0
---- RESULTS
686
---- RUNTIME_PROFILE
aggregation(SUM, ProbeRows): 686
====
---- QUERY
#######################################################################
# Test case 4.21: DecimalMinMaxFilters with right outer join - 16 bytes
#######################################################################
SET RUNTIME_FILTER_WAIT_TIME_MS=$RUNTIME_FILTER_WAIT_TIME_MS;
select straight_join count(b.d38_0)
from decimal_rtf_tbl a
  right outer join decimal_rtf_tiny_tbl b on a.d38_0 = b.d38_0
---- RESULTS
40
---- RUNTIME_PROFILE
aggregation(SUM, ProbeRows): 111
====
---- QUERY
#######################################################################
# Test case 4.22: DecimalMinMaxFilters with right outer join - 16 bytes
#######################################################################
SET RUNTIME_FILTER_WAIT_TIME_MS=$RUNTIME_FILTER_WAIT_TIME_MS;
select straight_join count(b.d38_1)
from decimal_rtf_tbl a
  right outer join decimal_rtf_tiny_tbl b on a.d38_1 = b.d38_1
---- RESULTS
40
---- RUNTIME_PROFILE
aggregation(SUM, ProbeRows): 110
====
---- QUERY
#######################################################################
# Test case 4.23: DecimalMinMaxFilters with right outer join - 16 bytes
#######################################################################
SET RUNTIME_FILTER_WAIT_TIME_MS=$RUNTIME_FILTER_WAIT_TIME_MS;
select straight_join count(b.d38_19)
from decimal_rtf_tbl a
  right outer join decimal_rtf_tiny_tbl b on a.d38_19 = b.d38_19
---- RESULTS
40
---- RUNTIME_PROFILE
aggregation(SUM, ProbeRows): 491
====
---- QUERY
#########################################################################
# Test case 4.24.1: DecimalMinMaxFilters with right outer join - 16 bytes
#########################################################################
SET RUNTIME_FILTER_WAIT_TIME_MS=$RUNTIME_FILTER_WAIT_TIME_MS;
select straight_join count(b.d38_38)
from decimal_rtf_tbl a
  right outer join decimal_rtf_tiny_tbl b on a.d38_38 = b.d38_38
where a.d38_38 != 0
---- RESULTS
37
---- RUNTIME_PROFILE
aggregation(SUM, ProbeRows): 643
====
---- QUERY
#########################################################################
# Test case 4.24.2: DecimalMinMaxFilters with right outer join - 16 bytes
#########################################################################
SET RUNTIME_FILTER_WAIT_TIME_MS=$RUNTIME_FILTER_WAIT_TIME_MS;
select straight_join count(b.d38_38)
from decimal_rtf_tbl a
  right outer join decimal_rtf_tiny_tbl b on a.d38_38 = b.d38_38
where a.d38_38 = 0
---- RESULTS
732
---- RUNTIME_PROFILE
aggregation(SUM, ProbeRows): 732
====
---- QUERY
######################################################################
# Test case 5.1: DecimalMinMaxFilters with left semi join - 4 bytes
######################################################################
SET RUNTIME_FILTER_WAIT_TIME_MS=$RUNTIME_FILTER_WAIT_TIME_MS;
select a.d5_0
from decimal_rtf_tbl a
  left semi join decimal_rtf_tiny_tbl b on a.d5_0 = b.d5_0
order by 1
---- RESULTS: VERIFY_IS_EQUAL_SORTED
1
2
3
4
5
6
11
18
19
27
28
29
38
39
49
78
89
91
167
178
222
223
333
334
444
445
555
556
666
667
777
888
999
1111
1112
7789
8891
9912
---- RUNTIME_PROFILE
aggregation(SUM, ProbeRows): 111
====
---- QUERY
######################################################################
# Test case 5.2: DecimalMinMaxFilters with left semi join - 4 bytes
######################################################################
SET RUNTIME_FILTER_WAIT_TIME_MS=$RUNTIME_FILTER_WAIT_TIME_MS;
select a.d5_1
from decimal_rtf_tbl a
  left semi join decimal_rtf_tiny_tbl b on a.d5_1 = b.d5_1
order by 1
---- RESULTS: VERIFY_IS_EQUAL_SORTED
0.2
0.3
0.4
0.5
0.6
1.0
1.1
1.8
1.9
2.7
2.8
2.9
3.8
3.9
4.9
7.8
8.9
9.1
16.7
17.8
22.2
22.3
33.3
33.4
44.4
44.5
55.5
55.6
66.6
66.7
77.7
88.8
99.9
111.1
111.2
778.9
889.1
991.2
---- RUNTIME_PROFILE
aggregation(SUM, ProbeRows): 110
====
---- QUERY
######################################################################
# Test case 5.3: DecimalMinMaxFilters with left semi join - 4 bytes
######################################################################
SET RUNTIME_FILTER_WAIT_TIME_MS=$RUNTIME_FILTER_WAIT_TIME_MS;
select a.d5_3
from decimal_rtf_tbl a
  left semi join decimal_rtf_tiny_tbl b on a.d5_3 = b.d5_3
order by 1
---- RESULTS: VERIFY_IS_EQUAL_SORTED
0.004
0.005
0.006
0.011
0.018
0.019
0.027
0.028
0.029
0.030
0.038
0.039
0.049
0.078
0.089
0.091
0.167
0.178
0.200
0.222
0.223
0.333
0.334
0.444
0.445
0.555
0.556
0.666
0.667
0.777
0.888
0.999
1.000
1.111
1.112
7.789
8.891
9.912
---- RUNTIME_PROFILE
aggregation(SUM, ProbeRows): 105
====
---- QUERY
######################################################################
# Test case 5.4.1: DecimalMinMaxFilters with left semi join - 4 bytes
######################################################################
SET RUNTIME_FILTER_WAIT_TIME_MS=$RUNTIME_FILTER_WAIT_TIME_MS;
select a.d5_5
from decimal_rtf_tbl a
  left semi join decimal_rtf_tiny_tbl b on a.d5_5 = b.d5_5
where a.d5_5 != 0
order by 1
---- RESULTS: VERIFY_IS_EQUAL_SORTED
0.00006
0.00011
0.00018
0.00019
0.00027
0.00028
0.00029
0.00038
0.00039
0.00049
0.00050
0.00078
0.00089
0.00091
0.00167
0.00178
0.00222
0.00223
0.00333
0.00334
0.00400
0.00444
0.00445
0.00555
0.00556
0.00666
0.00667
0.00777
0.00888
0.00999
0.01111
0.01112
0.03000
0.07789
0.08891
0.09912
0.20000
---- RUNTIME_PROFILE
aggregation(SUM, ProbeRows): 310
====
---- QUERY
######################################################################
# Test case 5.4.2: DecimalMinMaxFilters with left semi join - 4 bytes
######################################################################
SET RUNTIME_FILTER_WAIT_TIME_MS=$RUNTIME_FILTER_WAIT_TIME_MS;
select count(a.d5_5)
from decimal_rtf_tbl a
  left semi join decimal_rtf_tiny_tbl b on a.d5_5 = b.d5_5
where a.d5_5 = 0
---- RESULTS: VERIFY_IS_EQUAL_SORTED
180
---- RUNTIME_PROFILE
aggregation(SUM, ProbeRows): 180
====
---- QUERY
######################################################################
# Test case 5.5: DecimalMinMaxFilters with left semi join - 8 bytes
######################################################################
SET RUNTIME_FILTER_WAIT_TIME_MS=$RUNTIME_FILTER_WAIT_TIME_MS;
select a.d9_0
from decimal_rtf_tbl a
  left semi join decimal_rtf_tiny_tbl b on a.d9_0 = b.d9_0
order by 1
---- RESULTS: VERIFY_IS_EQUAL_SORTED
1
2
3
4
5
6
11
18
19
27
28
29
38
39
49
78
89
91
167
178
222
223
333
334
444
445
555
556
666
667
777
888
999
1111
1112
7789
8891
9912
---- RUNTIME_PROFILE
aggregation(SUM, ProbeRows): 111
====
---- QUERY
######################################################################
# Test case 5.6: DecimalMinMaxFilters with left semi join - 4 bytes
######################################################################
SET RUNTIME_FILTER_WAIT_TIME_MS=$RUNTIME_FILTER_WAIT_TIME_MS;
select a.d9_1
from decimal_rtf_tbl a
  left semi join decimal_rtf_tiny_tbl b on a.d9_1 = b.d9_1
order by 1
---- RESULTS: VERIFY_IS_EQUAL_SORTED
0.2
0.3
0.4
0.5
0.6
1.0
1.1
1.8
1.9
2.7
2.8
2.9
3.8
3.9
4.9
7.8
8.9
9.1
16.7
17.8
22.2
22.3
33.3
33.4
44.4
44.5
55.5
55.6
66.6
66.7
77.7
88.8
99.9
111.1
111.2
778.9
889.1
991.2
---- RUNTIME_PROFILE
aggregation(SUM, ProbeRows): 110
====
---- QUERY
######################################################################
# Test case 5.7: DecimalMinMaxFilters with left semi join - 4 bytes
######################################################################
SET RUNTIME_FILTER_WAIT_TIME_MS=$RUNTIME_FILTER_WAIT_TIME_MS;
select a.d9_5
from decimal_rtf_tbl a
  left semi join decimal_rtf_tiny_tbl b on a.d9_5 = b.d9_5
order by 1
---- RESULTS: VERIFY_IS_EQUAL_SORTED
0.00006
0.00011
0.00018
0.00019
0.00027
0.00028
0.00029
0.00038
0.00039
0.00049
0.00050
0.00078
0.00089
0.00091
0.00167
0.00178
0.00222
0.00223
0.00333
0.00334
0.00400
0.00444
0.00445
0.00555
0.00556
0.00666
0.00667
0.00777
0.00888
0.00999
0.01111
0.01112
0.03000
0.07789
0.08891
0.09912
0.20000
1.00000
---- RUNTIME_PROFILE
aggregation(SUM, ProbeRows): 136
====
---- QUERY
######################################################################
# Test case 5.8.1: DecimalMinMaxFilters with left semi join - 4 bytes
######################################################################
SET RUNTIME_FILTER_WAIT_TIME_MS=$RUNTIME_FILTER_WAIT_TIME_MS;
select a.d9_9
from decimal_rtf_tbl a
  left semi join decimal_rtf_tiny_tbl b on a.d9_9 = b.d9_9
where a.d9_9 != 0
order by 1
---- RESULTS: VERIFY_IS_EQUAL_SORTED
0.000000011
0.000000018
0.000000019
0.000000027
0.000000028
0.000000029
0.000000038
0.000000039
0.000000049
0.000000167
0.000000178
0.000000222
0.000000223
0.000000333
0.000000334
0.000000444
0.000000445
0.000000555
0.000000556
0.000000666
0.000000667
0.000000777
0.000000888
0.000000910
0.000000999
0.000001111
0.000001112
0.000007789
0.000008891
0.000008900
0.000009912
0.000060000
0.000078000
0.000500000
0.004000000
0.030000000
0.200000000
---- RUNTIME_PROFILE
aggregation(SUM, ProbeRows): 342
====
---- QUERY
######################################################################
# Test case 5.8.2: DecimalMinMaxFilters with left semi join - 4 bytes
######################################################################
SET RUNTIME_FILTER_WAIT_TIME_MS=$RUNTIME_FILTER_WAIT_TIME_MS;
select count(a.d9_9)
from decimal_rtf_tbl a
  left semi join decimal_rtf_tiny_tbl b on a.d9_9 = b.d9_9
where a.d9_9 = 0
---- RESULTS: VERIFY_IS_EQUAL_SORTED
306
---- RUNTIME_PROFILE
aggregation(SUM, ProbeRows): 306
====
---- QUERY
######################################################################
# Test case 5.9: DecimalMinMaxFilters with left semi join - 8 bytes
######################################################################
SET RUNTIME_FILTER_WAIT_TIME_MS=$RUNTIME_FILTER_WAIT_TIME_MS;
select a.d14_0
from decimal_rtf_tbl a
  left semi join decimal_rtf_tiny_tbl b on a.d14_0 = b.d14_0
order by 1
---- RESULTS: VERIFY_IS_EQUAL_SORTED
1
2
3
4
5
6
11
18
19
27
28
29
38
39
49
78
89
91
167
178
222
223
333
334
444
445
555
556
666
667
777
888
999
1111
1112
7789
8891
9912
---- RUNTIME_PROFILE
aggregation(SUM, ProbeRows): 111
====
---- QUERY
######################################################################
# Test case 5.10: DecimalMinMaxFilters with left semi join - 8 bytes
######################################################################
SET RUNTIME_FILTER_WAIT_TIME_MS=$RUNTIME_FILTER_WAIT_TIME_MS;
select a.d14_1
from decimal_rtf_tbl a
  left semi join decimal_rtf_tiny_tbl b on a.d14_1 = b.d14_1
order by 1
---- RESULTS: VERIFY_IS_EQUAL_SORTED
0.2
0.3
0.4
0.5
0.6
1.0
1.1
1.8
1.9
2.7
2.8
2.9
3.8
3.9
4.9
7.8
8.9
9.1
16.7
17.8
22.2
22.3
33.3
33.4
44.4
44.5
55.5
55.6
66.6
66.7
77.7
88.8
99.9
111.1
111.2
778.9
889.1
991.2
---- RUNTIME_PROFILE
aggregation(SUM, ProbeRows): 110
====
---- QUERY
######################################################################
# Test case 5.11: DecimalMinMaxFilters with left semi join - 8 bytes
######################################################################
SET RUNTIME_FILTER_WAIT_TIME_MS=$RUNTIME_FILTER_WAIT_TIME_MS;
select a.d14_7
from decimal_rtf_tbl a
  left semi join decimal_rtf_tiny_tbl b on a.d14_7 = b.d14_7
order by 1
---- RESULTS: VERIFY_IS_EQUAL_SORTED
0.0000011
0.0000018
0.0000019
0.0000027
0.0000028
0.0000029
0.0000038
0.0000039
0.0000049
0.0000089
0.0000091
0.0000167
0.0000178
0.0000222
0.0000223
0.0000333
0.0000334
0.0000444
0.0000445
0.0000555
0.0000556
0.0000600
0.0000666
0.0000667
0.0000777
0.0000780
0.0000888
0.0000999
0.0001111
0.0001112
0.0005000
0.0007789
0.0008891
0.0009912
0.0040000
0.0300000
0.2000000
1.0000000
---- RUNTIME_PROFILE
aggregation(SUM, ProbeRows): 197
====
---- QUERY
######################################################################
# Test case 5.12.1: DecimalMinMaxFilters with left semi join - 8 bytes
######################################################################
SET RUNTIME_FILTER_WAIT_TIME_MS=$RUNTIME_FILTER_WAIT_TIME_MS;
select a.d14_14
from decimal_rtf_tbl a
  left semi join decimal_rtf_tiny_tbl b on a.d14_14 = b.d14_14
where a.d14_14 != 0
order by 1
---- RESULTS: VERIFY_IS_EQUAL_SORTED
0.00000000000018
0.00000000000019
0.00000000000027
0.00000000000028
0.00000000000029
0.00000000000038
0.00000000000039
0.00000000000049
0.00000000000167
0.00000000000178
0.00000000000222
0.00000000000333
0.00000000000444
0.00000000000555
0.00000000000666
0.00000000000667
0.00000000000777
0.00000000000888
0.00000000000999
0.00000000001111
0.00000000001112
0.00000000005560
0.00000000007789
0.00000000008891
0.00000000009912
0.00000000044500
0.00000000334000
0.00000001100000
0.00000002230000
0.00000091000000
0.00000890000000
0.00006000000000
0.00007800000000
0.00050000000000
0.00400000000000
0.03000000000000
0.20000000000000
---- RUNTIME_PROFILE
aggregation(SUM, ProbeRows): 442
====
---- QUERY
######################################################################
# Test case 5.12.2: DecimalMinMaxFilters with left semi join - 8 bytes
######################################################################
SET RUNTIME_FILTER_WAIT_TIME_MS=$RUNTIME_FILTER_WAIT_TIME_MS;
select count(a.d14_14)
from decimal_rtf_tbl a
  left semi join decimal_rtf_tiny_tbl b on a.d14_14 = b.d14_14
where a.d14_14 = 0
order by 1
---- RESULTS: VERIFY_IS_EQUAL_SORTED
441
---- RUNTIME_PROFILE
aggregation(SUM, ProbeRows): 441
====
---- QUERY
######################################################################
# Test case 5.13: DecimalMinMaxFilters with left semi join - 8 bytes
######################################################################
SET RUNTIME_FILTER_WAIT_TIME_MS=$RUNTIME_FILTER_WAIT_TIME_MS;
select a.d18_0
from decimal_rtf_tbl a
  left semi join decimal_rtf_tiny_tbl b on a.d18_0 = b.d18_0
order by 1
---- RESULTS: VERIFY_IS_EQUAL_SORTED
1
2
3
4
5
6
11
18
19
27
28
29
38
39
49
78
89
91
167
178
222
223
333
334
444
445
555
556
666
667
777
888
999
1111
1112
7789
8891
9912
---- RUNTIME_PROFILE
aggregation(SUM, ProbeRows): 111
====
---- QUERY
######################################################################
# Test case 5.14: DecimalMinMaxFilters with left semi join - 8 bytes
######################################################################
SET RUNTIME_FILTER_WAIT_TIME_MS=$RUNTIME_FILTER_WAIT_TIME_MS;
select a.d18_1
from decimal_rtf_tbl a
  left semi join decimal_rtf_tiny_tbl b on a.d18_1 = b.d18_1
order by 1
---- RESULTS: VERIFY_IS_EQUAL_SORTED
0.2
0.3
0.4
0.5
0.6
1.0
1.1
1.8
1.9
2.7
2.8
2.9
3.8
3.9
4.9
7.8
8.9
9.1
16.7
17.8
22.2
22.3
33.3
33.4
44.4
44.5
55.5
55.6
66.6
66.7
77.7
88.8
99.9
111.1
111.2
778.9
889.1
991.2
---- RUNTIME_PROFILE
aggregation(SUM, ProbeRows): 110
====
---- QUERY
######################################################################
# Test case 5.15: DecimalMinMaxFilters with left semi join - 8 bytes
######################################################################
SET RUNTIME_FILTER_WAIT_TIME_MS=$RUNTIME_FILTER_WAIT_TIME_MS;
select a.d18_9
from decimal_rtf_tbl a
  left semi join decimal_rtf_tiny_tbl b on a.d18_9 = b.d18_9
order by 1
---- RESULTS: VERIFY_IS_EQUAL_SORTED
0.000000011
0.000000018
0.000000019
0.000000027
0.000000028
0.000000029
0.000000038
0.000000039
0.000000049
0.000000167
0.000000178
0.000000222
0.000000223
0.000000333
0.000000334
0.000000444
0.000000445
0.000000555
0.000000556
0.000000666
0.000000667
0.000000777
0.000000888
0.000000910
0.000000999
0.000001111
0.000001112
0.000007789
0.000008891
0.000008900
0.000009912
0.000060000
0.000078000
0.000500000
0.004000000
0.030000000
0.200000000
1.000000000
---- RUNTIME_PROFILE
aggregation(SUM, ProbeRows): 258
====
---- QUERY
######################################################################
# Test case 5.16.1: DecimalMinMaxFilters with left semi join - 8 bytes
######################################################################
SET RUNTIME_FILTER_WAIT_TIME_MS=$RUNTIME_FILTER_WAIT_TIME_MS;
select a.d18_18
from decimal_rtf_tbl a
  left semi join decimal_rtf_tiny_tbl b on a.d18_18 = b.d18_18
where a.d18_18 != 0
order by 1
---- RESULTS: VERIFY_IS_EQUAL_SORTED
0.000000000000000018
0.000000000000000019
0.000000000000000027
0.000000000000000028
0.000000000000000029
0.000000000000000038
0.000000000000000039
0.000000000000000049
0.000000000000000167
0.000000000000000178
0.000000000000000222
0.000000000000000333
0.000000000000000444
0.000000000000000555
0.000000000000000666
0.000000000000000777
0.000000000000000888
0.000000000000000999
0.000000000000001111
0.000000000000001112
0.000000000000099120
0.000000000000889100
0.000000000006670000
0.000000000007789000
0.000000000055600000
0.000000000445000000
0.000000003340000000
0.000000011000000000
0.000000022300000000
0.000000910000000000
0.000008900000000000
0.000060000000000000
0.000078000000000000
0.000500000000000000
0.004000000000000000
0.030000000000000000
0.200000000000000000
---- RUNTIME_PROFILE
aggregation(SUM, ProbeRows): 499
====
---- QUERY
######################################################################
# Test case 5.16.2: DecimalMinMaxFilters with left semi join - 8 bytes
######################################################################
SET RUNTIME_FILTER_WAIT_TIME_MS=$RUNTIME_FILTER_WAIT_TIME_MS;
select count(a.d18_18)
from decimal_rtf_tbl a
  left semi join decimal_rtf_tiny_tbl b on a.d18_18 = b.d18_18
where a.d18_18 = 0
---- RESULTS: VERIFY_IS_EQUAL_SORTED
531
---- RUNTIME_PROFILE
aggregation(SUM, ProbeRows): 531
====
---- QUERY
#######################################################################
# Test case 5.17: DecimalMinMaxFilters with left semi join - 16 bytes
#######################################################################
SET RUNTIME_FILTER_WAIT_TIME_MS=$RUNTIME_FILTER_WAIT_TIME_MS;
select a.d28_0
from decimal_rtf_tbl a
  left semi join decimal_rtf_tiny_tbl b on a.d28_0 = b.d28_0
order by 1
---- RESULTS: VERIFY_IS_EQUAL_SORTED
1
2
3
4
5
6
11
18
19
27
28
29
38
39
49
78
89
91
167
178
222
223
333
334
444
445
555
556
666
667
777
888
999
1111
1112
7789
8891
9912
---- RUNTIME_PROFILE
aggregation(SUM, ProbeRows): 111
====
---- QUERY
#######################################################################
# Test case 5.18: DecimalMinMaxFilters with left semi join - 16 bytes
#######################################################################
SET RUNTIME_FILTER_WAIT_TIME_MS=$RUNTIME_FILTER_WAIT_TIME_MS;
select a.d28_1
from decimal_rtf_tbl a
  left semi join decimal_rtf_tiny_tbl b on a.d28_1 = b.d28_1
order by 1
---- RESULTS: VERIFY_IS_EQUAL_SORTED
0.2
0.3
0.4
0.5
0.6
1.0
1.1
1.8
1.9
2.7
2.8
2.9
3.8
3.9
4.9
7.8
8.9
9.1
16.7
17.8
22.2
22.3
33.3
33.4
44.4
44.5
55.5
55.6
66.6
66.7
77.7
88.8
99.9
111.1
111.2
778.9
889.1
991.2
---- RUNTIME_PROFILE
aggregation(SUM, ProbeRows): 110
====
---- QUERY
#######################################################################
# Test case 5.19: DecimalMinMaxFilters with left semi join - 16 bytes
#######################################################################
SET RUNTIME_FILTER_WAIT_TIME_MS=$RUNTIME_FILTER_WAIT_TIME_MS;
select a.d28_14
from decimal_rtf_tbl a
  left semi join decimal_rtf_tiny_tbl b on a.d28_14 = b.d28_14
order by 1
---- RESULTS: VERIFY_IS_EQUAL_SORTED
0.00000000000018
0.00000000000019
0.00000000000027
0.00000000000028
0.00000000000029
0.00000000000038
0.00000000000039
0.00000000000049
0.00000000000167
0.00000000000178
0.00000000000222
0.00000000000333
0.00000000000444
0.00000000000555
0.00000000000666
0.00000000000667
0.00000000000777
0.00000000000888
0.00000000000999
0.00000000001111
0.00000000001112
0.00000000005560
0.00000000007789
0.00000000008891
0.00000000009912
0.00000000044500
0.00000000334000
0.00000001100000
0.00000002230000
0.00000091000000
0.00000890000000
0.00006000000000
0.00007800000000
0.00050000000000
0.00400000000000
0.03000000000000
0.20000000000000
1.00000000000000
---- RUNTIME_PROFILE
aggregation(SUM, ProbeRows): 386
====
---- QUERY
#######################################################################
# Test case 5.20.1: DecimalMinMaxFilters with left semi join - 16 bytes
#######################################################################
SET RUNTIME_FILTER_WAIT_TIME_MS=$RUNTIME_FILTER_WAIT_TIME_MS;
select a.d28_28
from decimal_rtf_tbl a
  left semi join decimal_rtf_tiny_tbl b on a.d28_28 = b.d28_28
where a.d28_28 != 0
order by 1
---- RESULTS: VERIFY_IS_EQUAL_SORTED
0.0000000000000000000000000018
0.0000000000000000000000000019
0.0000000000000000000000000027
0.0000000000000000000000000028
0.0000000000000000000000000029
0.0000000000000000000000000038
0.0000000000000000000000000039
0.0000000000000000000000000049
0.0000000000000000000000000178
0.0000000000000000000000001111
0.0000000000000000000000001670
0.0000000000000000000000099900
0.0000000000000000000000888000
0.0000000000000000000007770000
0.0000000000000000000066600000
0.0000000000000000000555000000
0.0000000000000000004440000000
0.0000000000000000033300000000
0.0000000000000000222000000000
0.0000000000000011120000000000
0.0000000000000991200000000000
0.0000000000008891000000000000
0.0000000000066700000000000000
0.0000000000077890000000000000
0.0000000000556000000000000000
0.0000000004450000000000000000
0.0000000033400000000000000000
0.0000000110000000000000000000
0.0000000223000000000000000000
0.0000009100000000000000000000
0.0000089000000000000000000000
0.0000600000000000000000000000
0.0000780000000000000000000000
0.0005000000000000000000000000
0.0040000000000000000000000000
0.0300000000000000000000000000
0.2000000000000000000000000000
---- RUNTIME_PROFILE
aggregation(SUM, ProbeRows): 619
====
---- QUERY
#######################################################################
# Test case 5.20.2: DecimalMinMaxFilters with left semi join - 16 bytes
#######################################################################
SET RUNTIME_FILTER_WAIT_TIME_MS=$RUNTIME_FILTER_WAIT_TIME_MS;
select count(a.d28_28)
from decimal_rtf_tbl a
  left semi join decimal_rtf_tiny_tbl b on a.d28_28 = b.d28_28
where a.d28_28 = 0
order by 1
---- RESULTS: VERIFY_IS_EQUAL_SORTED
686
---- RUNTIME_PROFILE
aggregation(SUM, ProbeRows): 686
====
---- QUERY
#######################################################################
# Test case 5.21: DecimalMinMaxFilters with left semi join - 16 bytes
#######################################################################
SET RUNTIME_FILTER_WAIT_TIME_MS=$RUNTIME_FILTER_WAIT_TIME_MS;
select a.d38_0
from decimal_rtf_tbl a
  left semi join decimal_rtf_tiny_tbl b on a.d38_0 = b.d38_0
order by 1
---- RESULTS: VERIFY_IS_EQUAL_SORTED
1
2
3
4
5
6
11
18
19
27
28
29
38
39
49
78
89
91
167
178
222
223
333
334
444
445
555
556
666
667
777
888
999
1111
1112
7789
8891
9912
---- RUNTIME_PROFILE
aggregation(SUM, ProbeRows): 111
====
---- QUERY
#######################################################################
# Test case 5.22: DecimalMinMaxFilters with left semi join - 16 bytes
#######################################################################
SET RUNTIME_FILTER_WAIT_TIME_MS=$RUNTIME_FILTER_WAIT_TIME_MS;
select a.d38_1
from decimal_rtf_tbl a
  left semi join decimal_rtf_tiny_tbl b on a.d38_1 = b.d38_1
order by 1
---- RESULTS: VERIFY_IS_EQUAL_SORTED
0.2
0.3
0.4
0.5
0.6
1.0
1.1
1.8
1.9
2.7
2.8
2.9
3.8
3.9
4.9
7.8
8.9
9.1
16.7
17.8
22.2
22.3
33.3
33.4
44.4
44.5
55.5
55.6
66.6
66.7
77.7
88.8
99.9
111.1
111.2
778.9
889.1
991.2
---- RUNTIME_PROFILE
aggregation(SUM, ProbeRows): 110
====
---- QUERY
#######################################################################
# Test case 5.23: DecimalMinMaxFilters with left semi join - 16 bytes
#######################################################################
SET RUNTIME_FILTER_WAIT_TIME_MS=$RUNTIME_FILTER_WAIT_TIME_MS;
select a.d38_19
from decimal_rtf_tbl a
  left semi join decimal_rtf_tiny_tbl b on a.d38_19 = b.d38_19
order by 1
---- RESULTS: VERIFY_IS_EQUAL_SORTED
0.0000000000000000018
0.0000000000000000019
0.0000000000000000027
0.0000000000000000028
0.0000000000000000029
0.0000000000000000038
0.0000000000000000039
0.0000000000000000049
0.0000000000000000167
0.0000000000000000178
0.0000000000000000222
0.0000000000000000333
0.0000000000000000444
0.0000000000000000555
0.0000000000000000666
0.0000000000000000777
0.0000000000000000888
0.0000000000000000999
0.0000000000000001111
0.0000000000000011120
0.0000000000000991200
0.0000000000008891000
0.0000000000066700000
0.0000000000077890000
0.0000000000556000000
0.0000000004450000000
0.0000000033400000000
0.0000000110000000000
0.0000000223000000000
0.0000009100000000000
0.0000089000000000000
0.0000600000000000000
0.0000780000000000000
0.0005000000000000000
0.0040000000000000000
0.0300000000000000000
0.2000000000000000000
1.0000000000000000000
---- RUNTIME_PROFILE
aggregation(SUM, ProbeRows): 491
====
---- QUERY
#######################################################################
# Test case 5.24.1: DecimalMinMaxFilters with left semi join - 16 bytes
#######################################################################
SET RUNTIME_FILTER_WAIT_TIME_MS=$RUNTIME_FILTER_WAIT_TIME_MS;
select a.d38_38
from decimal_rtf_tbl a
  left semi join decimal_rtf_tiny_tbl b on a.d38_38 = b.d38_38
where a.d38_38 != 0
order by 1
---- RESULTS: VERIFY_IS_EQUAL_SORTED
0.00000000000000000000000000000000000490
0.00000000000000000000000000000000001111
0.00000000000000000000000000000000003900
0.00000000000000000000000000000000038000
0.00000000000000000000000000000000290000
0.00000000000000000000000000000002800000
0.00000000000000000000000000000027000000
0.00000000000000000000000000000190000000
0.00000000000000000000000000001800000000
0.00000000000000000000000001780000000000
0.00000000000000000000000016700000000000
0.00000000000000000000000999000000000000
0.00000000000000000000008880000000000000
0.00000000000000000000077700000000000000
0.00000000000000000000666000000000000000
0.00000000000000000005550000000000000000
0.00000000000000000044400000000000000000
0.00000000000000000333000000000000000000
0.00000000000000002220000000000000000000
0.00000000000000111200000000000000000000
0.00000000000009912000000000000000000000
0.00000000000088910000000000000000000000
0.00000000000667000000000000000000000000
0.00000000000778900000000000000000000000
0.00000000005560000000000000000000000000
0.00000000044500000000000000000000000000
0.00000000334000000000000000000000000000
0.00000001100000000000000000000000000000
0.00000002230000000000000000000000000000
0.00000091000000000000000000000000000000
0.00000890000000000000000000000000000000
0.00006000000000000000000000000000000000
0.00007800000000000000000000000000000000
0.00050000000000000000000000000000000000
0.00400000000000000000000000000000000000
0.03000000000000000000000000000000000000
0.20000000000000000000000000000000000000
---- RUNTIME_PROFILE
aggregation(SUM, ProbeRows): 643
====
---- QUERY
#######################################################################
# Test case 5.24.2: DecimalMinMaxFilters with left semi join - 16 bytes
#######################################################################
SET RUNTIME_FILTER_WAIT_TIME_MS=$RUNTIME_FILTER_WAIT_TIME_MS;
select count(a.d38_38)
from decimal_rtf_tbl a
  left semi join decimal_rtf_tiny_tbl b on a.d38_38 = b.d38_38
where a.d38_38 = 0
order by 1
---- RESULTS: VERIFY_IS_EQUAL_SORTED
732
---- RUNTIME_PROFILE
aggregation(SUM, ProbeRows): 732
====

---- QUERY
######################################################################
# Test case 6.1: DecimalMinMaxFilters with right semi join - 4 bytes
######################################################################
SET RUNTIME_FILTER_WAIT_TIME_MS=$RUNTIME_FILTER_WAIT_TIME_MS;
select b.d5_0
from decimal_rtf_tbl a
  right semi join decimal_rtf_tiny_tbl b on a.d5_0 = b.d5_0
order by 1
---- RESULTS: VERIFY_IS_EQUAL_SORTED
1
2
3
4
5
6
11
18
19
27
28
29
38
39
49
78
89
91
167
178
222
223
333
334
444
445
555
556
666
667
777
888
999
1111
1112
7789
8891
9912
---- RUNTIME_PROFILE
aggregation(SUM, ProbeRows): 111
====
---- QUERY
######################################################################
# Test case 6.2: DecimalMinMaxFilters with right semi join - 4 bytes
######################################################################
SET RUNTIME_FILTER_WAIT_TIME_MS=$RUNTIME_FILTER_WAIT_TIME_MS;
select b.d5_1
from decimal_rtf_tbl a
  right semi join decimal_rtf_tiny_tbl b on a.d5_1 = b.d5_1
order by 1
---- RESULTS: VERIFY_IS_EQUAL_SORTED
0.2
0.3
0.4
0.5
0.6
1.0
1.1
1.8
1.9
2.7
2.8
2.9
3.8
3.9
4.9
7.8
8.9
9.1
16.7
17.8
22.2
22.3
33.3
33.4
44.4
44.5
55.5
55.6
66.6
66.7
77.7
88.8
99.9
111.1
111.2
778.9
889.1
991.2
---- RUNTIME_PROFILE
aggregation(SUM, ProbeRows): 110
====
---- QUERY
######################################################################
# Test case 6.3: DecimalMinMaxFilters with right semi join - 4 bytes
######################################################################
SET RUNTIME_FILTER_WAIT_TIME_MS=$RUNTIME_FILTER_WAIT_TIME_MS;
select b.d5_3
from decimal_rtf_tbl a
  right semi join decimal_rtf_tiny_tbl b on a.d5_3 = b.d5_3
order by 1
---- RESULTS: VERIFY_IS_EQUAL_SORTED
0.004
0.005
0.006
0.011
0.018
0.019
0.027
0.028
0.029
0.030
0.038
0.039
0.049
0.078
0.089
0.091
0.167
0.178
0.200
0.222
0.223
0.333
0.334
0.444
0.445
0.555
0.556
0.666
0.667
0.777
0.888
0.999
1.000
1.111
1.112
7.789
8.891
9.912
---- RUNTIME_PROFILE
aggregation(SUM, ProbeRows): 105
====
---- QUERY
######################################################################
# Test case 6.4: DecimalMinMaxFilters with right semi join - 4 bytes
######################################################################
SET RUNTIME_FILTER_WAIT_TIME_MS=$RUNTIME_FILTER_WAIT_TIME_MS;
select b.d5_5
from decimal_rtf_tbl a
  right semi join decimal_rtf_tiny_tbl b on a.d5_5 = b.d5_5
order by 1
---- RESULTS: VERIFY_IS_EQUAL_SORTED
0.00000
0.00006
0.00011
0.00018
0.00019
0.00027
0.00028
0.00029
0.00038
0.00039
0.00049
0.00050
0.00078
0.00089
0.00091
0.00167
0.00178
0.00222
0.00223
0.00333
0.00334
0.00400
0.00444
0.00445
0.00555
0.00556
0.00666
0.00667
0.00777
0.00888
0.00999
0.01111
0.01112
0.03000
0.07789
0.08891
0.09912
0.20000
---- RUNTIME_PROFILE
aggregation(SUM, ProbeRows): 490
====
---- QUERY
######################################################################
# Test case 6.5: DecimalMinMaxFilters with right semi join - 8 bytes
######################################################################
SET RUNTIME_FILTER_WAIT_TIME_MS=$RUNTIME_FILTER_WAIT_TIME_MS;
select b.d9_0
from decimal_rtf_tbl a
  right semi join decimal_rtf_tiny_tbl b on a.d9_0 = b.d9_0
order by 1
---- RESULTS: VERIFY_IS_EQUAL_SORTED
1
2
3
4
5
6
11
18
19
27
28
29
38
39
49
78
89
91
167
178
222
223
333
334
444
445
555
556
666
667
777
888
999
1111
1112
7789
8891
9912
---- RUNTIME_PROFILE
aggregation(SUM, ProbeRows): 111
====
---- QUERY
######################################################################
# Test case 6.6: DecimalMinMaxFilters with right semi join - 4 bytes
######################################################################
SET RUNTIME_FILTER_WAIT_TIME_MS=$RUNTIME_FILTER_WAIT_TIME_MS;
select b.d9_1
from decimal_rtf_tbl a
  right semi join decimal_rtf_tiny_tbl b on a.d9_1 = b.d9_1
order by 1
---- RESULTS: VERIFY_IS_EQUAL_SORTED
0.2
0.3
0.4
0.5
0.6
1.0
1.1
1.8
1.9
2.7
2.8
2.9
3.8
3.9
4.9
7.8
8.9
9.1
16.7
17.8
22.2
22.3
33.3
33.4
44.4
44.5
55.5
55.6
66.6
66.7
77.7
88.8
99.9
111.1
111.2
778.9
889.1
991.2
---- RUNTIME_PROFILE
aggregation(SUM, ProbeRows): 110
====
---- QUERY
######################################################################
# Test case 6.7: DecimalMinMaxFilters with right semi join - 4 bytes
######################################################################
SET RUNTIME_FILTER_WAIT_TIME_MS=$RUNTIME_FILTER_WAIT_TIME_MS;
select b.d9_5
from decimal_rtf_tbl a
  right semi join decimal_rtf_tiny_tbl b on a.d9_5 = b.d9_5
order by 1
---- RESULTS: VERIFY_IS_EQUAL_SORTED
0.00006
0.00011
0.00018
0.00019
0.00027
0.00028
0.00029
0.00038
0.00039
0.00049
0.00050
0.00078
0.00089
0.00091
0.00167
0.00178
0.00222
0.00223
0.00333
0.00334
0.00400
0.00444
0.00445
0.00555
0.00556
0.00666
0.00667
0.00777
0.00888
0.00999
0.01111
0.01112
0.03000
0.07789
0.08891
0.09912
0.20000
1.00000
---- RUNTIME_PROFILE
aggregation(SUM, ProbeRows): 136
====
---- QUERY
######################################################################
# Test case 6.8: DecimalMinMaxFilters with right semi join - 4 bytes
######################################################################
SET RUNTIME_FILTER_WAIT_TIME_MS=$RUNTIME_FILTER_WAIT_TIME_MS;
select b.d9_9
from decimal_rtf_tbl a
  right semi join decimal_rtf_tiny_tbl b on a.d9_9 = b.d9_9
order by 1
---- RESULTS: VERIFY_IS_EQUAL_SORTED
0.000000000
0.000000011
0.000000018
0.000000019
0.000000027
0.000000028
0.000000029
0.000000038
0.000000039
0.000000049
0.000000167
0.000000178
0.000000222
0.000000223
0.000000333
0.000000334
0.000000444
0.000000445
0.000000555
0.000000556
0.000000666
0.000000667
0.000000777
0.000000888
0.000000910
0.000000999
0.000001111
0.000001112
0.000007789
0.000008891
0.000008900
0.000009912
0.000060000
0.000078000
0.000500000
0.004000000
0.030000000
0.200000000
---- RUNTIME_PROFILE
aggregation(SUM, ProbeRows): 648
====
---- QUERY
######################################################################
# Test case 6.9: DecimalMinMaxFilters with right semi join - 8 bytes
######################################################################
SET RUNTIME_FILTER_WAIT_TIME_MS=$RUNTIME_FILTER_WAIT_TIME_MS;
select b.d14_0
from decimal_rtf_tbl a
  right semi join decimal_rtf_tiny_tbl b on a.d14_0 = b.d14_0
order by 1
---- RESULTS: VERIFY_IS_EQUAL_SORTED
1
2
3
4
5
6
11
18
19
27
28
29
38
39
49
78
89
91
167
178
222
223
333
334
444
445
555
556
666
667
777
888
999
1111
1112
7789
8891
9912
---- RUNTIME_PROFILE
aggregation(SUM, ProbeRows): 111
====
---- QUERY
######################################################################
# Test case 6.10: DecimalMinMaxFilters with right semi join - 8 bytes
######################################################################
SET RUNTIME_FILTER_WAIT_TIME_MS=$RUNTIME_FILTER_WAIT_TIME_MS;
select b.d14_1
from decimal_rtf_tbl a
  right semi join decimal_rtf_tiny_tbl b on a.d14_1 = b.d14_1
order by 1
---- RESULTS: VERIFY_IS_EQUAL_SORTED
0.2
0.3
0.4
0.5
0.6
1.0
1.1
1.8
1.9
2.7
2.8
2.9
3.8
3.9
4.9
7.8
8.9
9.1
16.7
17.8
22.2
22.3
33.3
33.4
44.4
44.5
55.5
55.6
66.6
66.7
77.7
88.8
99.9
111.1
111.2
778.9
889.1
991.2
---- RUNTIME_PROFILE
aggregation(SUM, ProbeRows): 110
====
---- QUERY
######################################################################
# Test case 6.11: DecimalMinMaxFilters with right semi join - 8 bytes
######################################################################
SET RUNTIME_FILTER_WAIT_TIME_MS=$RUNTIME_FILTER_WAIT_TIME_MS;
select b.d14_7
from decimal_rtf_tbl a
  right semi join decimal_rtf_tiny_tbl b on a.d14_7 = b.d14_7
order by 1
---- RESULTS: VERIFY_IS_EQUAL_SORTED
0.0000011
0.0000018
0.0000019
0.0000027
0.0000028
0.0000029
0.0000038
0.0000039
0.0000049
0.0000089
0.0000091
0.0000167
0.0000178
0.0000222
0.0000223
0.0000333
0.0000334
0.0000444
0.0000445
0.0000555
0.0000556
0.0000600
0.0000666
0.0000667
0.0000777
0.0000780
0.0000888
0.0000999
0.0001111
0.0001112
0.0005000
0.0007789
0.0008891
0.0009912
0.0040000
0.0300000
0.2000000
1.0000000
---- RUNTIME_PROFILE
aggregation(SUM, ProbeRows): 197
====
---- QUERY
######################################################################
# Test case 6.12: DecimalMinMaxFilters with right semi join - 8 bytes
######################################################################
SET RUNTIME_FILTER_WAIT_TIME_MS=$RUNTIME_FILTER_WAIT_TIME_MS;
select b.d14_14
from decimal_rtf_tbl a
  right semi join decimal_rtf_tiny_tbl b on a.d14_14 = b.d14_14
order by 1
---- RESULTS: VERIFY_IS_EQUAL_SORTED
0.00000000000000
0.00000000000018
0.00000000000019
0.00000000000027
0.00000000000028
0.00000000000029
0.00000000000038
0.00000000000039
0.00000000000049
0.00000000000167
0.00000000000178
0.00000000000222
0.00000000000333
0.00000000000444
0.00000000000555
0.00000000000666
0.00000000000667
0.00000000000777
0.00000000000888
0.00000000000999
0.00000000001111
0.00000000001112
0.00000000005560
0.00000000007789
0.00000000008891
0.00000000009912
0.00000000044500
0.00000000334000
0.00000001100000
0.00000002230000
0.00000091000000
0.00000890000000
0.00006000000000
0.00007800000000
0.00050000000000
0.00400000000000
0.03000000000000
0.20000000000000
---- RUNTIME_PROFILE
aggregation(SUM, ProbeRows): 885
====
---- QUERY
######################################################################
# Test case 6.13: DecimalMinMaxFilters with right semi join - 8 bytes
######################################################################
SET RUNTIME_FILTER_WAIT_TIME_MS=$RUNTIME_FILTER_WAIT_TIME_MS;
select b.d18_0
from decimal_rtf_tbl a
  right semi join decimal_rtf_tiny_tbl b on a.d18_0 = b.d18_0
order by 1
---- RESULTS: VERIFY_IS_EQUAL_SORTED
1
2
3
4
5
6
11
18
19
27
28
29
38
39
49
78
89
91
167
178
222
223
333
334
444
445
555
556
666
667
777
888
999
1111
1112
7789
8891
9912
---- RUNTIME_PROFILE
aggregation(SUM, ProbeRows): 111
====
---- QUERY
######################################################################
# Test case 6.14: DecimalMinMaxFilters with right semi join - 8 bytes
######################################################################
SET RUNTIME_FILTER_WAIT_TIME_MS=$RUNTIME_FILTER_WAIT_TIME_MS;
select b.d18_1
from decimal_rtf_tbl a
  right semi join decimal_rtf_tiny_tbl b on a.d18_1 = b.d18_1
order by 1
---- RESULTS: VERIFY_IS_EQUAL_SORTED
0.2
0.3
0.4
0.5
0.6
1.0
1.1
1.8
1.9
2.7
2.8
2.9
3.8
3.9
4.9
7.8
8.9
9.1
16.7
17.8
22.2
22.3
33.3
33.4
44.4
44.5
55.5
55.6
66.6
66.7
77.7
88.8
99.9
111.1
111.2
778.9
889.1
991.2
---- RUNTIME_PROFILE
aggregation(SUM, ProbeRows): 110
====
---- QUERY
######################################################################
# Test case 6.15: DecimalMinMaxFilters with right semi join - 8 bytes
######################################################################
SET RUNTIME_FILTER_WAIT_TIME_MS=$RUNTIME_FILTER_WAIT_TIME_MS;
select b.d18_9
from decimal_rtf_tbl a
  right semi join decimal_rtf_tiny_tbl b on a.d18_9 = b.d18_9
order by 1
---- RESULTS: VERIFY_IS_EQUAL_SORTED
0.000000011
0.000000018
0.000000019
0.000000027
0.000000028
0.000000029
0.000000038
0.000000039
0.000000049
0.000000167
0.000000178
0.000000222
0.000000223
0.000000333
0.000000334
0.000000444
0.000000445
0.000000555
0.000000556
0.000000666
0.000000667
0.000000777
0.000000888
0.000000910
0.000000999
0.000001111
0.000001112
0.000007789
0.000008891
0.000008900
0.000009912
0.000060000
0.000078000
0.000500000
0.004000000
0.030000000
0.200000000
1.000000000
---- RUNTIME_PROFILE
aggregation(SUM, ProbeRows): 258
====
---- QUERY
######################################################################
# Test case 6.16: DecimalMinMaxFilters with right semi join - 8 bytes
######################################################################
SET RUNTIME_FILTER_WAIT_TIME_MS=$RUNTIME_FILTER_WAIT_TIME_MS;
select b.d18_18
from decimal_rtf_tbl a
  right semi join decimal_rtf_tiny_tbl b on a.d18_18 = b.d18_18
order by 1
---- RESULTS: VERIFY_IS_EQUAL_SORTED
0.000000000000000000
0.000000000000000018
0.000000000000000019
0.000000000000000027
0.000000000000000028
0.000000000000000029
0.000000000000000038
0.000000000000000039
0.000000000000000049
0.000000000000000167
0.000000000000000178
0.000000000000000222
0.000000000000000333
0.000000000000000444
0.000000000000000555
0.000000000000000666
0.000000000000000777
0.000000000000000888
0.000000000000000999
0.000000000000001111
0.000000000000001112
0.000000000000099120
0.000000000000889100
0.000000000006670000
0.000000000007789000
0.000000000055600000
0.000000000445000000
0.000000003340000000
0.000000011000000000
0.000000022300000000
0.000000910000000000
0.000008900000000000
0.000060000000000000
0.000078000000000000
0.000500000000000000
0.004000000000000000
0.030000000000000000
0.200000000000000000
---- RUNTIME_PROFILE
aggregation(SUM, ProbeRows): 1032
====
---- QUERY
#######################################################################
# Test case 6.17: DecimalMinMaxFilters with right semi join - 16 bytes
#######################################################################
SET RUNTIME_FILTER_WAIT_TIME_MS=$RUNTIME_FILTER_WAIT_TIME_MS;
select b.d28_0
from decimal_rtf_tbl a
  right semi join decimal_rtf_tiny_tbl b on a.d28_0 = b.d28_0
order by 1
---- RESULTS: VERIFY_IS_EQUAL_SORTED
1
2
3
4
5
6
11
18
19
27
28
29
38
39
49
78
89
91
167
178
222
223
333
334
444
445
555
556
666
667
777
888
999
1111
1112
7789
8891
9912
---- RUNTIME_PROFILE
aggregation(SUM, ProbeRows): 111
====
---- QUERY
#######################################################################
# Test case 6.18: DecimalMinMaxFilters with right semi join - 16 bytes
#######################################################################
SET RUNTIME_FILTER_WAIT_TIME_MS=$RUNTIME_FILTER_WAIT_TIME_MS;
select b.d28_1
from decimal_rtf_tbl a
  right semi join decimal_rtf_tiny_tbl b on a.d28_1 = b.d28_1
order by 1
---- RESULTS: VERIFY_IS_EQUAL_SORTED
0.2
0.3
0.4
0.5
0.6
1.0
1.1
1.8
1.9
2.7
2.8
2.9
3.8
3.9
4.9
7.8
8.9
9.1
16.7
17.8
22.2
22.3
33.3
33.4
44.4
44.5
55.5
55.6
66.6
66.7
77.7
88.8
99.9
111.1
111.2
778.9
889.1
991.2
---- RUNTIME_PROFILE
aggregation(SUM, ProbeRows): 110
====
---- QUERY
#######################################################################
# Test case 6.19: DecimalMinMaxFilters with right semi join - 16 bytes
#######################################################################
SET RUNTIME_FILTER_WAIT_TIME_MS=$RUNTIME_FILTER_WAIT_TIME_MS;
select b.d28_14
from decimal_rtf_tbl a
  right semi join decimal_rtf_tiny_tbl b on a.d28_14 = b.d28_14
order by 1
---- RESULTS: VERIFY_IS_EQUAL_SORTED
0.00000000000018
0.00000000000019
0.00000000000027
0.00000000000028
0.00000000000029
0.00000000000038
0.00000000000039
0.00000000000049
0.00000000000167
0.00000000000178
0.00000000000222
0.00000000000333
0.00000000000444
0.00000000000555
0.00000000000666
0.00000000000667
0.00000000000777
0.00000000000888
0.00000000000999
0.00000000001111
0.00000000001112
0.00000000005560
0.00000000007789
0.00000000008891
0.00000000009912
0.00000000044500
0.00000000334000
0.00000001100000
0.00000002230000
0.00000091000000
0.00000890000000
0.00006000000000
0.00007800000000
0.00050000000000
0.00400000000000
0.03000000000000
0.20000000000000
1.00000000000000
---- RUNTIME_PROFILE
aggregation(SUM, ProbeRows): 386
====
---- QUERY
#######################################################################
# Test case 6.20: DecimalMinMaxFilters with right semi join - 16 bytes
#######################################################################
SET RUNTIME_FILTER_WAIT_TIME_MS=$RUNTIME_FILTER_WAIT_TIME_MS;
select b.d28_28
from decimal_rtf_tbl a
  right semi join decimal_rtf_tiny_tbl b on a.d28_28 = b.d28_28
order by 1
---- RESULTS: VERIFY_IS_EQUAL_SORTED
0.0000000000000000000000000000
0.0000000000000000000000000018
0.0000000000000000000000000019
0.0000000000000000000000000027
0.0000000000000000000000000028
0.0000000000000000000000000029
0.0000000000000000000000000038
0.0000000000000000000000000039
0.0000000000000000000000000049
0.0000000000000000000000000178
0.0000000000000000000000001111
0.0000000000000000000000001670
0.0000000000000000000000099900
0.0000000000000000000000888000
0.0000000000000000000007770000
0.0000000000000000000066600000
0.0000000000000000000555000000
0.0000000000000000004440000000
0.0000000000000000033300000000
0.0000000000000000222000000000
0.0000000000000011120000000000
0.0000000000000991200000000000
0.0000000000008891000000000000
0.0000000000066700000000000000
0.0000000000077890000000000000
0.0000000000556000000000000000
0.0000000004450000000000000000
0.0000000033400000000000000000
0.0000000110000000000000000000
0.0000000223000000000000000000
0.0000009100000000000000000000
0.0000089000000000000000000000
0.0000600000000000000000000000
0.0000780000000000000000000000
0.0005000000000000000000000000
0.0040000000000000000000000000
0.0300000000000000000000000000
0.2000000000000000000000000000
---- RUNTIME_PROFILE
aggregation(SUM, ProbeRows): 1306
====
---- QUERY
#######################################################################
# Test case 6.21: DecimalMinMaxFilters with right semi join - 16 bytes
#######################################################################
SET RUNTIME_FILTER_WAIT_TIME_MS=$RUNTIME_FILTER_WAIT_TIME_MS;
select b.d38_0
from decimal_rtf_tbl a
  right semi join decimal_rtf_tiny_tbl b on a.d38_0 = b.d38_0
order by 1
---- RESULTS: VERIFY_IS_EQUAL_SORTED
1
2
3
4
5
6
11
18
19
27
28
29
38
39
49
78
89
91
167
178
222
223
333
334
444
445
555
556
666
667
777
888
999
1111
1112
7789
8891
9912
---- RUNTIME_PROFILE
aggregation(SUM, ProbeRows): 111
====
---- QUERY
#######################################################################
# Test case 6.22: DecimalMinMaxFilters with right semi join - 16 bytes
#######################################################################
SET RUNTIME_FILTER_WAIT_TIME_MS=$RUNTIME_FILTER_WAIT_TIME_MS;
select b.d38_1
from decimal_rtf_tbl a
  right semi join decimal_rtf_tiny_tbl b on a.d38_1 = b.d38_1
order by 1
---- RESULTS: VERIFY_IS_EQUAL_SORTED
0.2
0.3
0.4
0.5
0.6
1.0
1.1
1.8
1.9
2.7
2.8
2.9
3.8
3.9
4.9
7.8
8.9
9.1
16.7
17.8
22.2
22.3
33.3
33.4
44.4
44.5
55.5
55.6
66.6
66.7
77.7
88.8
99.9
111.1
111.2
778.9
889.1
991.2
---- RUNTIME_PROFILE
aggregation(SUM, ProbeRows): 110
====
---- QUERY
#######################################################################
# Test case 6.23: DecimalMinMaxFilters with right semi join - 16 bytes
#######################################################################
SET RUNTIME_FILTER_WAIT_TIME_MS=$RUNTIME_FILTER_WAIT_TIME_MS;
select b.d38_19
from decimal_rtf_tbl a
  right semi join decimal_rtf_tiny_tbl b on a.d38_19 = b.d38_19
order by 1
---- RESULTS: VERIFY_IS_EQUAL_SORTED
0.0000000000000000018
0.0000000000000000019
0.0000000000000000027
0.0000000000000000028
0.0000000000000000029
0.0000000000000000038
0.0000000000000000039
0.0000000000000000049
0.0000000000000000167
0.0000000000000000178
0.0000000000000000222
0.0000000000000000333
0.0000000000000000444
0.0000000000000000555
0.0000000000000000666
0.0000000000000000777
0.0000000000000000888
0.0000000000000000999
0.0000000000000001111
0.0000000000000011120
0.0000000000000991200
0.0000000000008891000
0.0000000000066700000
0.0000000000077890000
0.0000000000556000000
0.0000000004450000000
0.0000000033400000000
0.0000000110000000000
0.0000000223000000000
0.0000009100000000000
0.0000089000000000000
0.0000600000000000000
0.0000780000000000000
0.0005000000000000000
0.0040000000000000000
0.0300000000000000000
0.2000000000000000000
1.0000000000000000000
---- RUNTIME_PROFILE
aggregation(SUM, ProbeRows): 491
====
---- QUERY
#######################################################################
# Test case 6.24: DecimalMinMaxFilters with right semi join - 16 bytes
#######################################################################
SET RUNTIME_FILTER_WAIT_TIME_MS=$RUNTIME_FILTER_WAIT_TIME_MS;
select b.d38_38
from decimal_rtf_tbl a
  right semi join decimal_rtf_tiny_tbl b on a.d38_38 = b.d38_38
order by 1
---- RESULTS: VERIFY_IS_EQUAL_SORTED
0.00000000000000000000000000000000000000
0.00000000000000000000000000000000000490
0.00000000000000000000000000000000001111
0.00000000000000000000000000000000003900
0.00000000000000000000000000000000038000
0.00000000000000000000000000000000290000
0.00000000000000000000000000000002800000
0.00000000000000000000000000000027000000
0.00000000000000000000000000000190000000
0.00000000000000000000000000001800000000
0.00000000000000000000000001780000000000
0.00000000000000000000000016700000000000
0.00000000000000000000000999000000000000
0.00000000000000000000008880000000000000
0.00000000000000000000077700000000000000
0.00000000000000000000666000000000000000
0.00000000000000000005550000000000000000
0.00000000000000000044400000000000000000
0.00000000000000000333000000000000000000
0.00000000000000002220000000000000000000
0.00000000000000111200000000000000000000
0.00000000000009912000000000000000000000
0.00000000000088910000000000000000000000
0.00000000000667000000000000000000000000
0.00000000000778900000000000000000000000
0.00000000005560000000000000000000000000
0.00000000044500000000000000000000000000
0.00000000334000000000000000000000000000
0.00000001100000000000000000000000000000
0.00000002230000000000000000000000000000
0.00000091000000000000000000000000000000
0.00000890000000000000000000000000000000
0.00006000000000000000000000000000000000
0.00007800000000000000000000000000000000
0.00050000000000000000000000000000000000
0.00400000000000000000000000000000000000
0.03000000000000000000000000000000000000
0.20000000000000000000000000000000000000
---- RUNTIME_PROFILE
aggregation(SUM, ProbeRows): 1375
====