Changeset: 0132e0a93ff4 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=0132e0a93ff4
Modified Files:
sql/test/SQLancer/Tests/sqlancer09.sql
Branch: Oct2020
Log Message:
Starting the week with a breakfast sqlancer crash :(
diffs (53 lines):
diff --git a/sql/test/SQLancer/Tests/sqlancer09.sql
b/sql/test/SQLancer/Tests/sqlancer09.sql
--- a/sql/test/SQLancer/Tests/sqlancer09.sql
+++ b/sql/test/SQLancer/Tests/sqlancer09.sql
@@ -305,3 +305,49 @@ ROLLBACK;
select
(-1.7976931348623157E308)/(0.98067827792867723335490381941781379282474517822265625);
--error, overflow
values (round(-1.4999792343698102e+308, 15)),(1.2); --error, overflow?
+
+START TRANSACTION;
+CREATE TABLE "sys"."t2" ("c0" REAL NOT NULL, "c1" DECIMAL(15,3),
+ CONSTRAINT "t2_c0_pkey" PRIMARY KEY ("c0"),
+ CONSTRAINT "t2_c0_unique" UNIQUE ("c0"),
+ CONSTRAINT "t2_c0_c1_unique" UNIQUE ("c0", "c1")
+);
+COPY 33 RECORDS INTO "sys"."t2" FROM stdin USING DELIMITERS E'\t',E'\n','"';
+26 0.991
+0.13630049 37.000
+0.51769805 0.784
+-1.6852343e+09 NULL
+0.21530622 NULL
+113.135216 NULL
+1.0975889 0.000
+0.5668781 0.163
+0.07123395 0.808
+0.8320952 NULL
+0.35641629 NULL
+1.4285428e+12 NULL
+0.5716349 0.925
+-1.1734946e+08 0.000
+0.030607125 0.874
+0.83317256 0.000
+-1.7515901e+09 0.246
+5.855687e+08 0.630
+0.6815483 NULL
+0.0059321974 NULL
+0.8218823 0.960
+-4.015704e+08 0.000
+0.34888306 NULL
+-0.5051734 NULL
+0.34162566 NULL
+-1.0525191e+09 -1697412576.000
+0.5970499 NULL
+8.183423e+08 0.664
+0.5821468 0.721
+1.7945473e+09 1535759864.000
+0.24326971 0.329
+-1.0841585e+09 NULL
+10098 0.846
+
+ALTER TABLE t2 ADD CONSTRAINT "t2_c0_c1_fkey" FOREIGN KEY ("c0", "c1")
REFERENCES "sys"."t2" ("c0", "c1");
+update t2 set c1 = 0.012427403386733981704992402228526771068572998046875 where
(((t2.c0)%(t2.c1))) between symmetric
+(coalesce(-1053775800, 991217471)) and (((0.6974006550632457)+(1832026960)));
+ROLLBACK;
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
