Changeset: 2d88eb094da2 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=2d88eb094da2
Modified Files:
sql/test/SQLancer/Tests/sqlancer06.sql
Branch: Oct2020
Log Message:
SQLancer query with wrong results
diffs (37 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
@@ -168,3 +168,33 @@ CREATE TABLE "sys"."t1" ("c0" BOOLEAN);
INSERT INTO t1(c0) VALUES(TRUE), ((EXISTS (SELECT DATE '1970-01-06' FROM t1))
BETWEEN (TRUE) AND ((1) IN (1)));
SELECT c0 from t1;
ROLLBACK;
+
+START TRANSACTION;
+CREATE TABLE "sys"."t0" ("c0" TIMESTAMP,"c1" CHARACTER LARGE OBJECT NOT
NULL,CONSTRAINT "t0_c1_pkey" PRIMARY KEY ("c1"),CONSTRAINT "t0_c0_c1_unique"
UNIQUE ("c0", "c1"));
+COPY 4 RECORDS INTO "sys"."t0" FROM stdin USING DELIMITERS E'\t',E'\n','"';
+"1970-01-23 07:23:51.000000" "1906903205"
+"1970-01-23 07:23:51.000000" "0.4338646653291859"
+"1970-01-23 07:23:51.000000" "-1882905169"
+"1970-01-23 07:23:51.000000" "*"
+
+CREATE TABLE "sys"."t1" ("c0" CHAR(343) NOT NULL,"c2" SMALLINT NOT
NULL,CONSTRAINT "t1_c0_pkey" PRIMARY KEY ("c0"),CONSTRAINT "t1_c0_unique"
UNIQUE ("c0"),CONSTRAINT "t1_c2_unique" UNIQUE ("c2"),CONSTRAINT
"t1_c2_c0_unique" UNIQUE ("c2", "c0"));
+COPY 3 RECORDS INTO "sys"."t1" FROM stdin USING DELIMITERS E'\t',E'\n','"';
+"+}TD" 1
+"" 3
+"541635614" 5
+
+CREATE TABLE "sys"."t2" ("c0" CHAR(343) NOT NULL,"c2" SMALLINT NOT NULL);
+
+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
+ -- 1
+ -- 1
+ -- 5
+ -- 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
