Changeset: ac79f0433b88 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=ac79f0433b88
Modified Files:
sql/test/SQLancer/Tests/sqlancer07.sql
Branch: octbugs
Log Message:
New SQLancer crash on subquery
diffs (22 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
@@ -165,3 +165,18 @@ PREPARE SELECT 1 WHERE greatest(true, ?)
PREPARE SELECT (SELECT ? FROM (select 1) as v1(c0));
-- cannot determine parameter type
+
+START TRANSACTION;
+CREATE TABLE "t0" ("c0" INTEGER,"c1" DECIMAL(18,3));
+INSERT INTO "t0" VALUES (72238796, 0.553);
+CREATE TABLE "t1" ("c0" INTEGER);
+INSERT INTO "t1" VALUES (-1302854973), (-1302854973), (107900469),
(-292023894);
+CREATE TABLE "t2" ("c0" INTEGER);
+INSERT INTO "t2" VALUES (1), (2), (3);
+
+SELECT t0.c1 FROM t0 WHERE (VALUES (t0.c1 = (SELECT t0.c1 FROM t0)));
+ -- 0.553
+SELECT CAST(sum((((VALUES (NULLIF(0, 1.09949409E8))))*(t0.c0))) AS BIGINT)
FROM t2 JOIN t0 ON
+(VALUES ((t0.c1) NOT BETWEEN ASYMMETRIC (CAST(140698873 AS DECIMAL)) AND
(((SELECT DISTINCT t0.c1 FROM t0, t1, t2) EXCEPT DISTINCT (SELECT t0.c1 FROM
t0, t2 WHERE TRUE)))));
+ -- 0
+ROLLBACK;
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
