Changeset: 0b3e122ba52d for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=0b3e122ba52d
Modified Files:
sql/test/analytics/Tests/analytics13.sql
sql/test/analytics/Tests/analytics13.stable.out
Branch: Jun2020
Log Message:
Remove column 13 from test: FIRST_VALUE *cannot* give a well-defined result.
In this query there are *5* different legitimate results for
FIRST_VALUE: NULL, 1, 11, 111, 1111.
Alternatives that can work: MIN and MAX (results 1 and 1111 respectively).
diffs (truncated from 335 to 300 lines):
diff --git a/sql/test/analytics/Tests/analytics13.sql
b/sql/test/analytics/Tests/analytics13.sql
--- a/sql/test/analytics/Tests/analytics13.sql
+++ b/sql/test/analytics/Tests/analytics13.sql
@@ -145,14 +145,16 @@ SELECT
GROUPING(col1, col5, col8) * MIN(col8) OVER (PARTITION BY col5 ORDER BY
col1 NULLS LAST ROWS UNBOUNDED PRECEDING) a10,
MAX(col3) / 10 + GROUPING(col1, col5, col2) * 10 a11,
GROUP_CONCAT(CAST(col4 AS VARCHAR(32)), '-sep-') || ' plus ' ||
GROUPING(col1) a12,
- FIRST_VALUE(col1) OVER (ORDER BY col8 DESC NULLS FIRST) a13,
+-- FIRST_VALUE(col1) OVER (ORDER BY col8 DESC NULLS FIRST) a13,
CAST(col2 * NULL AS BIGINT) a14
FROM another_T
GROUP BY CUBE(col1, col2, col5, col8), GROUPING SETS (())
ORDER BY
a1 ASC NULLS FIRST, a2 ASC NULLS LAST, a3 DESC NULLS FIRST, a4 DESC NULLS
LAST, a5 ASC NULLS FIRST,
a6 DESC NULLS LAST, a7 ASC NULLS FIRST, a8 ASC NULLS LAST, a9 ASC NULLS
FIRST, a10 DESC NULLS LAST,
- a11 ASC NULLS FIRST, a12 DESC NULLS LAST, a13 ASC NULLS FIRST, a14 DESC
NULLS LAST;
+ a11 ASC NULLS FIRST, a12 DESC NULLS LAST,
+-- a13 ASC NULLS FIRST,
+ a14 DESC NULLS LAST;
SELECT
NOT t1.col1 BETWEEN (SELECT MAX(t1.col7) EXCEPT SELECT tp.ColID FROM
tbl_ProductSales tp) AND (SELECT MIN(t1.col5) EXCEPT SELECT t1.col2) a1,
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
@@ -84,8 +84,8 @@ stdout of test 'analytics13` in director
# col1 IN (SELECT ColID FROM tbl_ProductSales)
#FROM another_T
#GROUP BY ROLLUP(col1);
-% .%12 # table_name
-% %12 # name
+% .%13 # table_name
+% %13 # name
% boolean # type
% 5 # length
[ true ]
@@ -97,8 +97,8 @@ stdout of test 'analytics13` in director
# col1 IN (SELECT ColID + col1 FROM tbl_ProductSales)
#FROM another_T
#GROUP BY ROLLUP(col1);
-% .%14 # table_name
-% %14 # name
+% .%15 # table_name
+% %15 # name
% boolean # type
% 5 # length
[ false ]
@@ -110,8 +110,8 @@ stdout of test 'analytics13` in director
# col1 IN (SELECT SUM(ColID + col1) FROM tbl_ProductSales)
#FROM another_T
#GROUP BY ROLLUP(col1);
-% .%14 # table_name
-% %14 # name
+% .%15 # table_name
+% %15 # name
% boolean # type
% 5 # length
[ false ]
@@ -161,8 +161,8 @@ stdout of test 'analytics13` in director
# SUM(col1) IN (SELECT DISTINCT col2 FROM another_T GROUP BY col2)
#FROM another_T
#GROUP BY CUBE(col4);
-% .%13 # table_name
-% %13 # name
+% .%14 # table_name
+% %14 # name
% boolean # type
% 5 # length
[ false ]
@@ -175,7 +175,7 @@ stdout of test 'analytics13` in director
#FROM another_T t1
#GROUP BY col1;
% . # table_name
-% %62 # name
+% %65 # name
% tinyint # type
% 1 # length
[ 1 ]
@@ -185,8 +185,8 @@ stdout of test 'analytics13` in director
#SELECT
# 1 IN (SELECT 1 FROM tbl_ProductSales GROUP BY CUBE(t1.col1,
tbl_ProductSales.ColID))
#FROM another_T t1;
-% .%14 # table_name
-% %14 # name
+% .%15 # table_name
+% %15 # name
% boolean # type
% 5 # length
[ true ]
@@ -197,8 +197,8 @@ stdout of test 'analytics13` in director
# t1.col1 IN (SELECT ColID FROM tbl_ProductSales GROUP BY CUBE(t1.col1,
tbl_ProductSales.ColID))
#FROM another_T t1
#GROUP BY CUBE(col1, col2);
-% .%14 # table_name
-% %14 # name
+% .%15 # table_name
+% %15 # name
% boolean # type
% 5 # length
[ true ]
@@ -224,8 +224,8 @@ 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);
-% ., .%47, ., ., ., ., . # table_name
-% %321, %47, %323, %324, %325, %326, %327 # name
+% ., .%53, ., ., ., ., . # table_name
+% %331, %53, %333, %334, %335, %336, %337 # name
% boolean, boolean, boolean, boolean, boolean,
boolean, boolean # type
% 5, 5, 5, 5, 5, 5, 5 # length
[ true, false, false, false, false, true, true ]
@@ -251,8 +251,8 @@ 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
-% ., .%47, ., ., ., ., . # table_name
-% %321, %47, %323, %324, %325, %326, %327 # name
+% ., .%53, ., ., ., ., . # table_name
+% %331, %53, %333, %334, %335, %336, %337 # name
% boolean, boolean, boolean, boolean, boolean,
boolean, boolean # type
% 5, 5, 5, 5, 5, 5, 5 # length
[ true, false, false, false, false, true, true ]
@@ -266,7 +266,7 @@ stdout of test 'analytics13` in director
# 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)
% ., ., ., ., . # table_name
-% %221, %222, %223, %224, %225 # name
+% %224, %225, %226, %227, %230 # 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, .%13, .%14, .%15, .another_t, .%16, .%17 #
table_name
-% %1, %2, %13, %14, %15, col7, %16, %17 # name
+% .%1, .%2, .%15, .%16, .%17, .another_t, .%20, .%21 #
table_name
+% %1, %2, %15, %16, %17, col7, %20, %21 # 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 ]
@@ -386,7 +386,7 @@ stdout of test 'analytics13` in director
#FROM another_T
#GROUP BY ROLLUP(col1);
% . # table_name
-% %15 # name
+% %16 # name
% boolean # type
% 5 # length
[ true ]
@@ -468,7 +468,7 @@ stdout of test 'analytics13` in director
# 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)
% ., ., ., ., . # table_name
-% %221, %222, %223, %224, %225 # name
+% %224, %225, %226, %227, %230 # 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,
-% ., ., ., ., ., ., ., ., ., .,
., ., ., . # 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, 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 ]
+% ., ., ., ., ., ., ., ., ., .,
., ., . # table_name
+% a1, a2, a3, a4, a5, a6, a7, a8, a9, a10,
a11, a12, a14 # name
+% tinyint, boolean, boolean, int, boolean,
boolean, boolean, bigint, bigint, bigint, bigint, varchar,
bigint # type
+% 2, 5, 5, 4, 5, 5, 5, 4, 4, 5,
3, 32, 1 # length
+[ 0, false, true, 5555, true, false, false, 1111, 2226, 0,
333, "4444 plus 0", NULL ]
+[ 0, false, true, NULL, true, true, false, 1, 6, 0,
0, "4 plus 0", NULL ]
+[ 0, false, true, NULL, true, false, false, 11, 26, 0,
3, "44 plus 0", NULL ]
+[ 0, false, true, NULL, true, false, false, 111, 226, 0,
33, "444 plus 0", NULL ]
+[ 1, false, true, 5555, true, false, false, 1111, 2226, 8888,
333, "4444 plus 0", NULL ]
+[ 1, false, true, NULL, true, true, false, 1, 6, 8,
0, "4 plus 0", NULL ]
+[ 1, false, true, NULL, true, false, false, 11, 26, 88,
3, "44 plus 0", NULL ]
+[ 1, false, true, NULL, true, false, false, 111, 226, 888,
33, "444 plus 0", NULL ]
+[ 2, false, true, 5555, true, false, NULL, 1111, 2226, 16,
353, "4444 plus 0", NULL ]
+[ 2, false, true, NULL, true, true, NULL, 1, 6, 16,
20, "4 plus 0", NULL ]
+[ 2, false, true, NULL, true, false, NULL, 11, 26, 16,
23, "44 plus 0", NULL ]
+[ 2, false, true, NULL, true, false, NULL, 111, 226, 16,
53, "444 plus 0", NULL ]
+[ 3, false, true, 5555, true, false, NULL, 1111, 2226, 24,
353, "4444 plus 0", NULL ]
+[ 3, false, true, NULL, true, true, NULL, 1, 6, 24,
20, "4 plus 0", NULL ]
+[ 3, false, true, NULL, true, false, NULL, 11, 26, 24,
23, "44 plus 0", NULL ]
+[ 3, false, true, NULL, true, false, NULL, 111, 226, 24,
53, "444 plus 0", NULL ]
+[ 4, NULL, NULL, 5555, true, false, false, 1111, NULL, 0,
343, "4444 plus 0", NULL ]
+[ 4, NULL, NULL, NULL, true, true, false, 1, NULL, 0,
10, "4 plus 0", NULL ]
+[ 4, NULL, NULL, NULL, true, false, false, 11, NULL, 0,
13, "44 plus 0", NULL ]
+[ 4, NULL, NULL, NULL, true, false, false, 111, NULL, 0,
43, "444 plus 0", NULL ]
+[ 5, NULL, NULL, 5555, true, false, false, 1111, NULL, 8888,
343, "4444 plus 0", NULL ]
+[ 5, NULL, NULL, NULL, true, true, false, 1, NULL, 8,
10, "4 plus 0", NULL ]
+[ 5, NULL, NULL, NULL, true, false, false, 11, NULL, 88,
13, "44 plus 0", NULL ]
+[ 5, NULL, NULL, NULL, true, false, false, 111, NULL, 888,
43, "444 plus 0", NULL ]
+[ 6, NULL, NULL, 5555, true, false, NULL, 1111, NULL, 16,
363, "4444 plus 0", NULL ]
+[ 6, NULL, NULL, NULL, true, true, NULL, 1, NULL, 16,
30, "4 plus 0", NULL ]
+[ 6, NULL, NULL, NULL, true, false, NULL, 11, NULL, 16,
33, "44 plus 0", NULL ]
+[ 6, NULL, NULL, NULL, true, false, NULL, 111, NULL, 16,
63, "444 plus 0", NULL ]
+[ 7, NULL, NULL, 5555, true, false, NULL, 1111, NULL, 24,
363, "4444 plus 0", NULL ]
+[ 7, NULL, NULL, NULL, true, true, NULL, 1, NULL, 24,
30, "4 plus 0", NULL ]
+[ 7, NULL, NULL, NULL, true, false, NULL, 11, NULL, 24,
33, "44 plus 0", NULL ]
+[ 7, NULL, NULL, NULL, true, false, NULL, 111, NULL, 24,
63, "444 plus 0", NULL ]
+[ 8, NULL, NULL, 5555, true, false, NULL, 1111, 2226, 35552,
373, "4444 plus 1", NULL ]
+[ 8, NULL, NULL, NULL, true, false, NULL, 1, 6, 32,
40, "4 plus 1", NULL ]
+[ 8, NULL, NULL, NULL, true, false, NULL, 11, 26, 352,
43, "44 plus 1", NULL ]
+[ 8, NULL, NULL, NULL, true, false, NULL, 111, 226, 3552,
73, "444 plus 1", NULL ]
+[ 9, NULL, NULL, 5555, true, false, NULL, 1111, 2226, 44440,
373, "4444 plus 1", NULL ]
+[ 9, NULL, NULL, NULL, true, false, NULL, 1, 6, 40,
40, "4 plus 1", NULL ]
+[ 9, NULL, NULL, NULL, true, false, NULL, 11, 26, 440,
43, "44 plus 1", NULL ]
+[ 9, NULL, NULL, NULL, true, false, NULL, 111, 226, 4440,
73, "444 plus 1", NULL ]
+[ 10, NULL, NULL, 5555, true, false, NULL, 1111, 2226, 48,
393, "4444 plus 1", NULL ]
+[ 10, NULL, NULL, NULL, true, false, NULL, 1, 6, 48,
60, "4 plus 1", NULL ]
+[ 10, NULL, NULL, NULL, true, false, NULL, 11, 26, 48,
63, "44 plus 1", NULL ]
+[ 10, NULL, NULL, NULL, true, false, NULL, 111, 226, 48,
93, "444 plus 1", NULL ]
+[ 11, NULL, NULL, 5555, true, false, NULL, 1111, 2226, 56,
393, "4444 plus 1", NULL ]
+[ 11, NULL, NULL, NULL, true, false, NULL, 1, 6, 56,
60, "4 plus 1", NULL ]
+[ 11, NULL, NULL, NULL, true, false, NULL, 11, 26, 56,
63, "44 plus 1", NULL ]
+[ 11, NULL, NULL, NULL, true, false, NULL, 111, 226, 56,
93, "444 plus 1", NULL ]
+[ 12, NULL, NULL, 5555, true, false, NULL, 1111, NULL, 35552,
383, "4444 plus 1", NULL ]
+[ 12, NULL, NULL, NULL, true, false, NULL, 1, NULL, 32,
50, "4 plus 1", NULL ]
+[ 12, NULL, NULL, NULL, true, false, NULL, 11, NULL, 352,
53, "44 plus 1", NULL ]
+[ 12, NULL, NULL, NULL, true, false, NULL, 111, NULL, 3552,
83, "444 plus 1", NULL ]
+[ 13, NULL, NULL, 5555, true, false, NULL, 1111, NULL, 44440,
383, "4444 plus 1", NULL ]
+[ 13, NULL, NULL, NULL, true, false, NULL, 1, NULL, 40,
50, "4 plus 1", NULL ]
+[ 13, NULL, NULL, NULL, true, false, NULL, 11, NULL, 440,
53, "44 plus 1", NULL ]
+[ 13, NULL, NULL, NULL, true, false, NULL, 111, NULL, 4440,
83, "444 plus 1", NULL ]
+[ 14, NULL, NULL, 5555, true, false, NULL, 1111, NULL, 48,
403, "4444 plus 1", NULL ]
+[ 14, NULL, NULL, NULL, true, false, NULL, 1, NULL, 48,
70, "4 plus 1", NULL ]
+[ 14, NULL, NULL, NULL, true, false, NULL, 11, NULL, 48,
73, "44 plus 1", NULL ]
+[ 14, NULL, NULL, NULL, true, false, NULL, 111, NULL, 48,
103, "444 plus 1", NULL ]
+[ 15, NULL, NULL, NULL, true, false, NULL, 1234, NULL, 56,
403, "4-sep-44-sep-444-sep-4444 plus 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
@@ -623,8 +623,8 @@ 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)),
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
