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
