MonetDB: Oct2020 - SQLancer: BATproject2: does not match always

[Pedro Ferreira]

Changeset: c04fc6e7e756 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=c04fc6e7e756
Modified Files:
        sql/test/SQLancer/Tests/sqlancer06.sql
Branch: Oct2020
Log Message:

SQLancer: BATproject2: does not match always


diffs (32 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
@@ -187,7 +187,10 @@ CREATE TABLE "sys"."t2" ("c0" CHAR(343) 
 
 SELECT t0.c1 FROM t0, t1 FULL OUTER JOIN t2 ON TRUE WHERE (t0.c1) BETWEEN 
SYMMETRIC ('p%AY') AND (t1.c0);
        -- 1906903205
+       -- 1906903205
        -- 0.4338646653291859
+       -- 0.4338646653291859
+       -- -1882905169
        -- -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);
@@ -206,3 +209,17 @@ DELETE FROM t1 WHERE NOT (CAST(((8545177
 INSERT INTO t1(c0) VALUES(TIME '09:41:58');
 CALL sys.vacuum('sys', 't1');
 DROP TABLE t1;
+
+CREATE TABLE t0(c0 TIME NULL PRIMARY KEY, c1 TIMESTAMP);
+CREATE TABLE IF NOT EXISTS t1(c0 TIMESTAMP, c1 INTERVAL SECOND);
+CREATE TABLE t2(LIKE t1); 
+INSERT INTO t1(c1) VALUES(INTERVAL '1520729315' SECOND);
+CREATE ORDERED INDEX i0 ON t0 (c0);
+INSERT INTO t2(c0) VALUES(TIMESTAMP '1970-01-02 17:11:53');
+CREATE UNIQUE INDEX i1 ON t0 (c0, c1);
+INSERT INTO t0(c0) VALUES(TIME '20:35:54');
+SELECT CAST(TIMESTAMP '1970-01-01 19:30:21' = ALL(SELECT DISTINCT t2.c0 FROM 
t1, t2) AS INT) as count FROM t2, t0 LEFT OUTER JOIN t1 ON NOT EXISTS (SELECT 
DISTINCT t2.c0 FROM t1, t0, t2);
+       -- 0
+DROP TABLE t0;
+DROP TABLE t1;
+DROP TABLE t2;
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list