Changeset: 13e51292cfc6 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=13e51292cfc6
Modified Files:
sql/test/BugTracker-2016/Tests/storagemodel.stable.out
sql/test/SQLancer/Tests/sqlancer03.stable.out
sql/test/subquery/Tests/subquery6.stable.out
Branch: Jun2020
Log Message:
Approved output
diffs (145 lines):
diff --git a/sql/test/BugTracker-2016/Tests/storagemodel.stable.out
b/sql/test/BugTracker-2016/Tests/storagemodel.stable.out
--- a/sql/test/BugTracker-2016/Tests/storagemodel.stable.out
+++ b/sql/test/BugTracker-2016/Tests/storagemodel.stable.out
@@ -83,8 +83,8 @@ stdout of test 'storagemodel` in directo
% sys.storagemodel, sys.storagemodel, sys.storagemodel,
sys.storagemodel, sys.storagemodel, sys.storagemodel,
sys.storagemodel, sys.storagemodel, sys.storagemodel,
sys.storagemodel, sys.storagemodel, sys.storagemodel,
sys.storagemodel # table_name
% schema, table, column, type, count, columnsize, heapsize,
hashsize, imprintsize, orderidxsize, sorted, unique, isacolumn # name
% varchar, varchar, varchar, varchar, bigint, bigint,
bigint, bigint, bigint, bigint, boolean, boolean, boolean # type
-% 3, 7, 1, 3, 5, 5, 1, 1, 4, 1,
5, 5, 5 # length
-[ "sys", "bug3923", "i", "int", 10000, 40000, 0, 0,
8000, 0, true, NULL, true ]
+% 3, 7, 1, 3, 5, 5, 4, 1, 4, 1,
5, 5, 5 # length
+[ "sys", "bug3923", "i", "int", 10000, 10000, 8312, 0,
2000, 0, true, NULL, true ]
#drop table bug3923;
#create table bug3923(i integer);
#select "schema", "table", "column", "type", "mode", case when typewidth < 14
then typewidth else 99 end as typewidth, hashes, phash, imprints from
sys.storage('sys','_tables');
@@ -108,8 +108,8 @@ stdout of test 'storagemodel` in directo
% sys.storagemodel, sys.storagemodel, sys.storagemodel,
sys.storagemodel, sys.storagemodel, sys.storagemodel,
sys.storagemodel, sys.storagemodel, sys.storagemodel,
sys.storagemodel, sys.storagemodel, sys.storagemodel,
sys.storagemodel # table_name
% schema, table, column, type, count, columnsize, heapsize,
hashsize, imprintsize, orderidxsize, sorted, unique, isacolumn # name
% varchar, varchar, varchar, varchar, bigint, bigint,
bigint, bigint, bigint, bigint, boolean, boolean, boolean # type
-% 13, 7, 1, 3, 5, 5, 1, 1, 4, 1,
5, 5, 5 # length
-[ "bug3923schema", "bug3923", "i", "int", 10000, 40000, 0,
0, 8000, 0, true, NULL, true ]
+% 13, 7, 1, 3, 5, 5, 4, 1, 4, 1,
5, 5, 5 # length
+[ "bug3923schema", "bug3923", "i", "int", 10000, 10000, 8312,
0, 2000, 0, true, NULL, true ]
#drop table bug3923;
# 23:38:44 >
diff --git a/sql/test/SQLancer/Tests/sqlancer03.stable.out
b/sql/test/SQLancer/Tests/sqlancer03.stable.out
--- a/sql/test/SQLancer/Tests/sqlancer03.stable.out
+++ b/sql/test/SQLancer/Tests/sqlancer03.stable.out
@@ -258,6 +258,55 @@ stdout of test 'sqlancer03` in directory
% date, int # type
% 10, 1 # length
#ROLLBACK;
+#START TRANSACTION; -- Bug 6924
+#CREATE TABLE "sys"."t0" ("a" INTEGER, "b" INTEGER NOT NULL, CONSTRAINT
"t0_a_b_unique" UNIQUE ("a","b"));
+#COPY 39 RECORDS INTO "sys"."t0" FROM stdin USING DELIMITERS E'\t',E'\n','"';
+#-88162543 18
+#-88162543 20
+#-15649686 -544149211
+#-88162543 1544983640
+#NULL -22365094
+#NULL 1606640302
+#NULL -2022118335
+#-706411503 -1573662742
+#-88162543 117340240
+#NULL 14
+#1724946985 -1967779742
+#NULL -1500350327
+#NULL -174249097
+#-88162543 29
+#-88162543 42
+#10 0
+#NULL 1861748843
+#NULL -1709541615
+#NULL -143945879
+#NULL 1
+#NULL 1158178587
+#-88162543 14
+#-846070788 0
+#-88162543 1242658499
+#1149990738 -106077877
+#NULL -70926511
+#NULL 138623502
+#NULL -1613851459
+[ 39 ]
+#SELECT 1 FROM t0 GROUP BY 1, 2 HAVING MAX(TRUE);
+% .%1 # table_name
+% %1 # name
+% tinyint # type
+% 1 # length
+[ 1 ]
+#SELECT ALL COUNT(ALL DATE '1970-01-02'), ((rtrim(CAST(0.4 AS STRING),
trim(r'W', r'1')))||(lower(CAST(((r'3')||(INTERVAL '4' MONTH)) AS STRING))))
FROM t0 WHERE ((t0.b)<=(t0.a)) GROUP BY 0.1, TRUE HAVING MAX(ALL TRUE)
+#UNION ALL
+#SELECT COUNT(ALL DATE '1970-01-02'), ((rtrim(CAST(0.4 AS STRING), trim(r'W',
r'1')))||(lower(CAST(((r'3')||(INTERVAL '4' MONTH)) AS STRING)))) FROM t0 WHERE
((t0.b)<=(t0.a)) GROUP BY 0.1, TRUE HAVING NOT (MAX(ALL TRUE))
+#UNION ALL
+#SELECT ALL COUNT(ALL DATE '1970-01-02'), ((rtrim(CAST(0.4 AS STRING),
trim(r'W', r'1')))||(lower(CAST(((r'3')||(INTERVAL '4' MONTH)) AS STRING))))
FROM t0 WHERE ((t0.b)<=(t0.a)) GROUP BY 0.1, TRUE HAVING (MAX(ALL TRUE)) IS
NULL;
+% .%37, .%37 # table_name
+% %3, %16 # name
+% bigint, varchar # type
+% 1, 5 # length
+[ 6, "0.434" ]
+#ROLLBACK;
# 17:14:16 >
# 17:14:16 > "Done."
diff --git a/sql/test/subquery/Tests/subquery6.stable.out
b/sql/test/subquery/Tests/subquery6.stable.out
--- a/sql/test/subquery/Tests/subquery6.stable.out
+++ b/sql/test/subquery/Tests/subquery6.stable.out
@@ -28,8 +28,8 @@ stdout of test 'subquery6` in directory
# WHERE ctr1.ctr_state = ctr2.ctr_state)
# AND col1 = ColID
# AND ctr1.ctr_customer_sk = TotalSales;
-% .%44 # table_name
-% %44 # name
+% .%45 # table_name
+% %45 # name
% tinyint # type
% 1 # length
#SELECT (SELECT (SELECT SUM(col1)) IN (MAX(col2))) FROM another_t;
@@ -75,7 +75,7 @@ stdout of test 'subquery6` in directory
% 4 # length
[ 3702 ]
#SELECT CAST(SUM((SELECT CAST(EXISTS(SELECT col1) AS INT))) AS BIGINT) FROM
another_t;
-% sys.%4 # table_name
+% .%4 # table_name
% %4 # name
% bigint # type
% 1 # length
@@ -209,7 +209,36 @@ stdout of test 'subquery6` in directory
% int # type
% 1 # length
[ NULL ]
-#DROP FUNCTION debugme;
+#DROP FUNCTION debugme3;
+#CREATE FUNCTION debugme4() RETURNS BOOLEAN
+#BEGIN
+# DECLARE n BOOLEAN;
+# SET n = (select true union all select false);
+# RETURN n;
+#END;
+#DROP FUNCTION debugme4;
+#CREATE FUNCTION debugme5() RETURNS BOOLEAN
+#BEGIN
+# DECLARE n BOOLEAN;
+# SET n = (select 1 where null);
+# RETURN n;
+#END;
+#DROP FUNCTION debugme5;
+#CREATE FUNCTION debugme6() RETURNS INT
+#BEGIN
+# DECLARE n INT;
+# WHILE ((SELECT 0) = ANY(SELECT 1)) do
+# SET n = 10;
+# END WHILE;
+# RETURN n;
+#END;
+#SELECT debugme6();
+% .%6 # table_name
+% %6 # name
+% int # type
+% 1 # length
+[ NULL ]
+#DROP FUNCTION debugme6;
#DROP TABLE tbl_ProductSales;
#DROP TABLE another_T;
#DROP TABLE integers;
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
