Changeset: d0f837f93c25 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=d0f837f93c25
Modified Files:
sql/test/SQLancer/Tests/sqlancer05.sql
Branch: Oct2020
Log Message:
Same SQLancer error on aggregate with join query
diffs (36 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,32 @@ 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;
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
