Changeset: 0ee0fcb2bf58 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=0ee0fcb2bf58
Modified Files:
sql/test/SQLancer/Tests/sqlancer07.sql
sql/test/SQLancer/Tests/sqlancer07.stable.out
Branch: Oct2020
Log Message:
Approved output. We use a different character order from Postgres by default
diffs (62 lines):
diff --git a/sql/test/SQLancer/Tests/sqlancer07.sql
b/sql/test/SQLancer/Tests/sqlancer07.sql
--- a/sql/test/SQLancer/Tests/sqlancer07.sql
+++ b/sql/test/SQLancer/Tests/sqlancer07.sql
@@ -82,9 +82,9 @@ CREATE TABLE "t2" ("c0" CHAR(315));
INSERT INTO "t2" VALUES ('1753268987.000'), ('(y/l'), ('(y/l'), ('');
SELECT '1' > COALESCE(((SELECT t1.c0 FROM t1) INTERSECT (SELECT '2')), t0.c0)
FROM t0;
- -- False
+ -- True
-- True
- -- False
+ -- True
SELECT CAST(((COALESCE(t0.c0, t0.c0, t0.c0))>(COALESCE(((SELECT DISTINCT t1.c0
FROM t1, t0, t2 WHERE FALSE) INTERSECT DISTINCT (SELECT ALL t0.c0 FROM t0 WHERE
TRUE)),
t0.c0, CASE INTERVAL '720497648' MONTH WHEN INTERVAL '1899785652' MONTH THEN
t0.c0 ELSE t0.c0 END))) AS INT) FROM t0;
-- 0
diff --git a/sql/test/SQLancer/Tests/sqlancer07.stable.out
b/sql/test/SQLancer/Tests/sqlancer07.stable.out
--- a/sql/test/SQLancer/Tests/sqlancer07.stable.out
+++ b/sql/test/SQLancer/Tests/sqlancer07.stable.out
@@ -107,6 +107,43 @@ stdout of test 'sqlancer07` in directory
#CREATE TABLE "t2" ("c0" CHAR(315));
#INSERT INTO "t2" VALUES ('1753268987.000'), ('(y/l'), ('(y/l'), ('');
[ 4 ]
+#SELECT '1' > COALESCE(((SELECT t1.c0 FROM t1) INTERSECT (SELECT '2')), t0.c0)
FROM t0;
+% .%11 # table_name
+% %11 # name
+% boolean # type
+% 5 # length
+[ true ]
+[ true ]
+[ true ]
+#SELECT CAST(((COALESCE(t0.c0, t0.c0, t0.c0))>(COALESCE(((SELECT DISTINCT
t1.c0 FROM t1, t0, t2 WHERE FALSE) INTERSECT DISTINCT (SELECT ALL t0.c0 FROM t0
WHERE TRUE)),
+#t0.c0, CASE INTERVAL '720497648' MONTH WHEN INTERVAL '1899785652' MONTH THEN
t0.c0 ELSE t0.c0 END))) AS INT) FROM t0;
+% .%7 # table_name
+% %7 # name
+% int # type
+% 1 # length
+[ 0 ]
+[ 0 ]
+[ 0 ]
+#ROLLBACK;
+#START TRANSACTION;
+#CREATE TABLE "t0" ("c0" VARCHAR(156) NOT NULL);
+#INSERT INTO "t0" VALUES ('');
+[ 1 ]
+#CREATE TABLE "t1" ("c0" VARCHAR(156) NOT NULL);
+#INSERT INTO "t1" VALUES ('i?#\t+U,s'), ('288044674'), ('b'), ('W?ykP7L+X'),
('34076821'), ('ah'), ('﹂9j0M4');
+[ 7 ]
+#SELECT CASE '1' WHEN COALESCE((SELECT t0.c0 FROM t0), COALESCE(t1.c0, '2'))
THEN 1 END FROM t1;
+% .%2 # table_name
+% %2 # name
+% tinyint # type
+% 1 # length
+[ NULL ]
+[ NULL ]
+[ NULL ]
+[ NULL ]
+[ NULL ]
+[ NULL ]
+[ NULL ]
#ROLLBACK;
# 10:16:14 >
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
