Changeset: df8c087656cd for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=df8c087656cd
Modified Files:
sql/test/SQLancer/Tests/sqlancer06.sql
Branch: Oct2020
Log Message:
SQLancer assertion error at mergetable optimizer
diffs (26 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
@@ -34,3 +34,22 @@ INSERT INTO t2(c1) VALUES(68055641);
CREATE INDEX i1 ON t2 (c1);
INSERT INTO t2(c1) VALUES(1807763525);
DROP TABLE t2;
+
+START TRANSACTION;
+CREATE TABLE "sys"."t0" ("c0" DOUBLE,"c1" DOUBLE NOT NULL,CONSTRAINT
"t0_c1_c0_unique" UNIQUE ("c1", "c0"));
+COPY 8 RECORDS INTO "sys"."t0" FROM stdin USING DELIMITERS E'\t',E'\n','"';
+NULL 0.11556091558253245
+0.29659357385748286 68693719
+0.9191040589762235 0.5658689286027364
+NULL 0.1019666413117839
+NULL 0.64159659402381
+NULL 0.06945707167931647
+1696129939 1930440479
+0.291412016319756 0.19803645886665644
+
+CREATE TABLE "sys"."t1" ("c1" DOUBLE,CONSTRAINT "t1_c1_unique" UNIQUE ("c1"));
+
+select cast(sum(count) as bigint) from (select cast(not ((-307103413) in
(0.68224454, 0.9718348)) as int) as count from t0 right outer join t1
+on (t0.c1) between symmetric (t1.c1) and (((-
(-1063131904))&(coalesce(-569972440, 1845997183))))) as res;
+ -- NULL
+ROLLBACK;
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
