Changeset: b119eab52866 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=b119eab52866
Modified Files:
sql/test/SQLancer/Tests/sqlancer07.stable.err
sql/test/SQLancer/Tests/sqlancer07.stable.out
Branch: Oct2020
Log Message:
Approved output
diffs (54 lines):
diff --git a/sql/test/SQLancer/Tests/sqlancer07.stable.err
b/sql/test/SQLancer/Tests/sqlancer07.stable.err
--- a/sql/test/SQLancer/Tests/sqlancer07.stable.err
+++ b/sql/test/SQLancer/Tests/sqlancer07.stable.err
@@ -9,6 +9,12 @@ MAPI = (monetdb) /var/tmp/mtest-52758/.
QUERY = PREPARE SELECT DISTINCT (SELECT DISTINCT r'|m<kv' FROM t1 WHERE
((t1.c0)<(?)) GROUP BY t1.c2, ?), ?, t1.c2 FROM t1 WHERE CAST(? AS BOOLEAN)
LIMIT 2103332269785059850;
ERROR = !Could not determine type for argument number 2
CODE = 42000
+MAPI = (monetdb) /var/tmp/mtest-81449/.s.monetdb.32416
+QUERY = SELECT t0.c0 BETWEEN SYMMETRIC (SELECT t0.c0 FROM t0) AND t0.c0 FROM
t0;
+ERROR = !GDK reported error: BATsubcross: more than one match
+MAPI = (monetdb) /var/tmp/mtest-81449/.s.monetdb.32416
+QUERY = SELECT CAST(NOT ((t0.c0) NOT BETWEEN SYMMETRIC ((SELECT DISTINCT t0.c0
FROM t0, t1)) AND (t0.c0)) AS INT) FROM t0;
+ERROR = !GDK reported error: BATsubcross: more than one match
# 10:16:14 >
# 10:16:14 > "Done."
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
@@ -23,6 +23,34 @@ stdout of test 'sqlancer07` in directory
% int # type
% 1 # length
#ROLLBACK;
+#CREATE TABLE "t0" ("c0" DOUBLE PRECISION NOT NULL);
+#INSERT INTO "t0" VALUES (0.13492451886840173);
+[ 1 ]
+#INSERT INTO "t0" VALUES (79004262);
+[ 1 ]
+#INSERT INTO "t0" VALUES (1476461507);
+[ 1 ]
+#CREATE TABLE "t1" ("c0" DOUBLE PRECISION);
+#INSERT INTO "t1" VALUES (973588428);
+[ 1 ]
+#INSERT INTO "t1" VALUES (NULL);
+[ 1 ]
+#INSERT INTO "t1" VALUES (0.39517295223772886);
+[ 1 ]
+#INSERT INTO "t1" VALUES (NULL);
+[ 1 ]
+#DROP TABLE t0;
+#DROP TABLE t1;
+#START TRANSACTION;
+#CREATE TABLE "t0" ("c0" DATE NOT NULL);
+#CREATE TABLE "t1" ("c1" INT);
+#CREATE TABLE "t2" ("c0" DATE NOT NULL);
+#SELECT 0 <= ANY(SELECT CASE INTERVAL '2' SECOND WHEN INTERVAL '6' SECOND THEN
t1.c1 ELSE (SELECT t1.c1 FROM t1) END FROM t1) FROM t1;
+% .%7 # table_name
+% %7 # name
+% boolean # type
+% 5 # length
+#ROLLBACK;
# 10:16:14 >
# 10:16:14 > "Done."
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
