Changeset: 846a3ad4e0f8 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=846a3ad4e0f8
Modified Files:
sql/test/SQLancer/Tests/sqlancer06.sql
Branch: Oct2020
Log Message:
Simplified version of buggy query
diffs (23 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
@@ -185,6 +185,11 @@ COPY 3 RECORDS INTO "sys"."t1" FROM stdi
CREATE TABLE "sys"."t2" ("c0" CHAR(343) NOT NULL,"c2" SMALLINT NOT NULL);
+SELECT t0.c1 FROM t0, t1 FULL OUTER JOIN t2 ON TRUE WHERE (t0.c1) BETWEEN
SYMMETRIC ('p%AY') AND (t1.c0);
+ -- 1906903205
+ -- 0.4338646653291859
+ -- -1882905169
+ -- *
SELECT t1.c2 FROM t0, t1 FULL OUTER JOIN t2 ON NOT (((TIME '03:59:32') IS
NULL) = TRUE) WHERE (t0.c1) NOT BETWEEN SYMMETRIC ('p%AY') AND (t1.c0);
-- 1
-- 1
@@ -194,7 +199,6 @@ SELECT t1.c2 FROM t0, t1 FULL OUTER JOIN
-- 5
-- 5
-- 5
-
SELECT CAST(SUM(count) AS BIGINT) FROM (SELECT ALL CAST((t0.c1) NOT BETWEEN
SYMMETRIC ('p%AY') AND (t1.c0) AS INT) as count FROM t0, t1 FULL OUTER JOIN t2
ON NOT (((TIME '03:59:32') IS NULL) = TRUE)) as res;
-- 8
ROLLBACK;
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
