Changeset: 6b867e9dcc32 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=6b867e9dcc32
Modified Files:
sql/test/SQLancer/Tests/sqlancer05.sql
Branch: Oct2020
Log Message:
SQLancer query with wrong results
diffs (91 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
@@ -282,3 +282,87 @@ INSERT INTO t1(c1) VALUES(FALSE), (TRUE)
DELETE FROM t1 WHERE t1.c1;
CALL sys.reuse('sys', 't1');
DROP TABLE "sys"."t1";
+
+START TRANSACTION;
+CREATE TABLE "sys"."t0" ("c0" DATE NOT NULL,CONSTRAINT "t0_c0_pkey" PRIMARY
KEY ("c0"),CONSTRAINT "t0_c0_unique" UNIQUE ("c0"));
+COPY 4 RECORDS INTO "sys"."t0" FROM stdin USING DELIMITERS E'\t',E'\n','"';
+1970-01-10
+1970-01-08
+1970-01-11
+1970-01-04
+
+CREATE TABLE "sys"."t1" ("c0" BIGINT NOT NULL,"c1" BOOLEAN,CONSTRAINT
"t1_c0_pkey" PRIMARY KEY ("c0"));
+COPY 36 RECORDS INTO "sys"."t1" FROM stdin USING DELIMITERS E'\t',E'\n','"';
+23 false
+24 false
+25 false
+229738198 NULL
+1819118647 NULL
+26 false
+2058744872 NULL
+-168288931 NULL
+166463833 NULL
+-255018368 NULL
+27 false
+-233859923 false
+77211519 NULL
+28 false
+159399657 NULL
+29 false
+2026785942 NULL
+-418264598 NULL
+1594290070 NULL
+2030525887 NULL
+-841582890 NULL
+1837616768 NULL
+-6844300 NULL
+-950410411 false
+30 false
+-487156028 false
+2127505141 NULL
+-3355985 false
+31 false
+32 false
+-20002400 NULL
+658423972 NULL
+33 false
+34 false
+-721417633 NULL
+132893186 NULL
+
+CREATE TABLE "sys"."t2" ("c0" DATE NOT NULL);
+COPY 26 RECORDS INTO "sys"."t2" FROM stdin USING DELIMITERS E'\t',E'\n','"';
+1970-01-25
+1970-01-04
+1970-01-07
+1970-01-02
+1970-01-21
+1970-01-22
+1970-01-01
+1970-01-12
+1970-01-21
+1970-01-04
+1970-01-12
+1970-01-21
+1970-01-10
+1970-01-18
+1970-01-24
+1970-01-03
+1970-01-10
+1970-01-11
+1970-01-01
+1970-01-08
+1970-01-01
+1970-01-11
+1970-01-23
+1970-01-07
+1970-01-02
+1970-01-23
+
+SELECT t1.c1 FROM t1, t2 NATURAL JOIN t0 WHERE (CAST((TIME '15:03:17') NOT IN
(TIME '11:36:59', TIME '21:14:10',
+TIME '01:03:49') AS INT)) BETWEEN ASYMMETRIC (t1.c0) AND (t1.c0);
+ -- empty
+SELECT CAST(SUM(count) AS BIGINT) FROM (SELECT CAST((CAST((TIME '15:03:17')
NOT IN (TIME '11:36:59', TIME '21:14:10',
+TIME '01:03:49') AS INT)) BETWEEN ASYMMETRIC (t1.c0) AND (t1.c0) AS INT) as
count FROM t1, t2 NATURAL JOIN t0) as res;
+ -- 0
+ROLLBACK;
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
