Changeset: a2b60c611cc5 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=a2b60c611cc5
Modified Files:
sql/test/SQLancer/Tests/sqlancer06.sql
sql/test/SQLancer/Tests/sqlancer06.stable.err
sql/test/SQLancer/Tests/sqlancer06.stable.out
sql/test/SQLancer/Tests/sqlancer07.sql
Branch: Oct2020
Log Message:
New crash and approved output. Enough bugs for now
diffs (70 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
@@ -390,9 +390,7 @@ SELECT t1.c2 FROM t2 RIGHT OUTER JOIN t1
-- NULL
-- 20:32:11
SELECT t1.c2 FROM t2 RIGHT OUTER JOIN t1 ON (t2.c1) WHERE (SELECT t1.c2 FROM
t1) = ALL(SELECT t0.c2 FROM t0, t2);
- -- NULL
- -- NULL
- -- 20:32:11
+ -- error, more than one row returned by a subquery used as an expression
SELECT t1.c2 FROM t2 RIGHT OUTER JOIN t1 ON (t2.c1) WHERE (SELECT t1.c2 FROM
t1, t2) = ALL(SELECT t0.c2 FROM t0, t2);
-- NULL
-- NULL
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
@@ -21,6 +21,9 @@ MAPI = (monetdb) /var/tmp/mtest-331577/
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 = !zero_or_one: cardinality violation, scalar expression expected
CODE = M0M29
+MAPI = (monetdb) /var/tmp/mtest-174425/.s.monetdb.32391
+QUERY = SELECT t1.c2 FROM t2 RIGHT OUTER JOIN t1 ON (t2.c1) WHERE (SELECT
t1.c2 FROM t1) = ALL(SELECT t0.c2 FROM t0, t2);
+ERROR = !GDK reported error: BATsubcross: more than one match
# 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
@@ -720,6 +720,23 @@ stdout of test 'sqlancer06` in directory
% 1 # length
[ 3 ]
#ROLLBACK;
+#START TRANSACTION;
+#CREATE TABLE "t0" ("c0" BOOLEAN NOT NULL,"c1" INTERVAL MONTH,CONSTRAINT
"t0_c0_pkey" PRIMARY KEY ("c0"));
+#INSERT INTO "t0" VALUES (false, NULL);
+[ 1 ]
+#CREATE TABLE "t1" ("c0" BOOLEAN);
+#CREATE TABLE "t2" ("c1" DOUBLE PRECISION NOT NULL,"c2" DECIMAL(18,3) NOT
NULL,CONSTRAINT "t2_c2_pkey" PRIMARY KEY ("c2"),CONSTRAINT "t2_c2_unique"
UNIQUE ("c2"),CONSTRAINT "t2_c1_c2_unique" UNIQUE ("c1", "c2"));
+#INSERT INTO "t2" VALUES (0.9896628791758083, 0.017);
+[ 1 ]
+#INSERT INTO "t2" VALUES (-808084788, 0.922);
+[ 1 ]
+#SELECT CAST(SUM(count) AS BIGINT) FROM (SELECT CAST((((((((t0.c0 <>
ALL(SELECT t0.c0 FROM t0, t2, t1))OR(t0.c0)))AND(t0.c0)))OR(t0.c0))) = FALSE AS
INT) as count FROM t0) as res;
+% .%6 # table_name
+% %6 # name
+% bigint # type
+% 1 # length
+[ 1 ]
+#ROLLBACK;
# 19:38:32 >
# 19:38:32 > "Done."
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
@@ -31,3 +31,12 @@ SELECT CAST(NOT ((t0.c0) NOT BETWEEN SYM
--error, more than one row returned by a subquery used as an expression
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;
+ -- empty
+ROLLBACK;
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
