Changeset: f66ed718ecc5 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=f66ed718ecc5
Modified Files:
sql/test/SQLancer/Tests/sqlancer05.sql
Branch: Oct2020
Log Message:
SQLancer: type mismatch daytime := bat[:daytime]. Enough bugs for now, time to
fix them
diffs (27 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
@@ -40,3 +40,23 @@ ON CASE WHEN ((((((((v0.c0)=(v0.c0)))OR(
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
