Changeset: 0d10d8e624a5 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=0d10d8e624a5
Modified Files:
sql/test/SQLancer/Tests/sqlancer06.sql
Branch: Oct2020
Log Message:
SQLancer: inputs not the same size. Enough bugs for now
diffs (38 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
@@ -53,3 +53,34 @@ select cast(sum(count) as bigint) from (
on (t0.c1) between symmetric (t1.c1) and (((-
(-1063131904))&(coalesce(-569972440, 1845997183))))) as res;
-- NULL
ROLLBACK;
+
+START TRANSACTION;
+CREATE TABLE "sys"."t0" ("c0" TIMESTAMP NOT NULL,CONSTRAINT "t0_c0_pkey"
PRIMARY KEY ("c0"),CONSTRAINT "t0_c0_unique" UNIQUE ("c0"));
+COPY 3 RECORDS INTO "sys"."t0" FROM stdin USING DELIMITERS E'\t',E'\n','"';
+"1970-01-12 10:04:08.000000"
+"1970-01-06 03:09:33.000000"
+"1970-01-19 10:03:56.000000"
+
+CREATE TABLE "sys"."t1" ("c0" TIMESTAMP);
+COPY 3 RECORDS INTO "sys"."t1" FROM stdin USING DELIMITERS E'\t',E'\n','"';
+"1970-01-16 15:26:07.000000"
+"1970-01-21 09:11:00.000000"
+"1969-12-24 08:07:10.000000"
+
+CREATE TABLE "sys"."t2" ("c0" INTERVAL MONTH,"c1" DOUBLE,"c2" BOOLEAN);
+COPY 4 RECORDS INTO "sys"."t2" FROM stdin USING DELIMITERS E'\t',E'\n','"';
+1293946112 0.3251224351379446 true
+1293946112 0.3251224351379446 true
+540568573 NULL false
+NULL NULL false
+
+SELECT 1 FROM t2 LEFT JOIN t0 ON CASE CAST(t2.c0 AS VARCHAR(32)) WHEN
CAST(t2.c2 AS VARCHAR(32)) THEN 4 WHEN COALESCE('a', 'b') THEN 3 END IS NOT
NULL;
+ -- 1
+ -- 1
+ -- 1
+ -- 1
+SELECT CAST(SUM(count) AS BIGINT) FROM (SELECT CAST(t2.c2 AS INT) as count
FROM t2 LEFT OUTER JOIN t0 ON (CASE CAST(t2.c0 AS VARCHAR(32)) WHEN CAST('*D'
AS VARCHAR(32)) THEN CASE 'u--'
+WHEN 'Q' THEN 0.81 END WHEN CAST(t2.c2 AS VARCHAR(32)) THEN CASE 51854410 WHEN
0.6132552 THEN 134188918 END WHEN COALESCE('鈋', 'Nb|k', 's{%g.8Bj') THEN
CAST(571120738 AS INT)
+ELSE CAST(0.13 AS REAL) END) IS NOT NULL CROSS JOIN (SELECT ALL
COALESCE(t1.c0, t0.c0) FROM t0, t1) AS sub0) as res;
+ -- 54
+ROLLBACK;
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
