Changeset: 3842e047040f for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=3842e047040f
Branch: Oct2020
Log Message:
merged
diffs (56 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
@@ -11,3 +11,52 @@ INSERT INTO t1(c0) VALUES(INTERVAL '1448
DELETE FROM t1 WHERE CAST(TRUE AS BOOLEAN);
-- all rows deleted
DROP TABLE sys.t1;
+
+START TRANSACTION;
+CREATE TABLE "sys"."t0" ("c0" TIMESTAMP,"c1" INTERVAL MONTH,CONSTRAINT
"t0_c1_unique" UNIQUE ("c1"));
+CREATE TABLE "sys"."t1" ("c0" BOOLEAN, "c1" DECIMAL(18,3) NOT NULL);
+COPY 9 RECORDS INTO "sys"."t1" FROM stdin USING DELIMITERS E'\t',E'\n','"';
+NULL 0.526
+true 0.259
+true 0.382
+NULL 0.994
+NULL 0.101
+NULL 0.713
+NULL 0.433
+NULL 0.899
+NULL 0.239
+
+CREATE TABLE "sys"."t2" ("c0" BOOLEAN, "c1" DECIMAL(18,3));
+COPY 3 RECORDS INTO "sys"."t2" FROM stdin USING DELIMITERS E'\t',E'\n','"';
+NULL 0.692
+NULL 0.860
+NULL 0.230
+
+SELECT max(t2.c1) FROM t1 LEFT OUTER JOIN t2 ON CASE WHEN t2.c0 < t1.c0 OR
t1.c0 THEN t1.c0 WHEN t1.c0 THEN t1.c0 END;
+ -- 0.860
+create view v0(c0) as (select all 7.948668E7 from t1) with check option;
+SELECT max(t2.c1) FROM t0, t1 CROSS JOIN v0 LEFT OUTER JOIN t2
+ON CASE WHEN
((((((((v0.c0)=(v0.c0)))OR(((t1.c0)>=(t1.c0)))))AND(((t2.c0)<(t1.c0)))))OR(((((t1.c0)AND(t1.c0)))AND(t1.c0))))
+THEN t1.c0 WHEN COALESCE(COALESCE(TRUE, t2.c0, t1.c0), CASE t1.c1 WHEN t2.c1
THEN t2.c0 WHEN t1.c1 THEN t2.c0 ELSE t1.c0 END)
+THEN t2.c0 WHEN t1.c0 THEN t1.c0 END;
+rollback;
+
+START TRANSACTION;
+CREATE TABLE t0("c1" INTEGER NOT NULL,CONSTRAINT "t0_c1_pkey" PRIMARY KEY
("c1"),CONSTRAINT "t0_c1_unique" UNIQUE ("c1"));
+COPY 8 RECORDS INTO t0 FROM stdin USING DELIMITERS E'\t',E'\n','"';
+262015489
+-1667887296
+1410307212
+1073218199
+-167204307
+1394786866
+1112194034
+2140251980
+
+SELECT 1 FROM (select time '12:43:09' from t0) as v0(c0) RIGHT OUTER JOIN
(SELECT INTERVAL '2' SECOND FROM t0) AS sub0 ON
+TIME '07:04:19' BETWEEN CASE 'b' WHEN 'a' THEN v0.c0 ELSE v0.c0 END AND v0.c0;
+ --8 rows of 1
+create view v0(c0, c1) as (select all time '12:43:09', interval '1251003346'
second from t0) with check option;
+SELECT count(ALL - (CAST(NULL AS INT))) FROM v0 RIGHT OUTER JOIN (SELECT
INTERVAL '1380374779' SECOND FROM t0) AS sub0 ON
+COALESCE(TRUE, (TIME '07:04:19') BETWEEN SYMMETRIC (CASE r'漈' WHEN r'T㊆ßwU.H'
THEN v0.c0 ELSE v0.c0 END) AND (v0.c0));
+rollback;
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
