Changeset: 39dafcef093d for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=39dafcef093d
Modified Files:
sql/test/SQLancer/Tests/sqlancer05.sql
Branch: Oct2020
Log Message:
SQLancer: BATproject2: does not match always
diffs (26 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
@@ -191,3 +191,22 @@ SELECT ALL sum(ALL t1.c1) as agg0 FROM v
) as asdf;
-- 0
ROLLBACK;
+
+START TRANSACTION;
+CREATE TABLE "t1" ("c0" INTERVAL MONTH NOT NULL,CONSTRAINT "t1_c0_pkey"
PRIMARY KEY ("c0"));
+COPY 5 RECORDS INTO "t1" FROM stdin USING DELIMITERS E'\t',E'\n','"';
+141227804
+1365727954
+498933006
+1181578353
+651226237
+
+SELECT CAST(SUM(count) AS BIGINT) FROM (SELECT CASE INTERVAL '-1' MONTH WHEN
INTERVAL '2' MONTH
+THEN NOT t1.c0 BETWEEN t1.c0 AND t1.c0 ELSE t1.c0 < CASE FALSE WHEN TRUE THEN
t1.c0 ELSE t1.c0 END END as count FROM t1)
+as res;
+ -- 0
+SELECT CAST(SUM(count) AS BIGINT) FROM (SELECT CAST(CASE INTERVAL '-803989404'
MONTH WHEN INTERVAL '795326851' MONTH
+THEN NOT ((t1.c0) BETWEEN ASYMMETRIC (t1.c0) AND (t1.c0)) ELSE ((t1.c0)<(CASE
FALSE WHEN TRUE THEN t1.c0 ELSE t1.c0 END)) END AS INT) as count FROM t1)
+as res;
+ -- 0
+ROLLBACK;
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
