Changeset: 2c3e026fa46f for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=2c3e026fa46f
Modified Files:
sql/test/SQLancer/Tests/sqlancer06.sql
sql/test/SQLancer/Tests/sqlancer06.stable.err
sql/test/SQLancer/Tests/sqlancer06.stable.out
Branch: Oct2020
Log Message:
Approved output
diffs (148 lines):
diff --git a/sql/test/SQLancer/Tests/sqlancer06.sql
b/sql/test/SQLancer/Tests/sqlancer06.sql
--- a/sql/test/SQLancer/Tests/sqlancer06.sql
+++ b/sql/test/SQLancer/Tests/sqlancer06.sql
@@ -377,7 +377,6 @@ SELECT CAST(((t0.c0)<(COALESCE((SELECT D
-- more than one row returned
ROLLBACK;
-START TRANSACTION;
CREATE TABLE "t0" ("c0" TIME NOT NULL,"c1" INTERVAL SECOND,"c2"
TIME,CONSTRAINT "t0_c0_pkey" PRIMARY KEY ("c0"));
INSERT INTO "t0" VALUES (TIME '03:34:11', INTERVAL '1713881698' SECOND, NULL);
CREATE TABLE "t1" ("c0" TIME,"c2" TIME);
@@ -402,7 +401,9 @@ SELECT t1.c2 FROM t2 RIGHT OUTER JOIN t1
SELECT CAST(SUM(count) AS BIGINT) FROM (SELECT CAST((((((((0.9842272043385978)
NOT IN (1721458345))OR(t2.c0)))AND((t2.c0) BETWEEN ASYMMETRIC (t2.c0) AND
((SELECT t2.c0 FROM t2, t0 WHERE t2.c1)))))OR((SELECT ALL t1.c2 FROM t1, t2) =
ALL(SELECT t0.c2 FROM t0, t1, t2))) AS INT) as count FROM t2 RIGHT OUTER JOIN
t1 ON NOT (t2.c1)) as res;
-- 3
-ROLLBACK;
+DROP TABLE t0;
+DROP TABLE t1;
+DROP TABLE t2;
START TRANSACTION;
CREATE TABLE "t0"("c0" INTERVAL SECOND);
diff --git a/sql/test/SQLancer/Tests/sqlancer06.stable.err
b/sql/test/SQLancer/Tests/sqlancer06.stable.err
--- a/sql/test/SQLancer/Tests/sqlancer06.stable.err
+++ b/sql/test/SQLancer/Tests/sqlancer06.stable.err
@@ -19,8 +19,8 @@ ERROR = !INSERT INTO: UNIQUE constraint
CODE = 40002
MAPI = (monetdb) /var/tmp/mtest-331577/.s.monetdb.32973
QUERY = SELECT CAST(((t0.c0)<(COALESCE((SELECT DISTINCT t0.c0 FROM t0, t2,
t1), t0.c0, t2.c0))) AS INT) FROM t2 RIGHT OUTER JOIN t0 ON t2.c0 = ANY(SELECT
t1.c0 FROM t1, t2);
-ERROR = !Cardinality violation, scalar value expected
-CODE = 21000
+ERROR = !zero_or_one: cardinality violation, scalar expression expected
+CODE = M0M29
# 19:38:32 >
# 19:38:32 > "Done."
diff --git a/sql/test/SQLancer/Tests/sqlancer06.stable.out
b/sql/test/SQLancer/Tests/sqlancer06.stable.out
--- a/sql/test/SQLancer/Tests/sqlancer06.stable.out
+++ b/sql/test/SQLancer/Tests/sqlancer06.stable.out
@@ -618,6 +618,108 @@ stdout of test 'sqlancer06` in directory
[ NULL ]
[ NULL ]
#ROLLBACK;
+#CREATE TABLE "t0" ("c0" TIME NOT NULL,"c1" INTERVAL SECOND,"c2"
TIME,CONSTRAINT "t0_c0_pkey" PRIMARY KEY ("c0"));
+#INSERT INTO "t0" VALUES (TIME '03:34:11', INTERVAL '1713881698' SECOND, NULL);
+[ 1 ]
+#CREATE TABLE "t1" ("c0" TIME,"c2" TIME);
+#INSERT INTO "t1" VALUES (TIME '20:46:35', NULL);
+[ 1 ]
+#INSERT INTO "t1" VALUES (TIME '21:28:54', NULL);
+[ 1 ]
+#INSERT INTO "t1" VALUES (TIME '08:15:08', TIME '20:32:11');
+[ 1 ]
+#CREATE TABLE "t2" ("c0" BOOLEAN NOT NULL,"c1" BOOLEAN,CONSTRAINT "t2_c0_pkey"
PRIMARY KEY ("c0"),CONSTRAINT "t2_c0_unique" UNIQUE ("c0"),CONSTRAINT
"t2_c1_unique" UNIQUE ("c1"));
+#SELECT t1.c2 FROM t2 RIGHT OUTER JOIN t1 ON (t2.c1) WHERE (SELECT TIME
'10:00:00') = ALL(SELECT t0.c2 FROM t0, t2);
+% .t1 # table_name
+% c2 # name
+% time # type
+% 8 # length
+[ NULL ]
+[ NULL ]
+[ 20:32:11 ]
+#SELECT CAST(SUM(count) AS BIGINT) FROM (SELECT
CAST((((((((0.9842272043385978) NOT IN (1721458345))OR(t2.c0)))AND((t2.c0)
BETWEEN ASYMMETRIC (t2.c0) AND
+#((SELECT t2.c0 FROM t2, t0 WHERE t2.c1)))))OR((SELECT ALL t1.c2 FROM t1, t2)
= ALL(SELECT t0.c2 FROM t0, t1, t2))) AS INT) as count FROM t2 RIGHT OUTER JOIN
t1 ON NOT (t2.c1)) as res;
+% .%12 # table_name
+% %12 # name
+% bigint # type
+% 1 # length
+[ 3 ]
+#DROP TABLE t0;
+#DROP TABLE t1;
+#DROP TABLE t2;
+#START TRANSACTION;
+#CREATE TABLE "t0"("c0" INTERVAL SECOND);
+#INSERT INTO "t0" VALUES (INTERVAL '350200327' SECOND);
+[ 1 ]
+#CREATE TABLE "t1"("c0" INTERVAL SECOND);
+#INSERT INTO "t1" VALUES (INTERVAL '1236176693' SECOND);
+[ 1 ]
+#CREATE TABLE "t2"("c0" INTERVAL SECOND NOT NULL);
+#INSERT INTO "t2" VALUES (INTERVAL '1253074618' SECOND);
+[ 1 ]
+#SELECT t1.c0 > COALESCE((SELECT INTERVAL '1' SECOND FROM t2), (SELECT t1.c0
FROM t1)) FROM t1;
+% .%5 # table_name
+% %5 # name
+% boolean # type
+% 5 # length
+[ true ]
+#SELECT CAST(SUM(count) AS BIGINT) FROM (SELECT ALL CAST((t1.c0) NOT BETWEEN
ASYMMETRIC (COALESCE((SELECT DISTINCT INTERVAL '1584712456' SECOND FROM t2),
(SELECT t1.c0 FROM t2, t1, t0))) AND (t1.c0) AS INT) as count FROM t1) as res;
+% .%5 # table_name
+% %5 # name
+% bigint # type
+% 1 # length
+[ 1 ]
+#ROLLBACK;
+#START TRANSACTION;
+#CREATE TABLE "t0" ("c0" TIME,"c1" TIMESTAMP NOT NULL,CONSTRAINT "t0_c1_pkey"
PRIMARY KEY ("c1"));
+#INSERT INTO "t0" VALUES (NULL, TIMESTAMP '1970-01-06 16:28:55.000000');
+[ 1 ]
+#INSERT INTO "t0" VALUES (NULL, TIMESTAMP '1970-01-18 19:02:05.000000');
+[ 1 ]
+#INSERT INTO "t0" VALUES (NULL, TIMESTAMP '1970-01-09 14:51:19.000000');
+[ 1 ]
+#INSERT INTO "t0" VALUES (NULL, TIMESTAMP '1970-01-25 19:25:31.000000');
+[ 1 ]
+#INSERT INTO "t0" VALUES (TIME '15:23:49', TIMESTAMP '1970-01-13
01:58:15.000000');
+[ 1 ]
+#CREATE TABLE "t1" ("c1" TIMESTAMP NOT NULL,CONSTRAINT "t1_c1_pkey" PRIMARY
KEY ("c1"));
+#INSERT INTO "t1" VALUES (TIMESTAMP '1970-01-16 14:51:17.000000');
+[ 1 ]
+#INSERT INTO "t1" VALUES (TIMESTAMP '1970-01-14 12:10:12.000000');
+[ 1 ]
+#INSERT INTO "t1" VALUES (TIMESTAMP '1970-01-02 08:05:41.000000');
+[ 1 ]
+#CREATE TABLE "t2" ("c1" TIMESTAMP NOT NULL,CONSTRAINT "t2_c1_pkey" PRIMARY
KEY ("c1"));
+#SELECT t1.c1 FROM t1 WHERE COALESCE(NOT (SELECT FALSE FROM t2), true);
+% .t1 # table_name
+% c1 # name
+% timestamp # type
+% 26 # length
+[ 1970-01-16 14:51:17.000000 ]
+[ 1970-01-14 12:10:12.000000 ]
+[ 1970-01-02 08:05:41.000000 ]
+#SELECT t1.c1 FROM t1 WHERE COALESCE(NOT (SELECT FALSE FROM t2), false);
+% .t1 # table_name
+% c1 # name
+% timestamp # type
+% 26 # length
+#SELECT t1.c1 FROM t1 WHERE COALESCE(NOT ((SELECT DISTINCT FALSE FROM t1, t0,
t2)), COALESCE((FALSE) = FALSE, ((t1.c1)<(t1.c1)), (t1.c1) NOT BETWEEN
SYMMETRIC (TIMESTAMP '1970-01-02 00:34:29')
+#AND (t1.c1), (FALSE) = FALSE, (DATE '1970-01-01') NOT IN (DATE '1970-01-02',
DATE '1970-01-02')), FALSE);
+% .t1 # table_name
+% c1 # name
+% timestamp # type
+% 26 # length
+[ 1970-01-16 14:51:17.000000 ]
+[ 1970-01-14 12:10:12.000000 ]
+[ 1970-01-02 08:05:41.000000 ]
+#SELECT CAST(SUM(count) AS BIGINT) FROM (SELECT CAST(COALESCE(NOT ((SELECT
DISTINCT FALSE FROM t1, t0, t2)), COALESCE((FALSE) = FALSE, ((t1.c1)<(t1.c1)),
(t1.c1) NOT BETWEEN SYMMETRIC (TIMESTAMP '1970-01-02 00:34:29')
+#AND (t1.c1), (FALSE) = FALSE, (DATE '1970-01-01') NOT IN (DATE '1970-01-02',
DATE '1970-01-02')), FALSE) AS INT) as count FROM t1) as res;
+% .%7 # table_name
+% %7 # name
+% bigint # type
+% 1 # length
+[ 3 ]
+#ROLLBACK;
# 19:38:32 >
# 19:38:32 > "Done."
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
