Changeset: f2d75847fc86 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=f2d75847fc86 Modified Files: sql/test/analytics/Tests/analytics13.stable.out Branch: default Log Message:
Merge with linear-hashing diffs (272 lines): diff --git a/sql/test/analytics/Tests/analytics13.stable.out b/sql/test/analytics/Tests/analytics13.stable.out --- a/sql/test/analytics/Tests/analytics13.stable.out +++ b/sql/test/analytics/Tests/analytics13.stable.out @@ -123,7 +123,7 @@ stdout of test 'analytics13` in director # col3 > ALL (SELECT 1 FROM tbl_ProductSales HAVING MIN(col4) > 30) #FROM another_T #GROUP BY ROLLUP(col3, col4); -% .%30 # table_name +% . # table_name % %30 # name % boolean # type % 5 # length @@ -140,7 +140,7 @@ stdout of test 'analytics13` in director # col1 = ALL (SELECT 1 FROM tbl_ProductSales HAVING MIN(col2) IS NULL) #FROM another_T #GROUP BY CUBE(col1, col2); -% .%27 # table_name +% . # table_name % %27 # name % boolean # type % 5 # length @@ -174,7 +174,7 @@ stdout of test 'analytics13` in director # CASE WHEN NOT col1 NOT IN (SELECT (SELECT MAX(col7)) UNION (SELECT MIN(ColID) FROM tbl_ProductSales LEFT JOIN another_T t2 ON t2.col5 = t2.col1)) THEN 1 ELSE 2 END #FROM another_T t1 #GROUP BY col1; -% .%61 # table_name +% . # table_name % %61 # name % tinyint # type % 1 # length @@ -224,7 +224,7 @@ stdout of test 'analytics13` in director # GROUPING(t1.col6) = ALL (SELECT GROUPING(t1.col7) FROM tbl_ProductSales) #FROM another_T t1 #GROUP BY CUBE(t1.col6, t1.col7); -% .%317, .%45, .%321, .%322, .%323, .%324, .%325 # table_name +% ., .%45, ., ., ., ., . # table_name % %317, %45, %321, %322, %323, %324, %325 # name % boolean, boolean, boolean, boolean, boolean, boolean, boolean # type % 5, 5, 5, 5, 5, 5, 5 # length @@ -251,7 +251,7 @@ stdout of test 'analytics13` in director # GROUPING(t1.col6) = ALL (SELECT GROUPING(t1.col7)), # GROUPING(t1.col6) = ALL (SELECT GROUPING(t1.col7) FROM tbl_ProductSales) #FROM another_T t1 -% .%317, .%45, .%321, .%322, .%323, .%324, .%325 # table_name +% ., .%45, ., ., ., ., . # table_name % %317, %45, %321, %322, %323, %324, %325 # name % boolean, boolean, boolean, boolean, boolean, boolean, boolean # type % 5, 5, 5, 5, 5, 5, 5 # length @@ -265,8 +265,8 @@ stdout of test 'analytics13` in director # NOT EXISTS (SELECT ColID - 12 FROM tbl_ProductSales GROUP BY ColID HAVING MAX(col1) IS NOT NULL OR MIN(col1) < MIN(col2)), # CAST (NOT col1 IN (SELECT col2 FROM another_T GROUP BY col2) AS INTEGER) | CAST (col2 IN (SELECT col2 FROM another_T GROUP BY col2) AS INTEGER), # CAST (EXISTS (SELECT MAX(col5) * MAX(col4) FROM another_T GROUP BY col5, col4) AS INTEGER) & CAST (GROUPING(col1, col5) IN (SELECT DISTINCT col2 FROM another_T GROUP BY col2) AS INTEGER) -% .%210, .%211, .%212, .%213, .%214 # table_name -% %210, %211, %212, %213, %214 # name +% ., ., ., ., . # table_name +% %216, %217, %220, %221, %222 # name % boolean, boolean, boolean, int, int # type % 5, 5, 5, 1, 1 # length [ true, true, false, 1, 0 ] @@ -343,8 +343,8 @@ stdout of test 'analytics13` in director #FROM another_T #GROUP BY ROLLUP(col1, col2, col3, col4, col5, col6, col7, col8) --with 8 columns, a smallint is necessary for grouping's output #ORDER BY GROUPING(col1, col2, col3, col4, col5, col6, col7, col8); -% .%1, .%2, .%4, .%13, .%7, .another_t, .%14, .%15 # table_name -% %1, %2, %4, %13, %7, col7, %14, %15 # name +% .%1, .%2, .%11, .%12, .%13, .another_t, .%14, .%15 # table_name +% %1, %2, %11, %12, %13, col7, %14, %15 # name % smallint, double, bigint, bigint, bigint, int, boolean, boolean # type % 3, 24, 4, 4, 8, 4, 5, 5 # length [ 0, 1, 6, 7, 30, 7, true, false ] @@ -385,7 +385,7 @@ stdout of test 'analytics13` in director # NOT col1 IN (SELECT col2 FROM another_T GROUP BY col2) #FROM another_T #GROUP BY ROLLUP(col1); -% .%14 # table_name +% . # table_name % %14 # name % boolean # type % 5 # length @@ -467,8 +467,8 @@ stdout of test 'analytics13` in director # NOT EXISTS (SELECT ColID - 12 FROM tbl_ProductSales GROUP BY ColID HAVING MAX(col1) IS NOT NULL OR MIN(col1) < MIN(col2)), # CAST (NOT col1 IN (SELECT col2 FROM another_T GROUP BY col2) AS INTEGER) | CAST (col2 IN (SELECT col2 FROM another_T GROUP BY col2) AS INTEGER), # CAST (EXISTS (SELECT MAX(col5) * MAX(col4) FROM another_T GROUP BY col5, col4) AS INTEGER) & CAST (GROUPING(col1, col5) IN (SELECT DISTINCT col2 FROM another_T GROUP BY col2) AS INTEGER) -% .%210, .%211, .%212, .%213, .%214 # table_name -% %210, %211, %212, %213, %214 # name +% ., ., ., ., . # table_name +% %216, %217, %220, %221, %222 # name % boolean, boolean, boolean, int, int # type % 5, 5, 5, 1, 1 # length [ true, true, false, 1, 0 ] @@ -506,71 +506,71 @@ stdout of test 'analytics13` in director # col5 = ALL (SELECT 1 FROM tbl_ProductSales HAVING MIN(col8) IS NULL) a5, # EXISTS (SELECT col2 FROM tbl_ProductSales WHERE tbl_ProductSales.ColID = another_T.col1) a6, # col1 + col5 = (SELECT MIN(ColID) FROM tbl_ProductSales) a7, -% .%1, .%62, ., ., ., ., ., .%13, ., ., ., ., ., . # table_name +% ., ., ., ., ., ., ., ., ., ., ., ., ., . # table_name % a1, a2, a3, a4, a5, a6, a7, a8, a9, a10, a11, a12, a13, a14 # name % tinyint, boolean, boolean, int, boolean, boolean, boolean, bigint, bigint, bigint, bigint, varchar, int, bigint # type -% 2, 5, 5, 4, 5, 5, 5, 4, 4, 5, 3, 32, 3, 1 # length -[ 0, false, true, 5555, true, false, false, 1111, 2226, 0, 333, "4444 plus 0", 111, NULL ] -[ 0, false, true, NULL, true, true, false, 1, 6, 0, 0, "4 plus 0", 111, NULL ] -[ 0, false, true, NULL, true, false, false, 11, 26, 0, 3, "44 plus 0", 111, NULL ] -[ 0, false, true, NULL, true, false, false, 111, 226, 0, 33, "444 plus 0", 111, NULL ] -[ 1, false, true, 5555, true, false, false, 1111, 2226, 8888, 333, "4444 plus 0", 111, NULL ] -[ 1, false, true, NULL, true, true, false, 1, 6, 8, 0, "4 plus 0", 111, NULL ] -[ 1, false, true, NULL, true, false, false, 11, 26, 88, 3, "44 plus 0", 111, NULL ] -[ 1, false, true, NULL, true, false, false, 111, 226, 888, 33, "444 plus 0", 111, NULL ] -[ 2, false, true, 5555, true, false, NULL, 1111, 2226, 16, 353, "4444 plus 0", 111, NULL ] -[ 2, false, true, NULL, true, true, NULL, 1, 6, 16, 20, "4 plus 0", 111, NULL ] -[ 2, false, true, NULL, true, false, NULL, 11, 26, 16, 23, "44 plus 0", 111, NULL ] -[ 2, false, true, NULL, true, false, NULL, 111, 226, 16, 53, "444 plus 0", 111, NULL ] -[ 3, false, true, 5555, true, false, NULL, 1111, 2226, 24, 353, "4444 plus 0", 111, NULL ] -[ 3, false, true, NULL, true, true, NULL, 1, 6, 24, 20, "4 plus 0", 111, NULL ] -[ 3, false, true, NULL, true, false, NULL, 11, 26, 24, 23, "44 plus 0", 111, NULL ] -[ 3, false, true, NULL, true, false, NULL, 111, 226, 24, 53, "444 plus 0", 111, NULL ] -[ 4, NULL, NULL, 5555, true, false, false, 1111, NULL, 0, 343, "4444 plus 0", 111, NULL ] -[ 4, NULL, NULL, NULL, true, true, false, 1, NULL, 0, 10, "4 plus 0", 111, NULL ] -[ 4, NULL, NULL, NULL, true, false, false, 11, NULL, 0, 13, "44 plus 0", 111, NULL ] -[ 4, NULL, NULL, NULL, true, false, false, 111, NULL, 0, 43, "444 plus 0", 111, NULL ] -[ 5, NULL, NULL, 5555, true, false, false, 1111, NULL, 8888, 343, "4444 plus 0", 111, NULL ] -[ 5, NULL, NULL, NULL, true, true, false, 1, NULL, 8, 10, "4 plus 0", 111, NULL ] -[ 5, NULL, NULL, NULL, true, false, false, 11, NULL, 88, 13, "44 plus 0", 111, NULL ] -[ 5, NULL, NULL, NULL, true, false, false, 111, NULL, 888, 43, "444 plus 0", 111, NULL ] -[ 6, NULL, NULL, 5555, true, false, NULL, 1111, NULL, 16, 363, "4444 plus 0", 111, NULL ] -[ 6, NULL, NULL, NULL, true, true, NULL, 1, NULL, 16, 30, "4 plus 0", 111, NULL ] -[ 6, NULL, NULL, NULL, true, false, NULL, 11, NULL, 16, 33, "44 plus 0", 111, NULL ] -[ 6, NULL, NULL, NULL, true, false, NULL, 111, NULL, 16, 63, "444 plus 0", 111, NULL ] -[ 7, NULL, NULL, 5555, true, false, NULL, 1111, NULL, 24, 363, "4444 plus 0", 111, NULL ] -[ 7, NULL, NULL, NULL, true, true, NULL, 1, NULL, 24, 30, "4 plus 0", 111, NULL ] -[ 7, NULL, NULL, NULL, true, false, NULL, 11, NULL, 24, 33, "44 plus 0", 111, NULL ] -[ 7, NULL, NULL, NULL, true, false, NULL, 111, NULL, 24, 63, "444 plus 0", 111, NULL ] -[ 8, NULL, NULL, 5555, true, false, NULL, 1111, 2226, 35552, 373, "4444 plus 1", 111, NULL ] -[ 8, NULL, NULL, NULL, true, false, NULL, 1, 6, 32, 40, "4 plus 1", 111, NULL ] -[ 8, NULL, NULL, NULL, true, false, NULL, 11, 26, 352, 43, "44 plus 1", 111, NULL ] -[ 8, NULL, NULL, NULL, true, false, NULL, 111, 226, 3552, 73, "444 plus 1", 111, NULL ] -[ 9, NULL, NULL, 5555, true, false, NULL, 1111, 2226, 44440, 373, "4444 plus 1", 111, NULL ] -[ 9, NULL, NULL, NULL, true, false, NULL, 1, 6, 40, 40, "4 plus 1", 111, NULL ] -[ 9, NULL, NULL, NULL, true, false, NULL, 11, 26, 440, 43, "44 plus 1", 111, NULL ] -[ 9, NULL, NULL, NULL, true, false, NULL, 111, 226, 4440, 73, "444 plus 1", 111, NULL ] -[ 10, NULL, NULL, 5555, true, false, NULL, 1111, 2226, 48, 393, "4444 plus 1", 111, NULL ] -[ 10, NULL, NULL, NULL, true, false, NULL, 1, 6, 48, 60, "4 plus 1", 111, NULL ] -[ 10, NULL, NULL, NULL, true, false, NULL, 11, 26, 48, 63, "44 plus 1", 111, NULL ] -[ 10, NULL, NULL, NULL, true, false, NULL, 111, 226, 48, 93, "444 plus 1", 111, NULL ] -[ 11, NULL, NULL, 5555, true, false, NULL, 1111, 2226, 56, 393, "4444 plus 1", 111, NULL ] -[ 11, NULL, NULL, NULL, true, false, NULL, 1, 6, 56, 60, "4 plus 1", 111, NULL ] -[ 11, NULL, NULL, NULL, true, false, NULL, 11, 26, 56, 63, "44 plus 1", 111, NULL ] -[ 11, NULL, NULL, NULL, true, false, NULL, 111, 226, 56, 93, "444 plus 1", 111, NULL ] -[ 12, NULL, NULL, 5555, true, false, NULL, 1111, NULL, 35552, 383, "4444 plus 1", 111, NULL ] -[ 12, NULL, NULL, NULL, true, false, NULL, 1, NULL, 32, 50, "4 plus 1", 111, NULL ] -[ 12, NULL, NULL, NULL, true, false, NULL, 11, NULL, 352, 53, "44 plus 1", 111, NULL ] -[ 12, NULL, NULL, NULL, true, false, NULL, 111, NULL, 3552, 83, "444 plus 1", 111, NULL ] -[ 13, NULL, NULL, 5555, true, false, NULL, 1111, NULL, 44440, 383, "4444 plus 1", 111, NULL ] -[ 13, NULL, NULL, NULL, true, false, NULL, 1, NULL, 40, 50, "4 plus 1", 111, NULL ] -[ 13, NULL, NULL, NULL, true, false, NULL, 11, NULL, 440, 53, "44 plus 1", 111, NULL ] -[ 13, NULL, NULL, NULL, true, false, NULL, 111, NULL, 4440, 83, "444 plus 1", 111, NULL ] -[ 14, NULL, NULL, 5555, true, false, NULL, 1111, NULL, 48, 403, "4444 plus 1", 111, NULL ] -[ 14, NULL, NULL, NULL, true, false, NULL, 1, NULL, 48, 70, "4 plus 1", 111, NULL ] -[ 14, NULL, NULL, NULL, true, false, NULL, 11, NULL, 48, 73, "44 plus 1", 111, NULL ] -[ 14, NULL, NULL, NULL, true, false, NULL, 111, NULL, 48, 103, "444 plus 1", 111, NULL ] -[ 15, NULL, NULL, NULL, true, false, NULL, 1234, NULL, 56, 403, "4-sep-44-sep-444-sep-4444 plus 1", 111, NULL ] +% 2, 5, 5, 4, 5, 5, 5, 4, 4, 5, 3, 32, 1, 1 # length +[ 0, false, true, 5555, true, false, false, 1111, 2226, 0, 333, "4444 plus 0", 1, NULL ] +[ 0, false, true, NULL, true, true, false, 1, 6, 0, 0, "4 plus 0", 1, NULL ] +[ 0, false, true, NULL, true, false, false, 11, 26, 0, 3, "44 plus 0", 1, NULL ] +[ 0, false, true, NULL, true, false, false, 111, 226, 0, 33, "444 plus 0", 1, NULL ] +[ 1, false, true, 5555, true, false, false, 1111, 2226, 8888, 333, "4444 plus 0", 1, NULL ] +[ 1, false, true, NULL, true, true, false, 1, 6, NULL, 0, "4 plus 0", 1, NULL ] +[ 1, false, true, NULL, true, false, false, 11, 26, NULL, 3, "44 plus 0", 1, NULL ] +[ 1, false, true, NULL, true, false, false, 111, 226, 888, 33, "444 plus 0", 1, NULL ] +[ 2, false, true, 5555, true, false, NULL, 1111, 2226, 16, 353, "4444 plus 0", 1, NULL ] +[ 2, false, true, NULL, true, true, NULL, 1, 6, 16, 20, "4 plus 0", 1, NULL ] +[ 2, false, true, NULL, true, false, NULL, 11, 26, 16, 23, "44 plus 0", 1, NULL ] +[ 2, false, true, NULL, true, false, NULL, 111, 226, 16, 53, "444 plus 0", 1, NULL ] +[ 3, false, true, 5555, true, false, NULL, 1111, 2226, 24, 353, "4444 plus 0", 1, NULL ] +[ 3, false, true, NULL, true, true, NULL, 1, 6, 24, 20, "4 plus 0", 1, NULL ] +[ 3, false, true, NULL, true, false, NULL, 11, 26, 24, 23, "44 plus 0", 1, NULL ] +[ 3, false, true, NULL, true, false, NULL, 111, 226, 24, 53, "444 plus 0", 1, NULL ] +[ 4, NULL, NULL, 5555, true, false, false, 1111, NULL, 0, 343, "4444 plus 0", 1, NULL ] +[ 4, NULL, NULL, NULL, true, true, false, 1, NULL, 0, 10, "4 plus 0", 1, NULL ] +[ 4, NULL, NULL, NULL, true, false, false, 11, NULL, 0, 13, "44 plus 0", 1, NULL ] +[ 4, NULL, NULL, NULL, true, false, false, 111, NULL, 0, 43, "444 plus 0", 1, NULL ] +[ 5, NULL, NULL, 5555, true, false, false, 1111, NULL, 8888, 343, "4444 plus 0", 1, NULL ] +[ 5, NULL, NULL, NULL, true, true, false, 1, NULL, NULL, 10, "4 plus 0", 1, NULL ] +[ 5, NULL, NULL, NULL, true, false, false, 11, NULL, 88, 13, "44 plus 0", 1, NULL ] +[ 5, NULL, NULL, NULL, true, false, false, 111, NULL, 888, 43, "444 plus 0", 1, NULL ] +[ 6, NULL, NULL, 5555, true, false, NULL, 1111, NULL, 16, 363, "4444 plus 0", 1, NULL ] +[ 6, NULL, NULL, NULL, true, true, NULL, 1, NULL, 16, 30, "4 plus 0", 1, NULL ] +[ 6, NULL, NULL, NULL, true, false, NULL, 11, NULL, 16, 33, "44 plus 0", 1, NULL ] +[ 6, NULL, NULL, NULL, true, false, NULL, 111, NULL, 16, 63, "444 plus 0", 1, NULL ] +[ 7, NULL, NULL, 5555, true, false, NULL, 1111, NULL, 24, 363, "4444 plus 0", 1, NULL ] +[ 7, NULL, NULL, NULL, true, true, NULL, 1, NULL, 24, 30, "4 plus 0", 1, NULL ] +[ 7, NULL, NULL, NULL, true, false, NULL, 11, NULL, 24, 33, "44 plus 0", 1, NULL ] +[ 7, NULL, NULL, NULL, true, false, NULL, 111, NULL, 24, 63, "444 plus 0", 1, NULL ] +[ 8, NULL, NULL, 5555, true, false, NULL, 1111, 2226, 35552, 373, "4444 plus 1", 1, NULL ] +[ 8, NULL, NULL, NULL, true, false, NULL, 1, 6, 32, 40, "4 plus 1", 1, NULL ] +[ 8, NULL, NULL, NULL, true, false, NULL, 11, 26, 352, 43, "44 plus 1", 1, NULL ] +[ 8, NULL, NULL, NULL, true, false, NULL, 111, 226, 3552, 73, "444 plus 1", 1, NULL ] +[ 9, NULL, NULL, 5555, true, false, NULL, 1111, 2226, 44440, 373, "4444 plus 1", 1, NULL ] +[ 9, NULL, NULL, NULL, true, false, NULL, 1, 6, 40, 40, "4 plus 1", 1, NULL ] +[ 9, NULL, NULL, NULL, true, false, NULL, 11, 26, 440, 43, "44 plus 1", 1, NULL ] +[ 9, NULL, NULL, NULL, true, false, NULL, 111, 226, 4440, 73, "444 plus 1", 1, NULL ] +[ 10, NULL, NULL, 5555, true, false, NULL, 1111, 2226, 48, 393, "4444 plus 1", 1, NULL ] +[ 10, NULL, NULL, NULL, true, false, NULL, 1, 6, 48, 60, "4 plus 1", 1, NULL ] +[ 10, NULL, NULL, NULL, true, false, NULL, 11, 26, 48, 63, "44 plus 1", 1, NULL ] +[ 10, NULL, NULL, NULL, true, false, NULL, 111, 226, 48, 93, "444 plus 1", 1, NULL ] +[ 11, NULL, NULL, 5555, true, false, NULL, 1111, 2226, 56, 393, "4444 plus 1", 1, NULL ] +[ 11, NULL, NULL, NULL, true, false, NULL, 1, 6, 56, 60, "4 plus 1", 1, NULL ] +[ 11, NULL, NULL, NULL, true, false, NULL, 11, 26, 56, 63, "44 plus 1", 1, NULL ] +[ 11, NULL, NULL, NULL, true, false, NULL, 111, 226, 56, 93, "444 plus 1", 1, NULL ] +[ 12, NULL, NULL, 5555, true, false, NULL, 1111, NULL, 35552, 383, "4444 plus 1", 1, NULL ] +[ 12, NULL, NULL, NULL, true, false, NULL, 1, NULL, 32, 50, "4 plus 1", 1, NULL ] +[ 12, NULL, NULL, NULL, true, false, NULL, 11, NULL, 352, 53, "44 plus 1", 1, NULL ] +[ 12, NULL, NULL, NULL, true, false, NULL, 111, NULL, 3552, 83, "444 plus 1", 1, NULL ] +[ 13, NULL, NULL, 5555, true, false, NULL, 1111, NULL, 44440, 383, "4444 plus 1", 1, NULL ] +[ 13, NULL, NULL, NULL, true, false, NULL, 1, NULL, 40, 50, "4 plus 1", 1, NULL ] +[ 13, NULL, NULL, NULL, true, false, NULL, 11, NULL, 440, 53, "44 plus 1", 1, NULL ] +[ 13, NULL, NULL, NULL, true, false, NULL, 111, NULL, 4440, 83, "444 plus 1", 1, NULL ] +[ 14, NULL, NULL, 5555, true, false, NULL, 1111, NULL, 48, 403, "4444 plus 1", 1, NULL ] +[ 14, NULL, NULL, NULL, true, false, NULL, 1, NULL, 48, 70, "4 plus 1", 1, NULL ] +[ 14, NULL, NULL, NULL, true, false, NULL, 11, NULL, 48, 73, "44 plus 1", 1, NULL ] +[ 14, NULL, NULL, NULL, true, false, NULL, 111, NULL, 48, 103, "444 plus 1", 1, NULL ] +[ 15, NULL, NULL, NULL, true, false, NULL, 1234, NULL, 56, 403, "4-sep-44-sep-444-sep-4444 plus 1", 1, NULL ] #SELECT # CAST((SELECT tp2.proj * t1.col1 + MAX(t1.col5) FROM LATERAL (SELECT MAX(tp.ColID) + MIN(t1.col6) - t1.col1 as proj FROM tbl_ProductSales tp HAVING NULL IS NOT NULL) AS tp2) AS BIGINT) AS a1 #FROM another_T t1 @@ -610,7 +610,7 @@ stdout of test 'analytics13` in director #HAVING (t1.col1 = ANY (SELECT MAX(ColID + col2) FROM tbl_ProductSales)) NOT IN # ((SELECT NOT EXISTS (SELECT t1.col2 FROM tbl_ProductSales WHERE tbl_ProductSales.ColID = t1.col1)) UNION ALL # (SELECT NOT GROUPING(t1.col1) BETWEEN (SELECT MAX(t1.col7) EXCEPT SELECT tp.ColID FROM tbl_ProductSales tp) AND (SELECT MIN(t1.col5) EXCEPT SELECT t1.col2))) -% .%42 # table_name +% . # table_name % a1 # name % boolean # type % 5 # length @@ -623,7 +623,7 @@ stdout of test 'analytics13` in director # GROUPING(t1.col6, t1.col7) NOT IN (SELECT MIN(t2.col2) FROM another_T t2 GROUP BY t1.col6), # NOT SUM(t1.col2) * GROUPING(t1.col6, t1.col6, t1.col6, t1.col6) NOT IN (SELECT MAX(t2.col6) FROM another_T t2 GROUP BY t1.col6 HAVING t1.col7 + MIN(t2.col8) < MAX(t2.col7 - t1.col6)), # GROUPING(t1.col6) <> ANY (SELECT t1.col7 INTERSECT SELECT t1.col6), -% .%43, .%374, .%65, .%77, .%377, .%400 # table_name +% .%43, ., .%65, .%77, ., . # table_name % %43, %374, %65, %77, %377, %400 # name % boolean, boolean, boolean, boolean, boolean, boolean # type % 5, 5, 5, 5, 5, 5 # length @@ -646,7 +646,7 @@ stdout of test 'analytics13` in director # CASE WHEN t1.col2 IN (SELECT MAX(MAX(t1.col3)) OVER (PARTITION BY t1.col2 ORDER BY tp.ColID) FROM tbl_ProductSales tp LEFT JOIN another_T t2 ON tp.ColID = t1.col1) THEN 1 ELSE 2 END #FROM another_T t1 #GROUP BY ROLLUP(t1.col1, t1.col2); -% .%134, .%135, .%136 # table_name +% ., ., . # table_name % %134, %135, %136 # name % tinyint, tinyint, tinyint # type % 1, 1, 1 # length @@ -664,8 +664,8 @@ stdout of test 'analytics13` in director # CASE WHEN t1.col2 IN (SELECT MIN(ColID) FROM tbl_ProductSales tp LEFT JOIN another_T t2 ON tp.ColID = t1.col1 AND tp.ColID = t2.col2) THEN 1 ELSE 2 END, # CASE WHEN t1.col2 IN (SELECT MIN(ColID) FROM tbl_ProductSales tp RIGHT JOIN another_T t2 ON tp.ColID = t1.col1 AND tp.ColID = t2.col2) THEN 1 ELSE 2 END, # CASE WHEN t1.col2 IN (SELECT MIN(ColID) FROM tbl_ProductSales tp FULL OUTER JOIN another_T t2 ON tp.ColID = t1.col1 AND tp.ColID = t2.col2) THEN 1 ELSE 2 END -% .%202, .%203, .%204, .%205 # table_name -% %202, %203, %204, %205 # name +% ., ., ., . # table_name +% %223, %224, %225, %226 # name % tinyint, tinyint, tinyint, tinyint # type % 1, 1, 1, 1 # length [ 2, 2, 2, 2 ] @@ -681,7 +681,7 @@ stdout of test 'analytics13` in director # CASE WHEN NOT t1.col2 NOT IN (SELECT (SELECT MAX(t1.col7)) UNION (SELECT MIN(ColID) FROM tbl_ProductSales LEFT JOIN another_T t2 ON t2.col5 = t1.col1)) THEN 1 ELSE 2 END, # CASE WHEN NOT t1.col2 NOT IN (SELECT (SELECT MAX(t1.col7)) UNION (SELECT MIN(ColID) FROM tbl_ProductSales LEFT JOIN another_T t2 ON MIN(t1.col5) = t1.col1)) THEN 1 ELSE 2 END, # CASE WHEN NOT t1.col2 NOT IN (SELECT (SELECT MAX(t1.col7)) UNION (SELECT MIN(ColID) FROM tbl_ProductSales tp LEFT JOIN another_T t2 ON tp.ColID = t1.col1 AND tp.ColID = t2.col2)) THEN 1 ELSE 2 END -% .%365, .%366, .%367 # table_name +% ., ., . # table_name % %365, %366, %367 # name % tinyint, tinyint, tinyint # type % 1, 1, 1 # length _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
