Changeset: f6e4c7abe85b for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=f6e4c7abe85b
Modified Files:
sql/test/SQLancer/Tests/sqlancer03.sql
Branch: Jun2020
Log Message:
SQLancer SIGFPE (division by 0)
diffs (44 lines):
diff --git a/sql/test/SQLancer/Tests/sqlancer03.sql
b/sql/test/SQLancer/Tests/sqlancer03.sql
--- a/sql/test/SQLancer/Tests/sqlancer03.sql
+++ b/sql/test/SQLancer/Tests/sqlancer03.sql
@@ -306,6 +306,40 @@ case least(time '19:32:57', time '16:10:
then sql_min(0.7, 0.03) else 0.3 end), coalesce (case - (t0.c0) when
cast(v0.c2 as real) then abs(0.4) else 0.5 end, cast(t0.c0 as decimal)));
ROLLBACK;
+START TRANSACTION; --SIGFPE
+CREATE TABLE "sys"."t0" (
+ "c0" INTERVAL MONTH NOT NULL,
+ "c1" DOUBLE NOT NULL,
+ "c2" INTERVAL SECOND,
+ CONSTRAINT "t0_c0_pkey" PRIMARY KEY ("c0"),
+ CONSTRAINT "t0_c0_unique" UNIQUE ("c0"),
+ CONSTRAINT "t0_c2_unique" UNIQUE ("c2"),
+ CONSTRAINT "t0_c1_c2_c0_unique" UNIQUE ("c1", "c2", "c0")
+);
+COPY 19 RECORDS INTO "sys"."t0" FROM stdin USING DELIMITERS E'\t',E'\n','"';
+99360484 0.8104160489147377 NULL
+434886876 2003187499 NULL
+1868593144 0.605787503265435 -721601140.000
+1061127048 888903964 1369533413.000
+-320985624 0.7758661909853402 0.423
+-559098799 0.589701133253508 40364999.000
+1065193340 0.41440171821837046 1426163499.000
+1712034073 0.17915355536697286 -514338316.000
+1526621371 0.5435870488621911 -3797659.000
+130081317 0.4014279036721254 NULL
+2048481116 0.2107093605121693 1704117927.000
+-2067368391 0.5763887172257189 -452165183.000
+0 0.9286759330434932 NULL
+1021996113 0.737198399943565 NULL
+-713573774 0.3021457500334628 NULL
+-1680724988 280992707 NULL
+1411861402 83084647 NULL
+-1710710010 -90593292 -1255979722.000
+1844355385 0.6101178479960011 1733503642.000
+
+select cast(group_concat(all r'0.5787210717348131') as decimal) from t0 group
by - (abs(- (- (1061572565)))), least(t0.c0, least(cast(cast(0.09300166 as int)
as interval month), t0.c0));
+ROLLBACK;
+
START TRANSACTION; -- Bug 6924
CREATE TABLE "sys"."t0" ("a" INTEGER, "b" INTEGER NOT NULL, CONSTRAINT
"t0_a_b_unique" UNIQUE ("a","b"));
--This copy into must succeed
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
