Changeset: 9c816b8a81e5 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=9c816b8a81e5
Modified Files:
sql/test/SQLancer/Tests/sqlancer06.sql
Branch: Oct2020
Log Message:
New SQLancer crash
diffs (31 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
@@ -320,3 +320,27 @@ SELECT t1.c0 FROM t1 WHERE t1.c0 <> ALL(
SELECT CAST(SUM(count) AS BIGINT) FROM (SELECT ALL CAST(t1.c0 <> ALL(SELECT
DISTINCT CAST(0.5646222839477373 AS INT) FROM t0, t1 WHERE (t0.c1) NOT BETWEEN
ASYMMETRIC (COALESCE(t0.c1, t0.c1)) AND (t0.c1)) AS INT) as count FROM t1) as
res;
-- 40
ROLLBACK;
+
+START TRANSACTION;
+CREATE TABLE "sys"."t0" ("c0" TIME,"c1" DECIMAL(18,3));
+COPY 3 RECORDS INTO "sys"."t0" FROM stdin USING DELIMITERS E'\t',E'\n','"';
+05:09:43 0.122
+NULL 0.824
+NULL NULL
+
+CREATE TABLE "sys"."t1" ("c1" DECIMAL(18,3));
+COPY 2 RECORDS INTO "sys"."t1" FROM stdin USING DELIMITERS E'\t',E'\n','"';
+0.320
+0.995
+
+CREATE TABLE "sys"."t2" ("c0" DOUBLE NOT NULL,CONSTRAINT "t2_c0_pkey" PRIMARY
KEY ("c0"),CONSTRAINT "t2_c0_unique" UNIQUE ("c0"));
+COPY 5 RECORDS INTO "sys"."t2" FROM stdin USING DELIMITERS E'\t',E'\n','"';
+0.5352396631754883
+0.4722686692942629
+0.06898879964424565
+946154646
+0.5253008674729628
+
+select cast((t2.c0) not in ((select all 1.360204425E9 from t0), t2.c0) as int)
from t1 full outer join t2 on false;
+ --error, more than one row returned by a subquery used as an expression
+ROLLBACK;
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
