Changeset: 8e67fcf7cf07 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=8e67fcf7cf07
Modified Files:
sql/test/SQLancer/Tests/sqlancer05.sql
Branch: Oct2020
Log Message:
SQLancer: algebra.join undefined
diffs (24 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
@@ -60,3 +60,20 @@ create view v0(c0, c1) as (select all ti
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;
+
+START TRANSACTION;
+CREATE TABLE "sys"."t2" (
+ "c0" BOOLEAN,
+ "c1" DOUBLE NOT NULL,
+ CONSTRAINT "t2_c1_pkey" PRIMARY KEY ("c1"),
+ CONSTRAINT "t2_c0_c1_unique" UNIQUE ("c0", "c1")
+);
+COPY 3 RECORDS INTO "sys"."t2" FROM stdin USING DELIMITERS E'\t',E'\n','"';
+NULL 0.385788843525793
+true 0.6696036757274413
+false 0.3589261452091549
+
+INSERT INTO t2(c0) VALUES (CASE WHEN TRUE THEN TIMESTAMP '1970-01-11 13:04:02'
END BETWEEN TIMESTAMP '1970-01-05 05:04:47' AND TIMESTAMP '1970-01-01
20:00:35');
+INSERT INTO t2(c0) VALUES(NOT ((CASE WHEN TRUE THEN TIMESTAMP '1970-01-11
13:04:02' ELSE TIMESTAMP '1970-01-02 23:25:05' END)
+NOT BETWEEN SYMMETRIC (COALESCE(TIMESTAMP '1969-12-30 12:07:22', TIMESTAMP
'1970-01-05 05:04:47')) AND (CASE WHEN TRUE THEN TIMESTAMP '1970-01-01
20:00:35' END)));
+ROLLBACK;
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
