Changeset: 4ee554192e41 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=4ee554192e41
Modified Files:
sql/test/SQLancer/Tests/sqlancer05.sql
Branch: Oct2020
Log Message:
SQLancer query with wrong results
diffs (38 lines):
diff --git a/sql/test/SQLancer/Tests/sqlancer05.sql
b/sql/test/SQLancer/Tests/sqlancer05.sql
--- a/sql/test/SQLancer/Tests/sqlancer05.sql
+++ b/sql/test/SQLancer/Tests/sqlancer05.sql
@@ -210,3 +210,34 @@ THEN NOT ((t1.c0) BETWEEN ASYMMETRIC (t1
as res;
-- 0
ROLLBACK;
+
+START TRANSACTION;
+CREATE TABLE "sys"."t0" ("c0" DOUBLE, "c1" TIMESTAMP,
+ CONSTRAINT "t0_c0_unique" UNIQUE ("c0"),
+ CONSTRAINT "t0_c1_unique" UNIQUE ("c1"),
+ CONSTRAINT "t0_c0_c1_unique" UNIQUE ("c0", "c1"),
+ CONSTRAINT "t0_c0_fkey" FOREIGN KEY ("c0") REFERENCES "sys"."t0" ("c0")
+);
+COPY 4 RECORDS INTO "sys"."t0" FROM stdin USING DELIMITERS E'\t',E'\n','"';
+NULL "1970-01-19 09:37:48.000000"
+NULL "1970-01-25 15:39:05.000000"
+NULL "1970-01-25 02:16:22.000000"
+NULL "1970-01-20 18:57:37.000000"
+
+CREATE TABLE "sys"."t1" ("c0" DOUBLE,"c1" TIMESTAMP);
+COPY 5 RECORDS INTO "sys"."t1" FROM stdin USING DELIMITERS E'\t',E'\n','"';
+NULL "1970-01-17 22:34:50.000000"
+NULL "1970-01-21 20:17:49.000000"
+0.5197361696675626 NULL
+0.46979060080234214 NULL
+0.0047394257892724445 NULL
+
+SELECT t0.c1 FROM t0 WHERE (((((t0.c0) NOT IN (-1003666733, t0.c0))OR((t0.c0)
NOT BETWEEN SYMMETRIC (((14)*(10))) AND (- (75)))))OR('TRUE'));
+ -- 1970-01-19 09:37:48
+ -- 1970-01-25 15:39:05
+ -- 1970-01-25 02:16:22
+ -- 1970-01-20 18:57:37
+
+SELECT CAST(SUM(count) AS BIGINT) FROM (SELECT CAST((((((t0.c0) NOT IN (-10,
t0.c0))OR((t0.c0) NOT BETWEEN SYMMETRIC (((14)*(10))) AND (-
(756050096)))))OR('TRUE')) AS INT) as count FROM t0) as res;
+ -- 4
+ROLLBACK;
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
