You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@impala.apache.org by jo...@apache.org on 2019/01/10 21:19:58 UTC
[06/10] impala git commit: IMPALA-6533: Add min-max filter for
decimal types on kudu tables.
http://git-wip-us.apache.org/repos/asf/impala/blob/aacd5c35/testdata/workloads/functional-query/queries/QueryTest/decimal_min_max_filters.test
----------------------------------------------------------------------
diff --git a/testdata/workloads/functional-query/queries/QueryTest/decimal_min_max_filters.test b/testdata/workloads/functional-query/queries/QueryTest/decimal_min_max_filters.test
new file mode 100644
index 0000000..39001c0
--- /dev/null
+++ b/testdata/workloads/functional-query/queries/QueryTest/decimal_min_max_filters.test
@@ -0,0 +1,4937 @@
+====
+---- 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=30000;
+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=30000;
+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=30000;
+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=30000;
+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=30000;
+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=30000;
+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=30000;
+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=30000;
+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=30000;
+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=30000;
+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=30000;
+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=30000;
+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=30000;
+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=30000;
+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=30000;
+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=30000;
+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=30000;
+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=30000;
+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=30000;
+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=30000;
+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=30000;
+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=30000;
+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=30000;
+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=30000;
+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=30000;
+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=30000;
+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=30000;
+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=30000;
+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=30000;
+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=30000;
+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=30000;
+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=30000;
+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=30000;
+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=30000;
+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=30000;
+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=30000;
+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=30000;
+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=30000;
+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=30000;
+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=30000;
+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=30000;
+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=30000;
+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=30000;
+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=30000;
+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=30000;
+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=30000;
+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=30000;
+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=30000;
+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=30000;
+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=30000;
+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=30000;
+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=30000;
+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=30000;
+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=30000;
+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=30000;
+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=30000;
+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=30000;
+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=30000;
+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=30000;
+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=30000;
+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=30000;
+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=30000;
+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=30000;
+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=30000;
+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=30000;
+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=30000;
+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=30000;
+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=30000;
+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=30000;
+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=30000;
+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=30000;
+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=30000;
+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=30000;
+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=30000;
+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=30000;
+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=30000;
+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=30000;
+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=30000;
+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=30000;
+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=30000;
+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=30000;
+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=30000;
+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=30000;
+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=30000;
+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=30000;
+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=30000;
+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=30000;
+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=30000;
+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=30000;
+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=30000;
+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=30000;
+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=30000;
+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=30000;
+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=30000;
+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=30000;
+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=30000;
+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=30000;
+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=30000;
+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
<TRUNCATED>