Changeset: 5f29968c76df for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=5f29968c76df
Modified Files:
sql/test/SQLancer/Tests/sqlancer11.sql
sql/test/SQLancer/Tests/sqlancer11.stable.out
Branch: Oct2020
Log Message:
This is the expected output, but I didn't manage to fix without breaking other
tests first
diffs (truncated from 322 to 300 lines):
diff --git a/sql/test/SQLancer/Tests/sqlancer11.sql
b/sql/test/SQLancer/Tests/sqlancer11.sql
--- a/sql/test/SQLancer/Tests/sqlancer11.sql
+++ b/sql/test/SQLancer/Tests/sqlancer11.sql
@@ -113,7 +113,6 @@ SELECT CASE 3 WHEN ((SELECT 0.48) INTERS
ROLLBACK;
START TRANSACTION;
-CREATE TABLE "t0" ("c0" SMALLINT NOT NULL,"c2" INTEGER);
CREATE TABLE "t1" ("c0" SMALLINT NOT NULL,"c2" SMALLINT);
INSERT INTO "t1" VALUES (4, NULL),(3, 4),(3, 5),(2, NULL),(6, NULL),(6,
NULL),(6, NULL),(6, NULL),(6, NULL),(6, NULL),(6, NULL),(6, NULL),(6, NULL),(6,
NULL),(3, NULL),(5, NULL),
(0, 8),(3, NULL),(8, 7),(-1, 6),(3, -3),(7, 7),(0, 1),(8, NULL),(9, NULL),(9,
NULL),(-1, NULL),(2, NULL),(7, 8),(1, 2);
@@ -124,4 +123,6 @@ SELECT t1.c0 FROM t1 FULL OUTER JOIN (SE
-- 90 rows
SELECT (EXISTS (SELECT 1)) OR greatest(TRUE, FALSE) FROM t1 FULL OUTER JOIN
(SELECT 3.3 FROM t2) AS sub0 ON true;
-- 90 rows
+SELECT 1 FROM t1 JOIN (SELECT 3.3 FROM t2) AS sub0 ON true WHERE (EXISTS
(SELECT 1)) OR true >= true;
+ -- 90 rows
ROLLBACK;
diff --git a/sql/test/SQLancer/Tests/sqlancer11.stable.out
b/sql/test/SQLancer/Tests/sqlancer11.stable.out
--- a/sql/test/SQLancer/Tests/sqlancer11.stable.out
+++ b/sql/test/SQLancer/Tests/sqlancer11.stable.out
@@ -203,6 +203,300 @@ stdout of test 'sqlancer11` in directory
[ true ]
[ true ]
#ROLLBACK;
+#START TRANSACTION;
+#CREATE TABLE "t1" ("c0" SMALLINT NOT NULL,"c2" SMALLINT);
+#INSERT INTO "t1" VALUES (4, NULL),(3, 4),(3, 5),(2, NULL),(6, NULL),(6,
NULL),(6, NULL),(6, NULL),(6, NULL),(6, NULL),(6, NULL),(6, NULL),(6, NULL),(6,
NULL),(3, NULL),(5, NULL),
+#(0, 8),(3, NULL),(8, 7),(-1, 6),(3, -3),(7, 7),(0, 1),(8, NULL),(9, NULL),(9,
NULL),(-1, NULL),(2, NULL),(7, 8),(1, 2);
+[ 30 ]
+#CREATE TABLE "t2" ("c0" SMALLINT);
+#INSERT INTO "t2" VALUES (NULL), (NULL), (0);
+[ 3 ]
+#SELECT t1.c0 FROM t1 FULL OUTER JOIN (SELECT 3.3 FROM t2) AS sub0 ON true
WHERE (EXISTS (SELECT 1)) OR greatest(TRUE, FALSE);
+% .t1 # table_name
+% c0 # name
+% smallint # type
+% 2 # length
+[ 4 ]
+[ 4 ]
+[ 4 ]
+[ 3 ]
+[ 3 ]
+[ 3 ]
+[ 3 ]
+[ 3 ]
+[ 3 ]
+[ 2 ]
+[ 2 ]
+[ 2 ]
+[ 6 ]
+[ 6 ]
+[ 6 ]
+[ 6 ]
+[ 6 ]
+[ 6 ]
+[ 6 ]
+[ 6 ]
+[ 6 ]
+[ 6 ]
+[ 6 ]
+[ 6 ]
+[ 6 ]
+[ 6 ]
+[ 6 ]
+[ 6 ]
+[ 6 ]
+[ 6 ]
+[ 6 ]
+[ 6 ]
+[ 6 ]
+[ 6 ]
+[ 6 ]
+[ 6 ]
+[ 6 ]
+[ 6 ]
+[ 6 ]
+[ 6 ]
+[ 6 ]
+[ 6 ]
+[ 3 ]
+[ 3 ]
+[ 3 ]
+[ 5 ]
+[ 5 ]
+[ 5 ]
+[ 0 ]
+[ 0 ]
+[ 0 ]
+[ 3 ]
+[ 3 ]
+[ 3 ]
+[ 8 ]
+[ 8 ]
+[ 8 ]
+[ -1 ]
+[ -1 ]
+[ -1 ]
+[ 3 ]
+[ 3 ]
+[ 3 ]
+[ 7 ]
+[ 7 ]
+[ 7 ]
+[ 0 ]
+[ 0 ]
+[ 0 ]
+[ 8 ]
+[ 8 ]
+[ 8 ]
+[ 9 ]
+[ 9 ]
+[ 9 ]
+[ 9 ]
+[ 9 ]
+[ 9 ]
+[ -1 ]
+[ -1 ]
+[ -1 ]
+[ 2 ]
+[ 2 ]
+[ 2 ]
+[ 7 ]
+[ 7 ]
+[ 7 ]
+[ 1 ]
+[ 1 ]
+[ 1 ]
+#SELECT (EXISTS (SELECT 1)) OR greatest(TRUE, FALSE) FROM t1 FULL OUTER JOIN
(SELECT 3.3 FROM t2) AS sub0 ON true;
+% .%3 # table_name
+% %3 # name
+% boolean # type
+% 5 # length
+[ true ]
+[ true ]
+[ true ]
+[ true ]
+[ true ]
+[ true ]
+[ true ]
+[ true ]
+[ true ]
+[ true ]
+[ true ]
+[ true ]
+[ true ]
+[ true ]
+[ true ]
+[ true ]
+[ true ]
+[ true ]
+[ true ]
+[ true ]
+[ true ]
+[ true ]
+[ true ]
+[ true ]
+[ true ]
+[ true ]
+[ true ]
+[ true ]
+[ true ]
+[ true ]
+[ true ]
+[ true ]
+[ true ]
+[ true ]
+[ true ]
+[ true ]
+[ true ]
+[ true ]
+[ true ]
+[ true ]
+[ true ]
+[ true ]
+[ true ]
+[ true ]
+[ true ]
+[ true ]
+[ true ]
+[ true ]
+[ true ]
+[ true ]
+[ true ]
+[ true ]
+[ true ]
+[ true ]
+[ true ]
+[ true ]
+[ true ]
+[ true ]
+[ true ]
+[ true ]
+[ true ]
+[ true ]
+[ true ]
+[ true ]
+[ true ]
+[ true ]
+[ true ]
+[ true ]
+[ true ]
+[ true ]
+[ true ]
+[ true ]
+[ true ]
+[ true ]
+[ true ]
+[ true ]
+[ true ]
+[ true ]
+[ true ]
+[ true ]
+[ true ]
+[ true ]
+[ true ]
+[ true ]
+[ true ]
+[ true ]
+[ true ]
+[ true ]
+[ true ]
+[ true ]
+#SELECT 1 FROM t1 JOIN (SELECT 3.3 FROM t2) AS sub0 ON true WHERE (EXISTS
(SELECT 1)) OR true >= true;
+% .%7 # table_name
+% %7 # name
+% tinyint # type
+% 1 # length
+[ 1 ]
+[ 1 ]
+[ 1 ]
+[ 1 ]
+[ 1 ]
+[ 1 ]
+[ 1 ]
+[ 1 ]
+[ 1 ]
+[ 1 ]
+[ 1 ]
+[ 1 ]
+[ 1 ]
+[ 1 ]
+[ 1 ]
+[ 1 ]
+[ 1 ]
+[ 1 ]
+[ 1 ]
+[ 1 ]
+[ 1 ]
+[ 1 ]
+[ 1 ]
+[ 1 ]
+[ 1 ]
+[ 1 ]
+[ 1 ]
+[ 1 ]
+[ 1 ]
+[ 1 ]
+[ 1 ]
+[ 1 ]
+[ 1 ]
+[ 1 ]
+[ 1 ]
+[ 1 ]
+[ 1 ]
+[ 1 ]
+[ 1 ]
+[ 1 ]
+[ 1 ]
+[ 1 ]
+[ 1 ]
+[ 1 ]
+[ 1 ]
+[ 1 ]
+[ 1 ]
+[ 1 ]
+[ 1 ]
+[ 1 ]
+[ 1 ]
+[ 1 ]
+[ 1 ]
+[ 1 ]
+[ 1 ]
+[ 1 ]
+[ 1 ]
+[ 1 ]
+[ 1 ]
+[ 1 ]
+[ 1 ]
+[ 1 ]
+[ 1 ]
+[ 1 ]
+[ 1 ]
+[ 1 ]
+[ 1 ]
+[ 1 ]
+[ 1 ]
+[ 1 ]
+[ 1 ]
+[ 1 ]
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
