Changeset: 82d469d9b3d4 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=82d469d9b3d4
Modified Files:
sql/test/BugTracker-2017/Tests/insert_self_ref_FK.Bug-6131.sql
sql/test/SQLancer/Tests/sqlancer04.sql
Branch: default
Log Message:
SQLancer bat.replace undefined. Looking on it. SQLancer also found the existing
the self foreign key reference bug, amazing.
diffs (49 lines):
diff --git a/sql/test/BugTracker-2017/Tests/insert_self_ref_FK.Bug-6131.sql
b/sql/test/BugTracker-2017/Tests/insert_self_ref_FK.Bug-6131.sql
--- a/sql/test/BugTracker-2017/Tests/insert_self_ref_FK.Bug-6131.sql
+++ b/sql/test/BugTracker-2017/Tests/insert_self_ref_FK.Bug-6131.sql
@@ -30,3 +30,17 @@ INSERT INTO test101 VALUES (104, 104, 10
DROP TABLE test101;
+-- SQLancer just reproduced this bug
+CREATE TABLE "sys"."t1" ("c0" DOUBLE,CONSTRAINT "t1_c0_unique" UNIQUE
("c0"),CONSTRAINT "t1_c0_fkey" FOREIGN KEY ("c0") REFERENCES "sys"."t1" ("c0"));
+COPY 9 RECORDS INTO "sys"."t1" FROM stdin USING DELIMITERS E'\t',E'\n','"';
+0.21248182395969406
+0.6307796692265083
+2059310235
+-6.5457821e+08
+0.743704157497456
+0.4001718453135127
+0.3935743494971655
+0.5299192301063729
+0.7609386265982908
+
+ROLLBACK;
diff --git a/sql/test/SQLancer/Tests/sqlancer04.sql
b/sql/test/SQLancer/Tests/sqlancer04.sql
--- a/sql/test/SQLancer/Tests/sqlancer04.sql
+++ b/sql/test/SQLancer/Tests/sqlancer04.sql
@@ -120,3 +120,24 @@ THEN (0.2) IN (0.3) END AS BOOLEAN) GROU
SELECT PROD(ALL 0.14) FROM t0 JOIN t1 ON CAST(CASE t0.c1 WHEN t1.c1 THEN NOT
(FALSE) WHEN t1.c1 THEN (t0.c0) NOT BETWEEN ASYMMETRIC (t1.c0) AND (t0.c0)
WHEN t0.c1
THEN (0.2) IN (0.3) END AS BOOLEAN) GROUP BY NOT (FALSE),
COALESCE(((COALESCE(2, 4, 1))<<(COALESCE(5, -6))), ((COALESCE(r'-8', -4,
6))|(COALESCE(-2, 3, 4, 5, -6))));
ROLLBACK;
+
+START TRANSACTION;
+CREATE TABLE t0(c0 DOUBLE PRIMARY KEY NULL);
+CREATE TABLE "sys"."t1" ("c0" DOUBLE,CONSTRAINT "t1_c0_unique" UNIQUE ("c0"));
+COPY 9 RECORDS INTO "sys"."t1" FROM stdin USING DELIMITERS E'\t',E'\n','"';
+0.21248182395969406
+0.6307796692265083
+2059310235
+-6.5457821e+08
+0.743704157497456
+0.4001718453135127
+0.3935743494971655
+0.5299192301063729
+0.7609386265982908
+
+SELECT CASE WHEN DATE '1970-01-04' IS NULL THEN CAST(CASE t1.c0 WHEN t1.c0
THEN TIME '11:33:56' END AS VARCHAR(524)) ELSE '0.6' END FROM t1;
+
+SELECT ALL MAX(ALL CASE WHEN (DATE '1970-01-04') IS NULL THEN CAST(CASE t1.c0
WHEN t1.c0 THEN TIME '11:33:56' END AS VARCHAR(524)) ELSE
sql_max(r'iDfwsFjp藖1J洅ៅR-?0OT^.', r'0.6') END) FROM t1
+JOIN (SELECT ALL t0.c0, greatest(CAST(INTERVAL '6' SECOND AS TIME), TIME
'10:25:00') FROM t1, t0) AS sub0 ON (COALESCE(-3, -6, 3)) NOT IN (CASE WHEN
TRUE THEN -3 END, ((-4)&(-5)), - (6))
+WHERE ((r'%')ILIKE(r'6')) GROUP BY COALESCE(CAST(least(0.4, 0.7) AS
VARCHAR(506)), CAST(nullif(TIME '14:14:35', TIME '02:49:23') AS VARCHAR(388))),
abs(0.6);
+ROLLBACK;
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
