| ==== |
| ---- 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 |
| ==== |
