Changeset: 55417acc94cb for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=55417acc94cb
Modified Files:
sql/test/SQLancer/Tests/sqlancer11.sql
Branch: Oct2020
Log Message:
Next bug, issue with exists rewrite?
diffs (21 lines):
diff --git a/sql/test/SQLancer/Tests/sqlancer11.sql
b/sql/test/SQLancer/Tests/sqlancer11.sql
--- a/sql/test/SQLancer/Tests/sqlancer11.sql
+++ b/sql/test/SQLancer/Tests/sqlancer11.sql
@@ -111,3 +111,17 @@ SELECT t1.c2 FROM t1 WHERE CASE 3 WHEN (
SELECT CASE 3 WHEN ((SELECT 0.48) INTERSECT DISTINCT (SELECT -1.2)) THEN FALSE
ELSE TRUE END FROM t1;
-- 7 values
ROLLBACK;
+
+START TRANSACTION;
+CREATE TABLE "t0" ("c0" SMALLINT NOT NULL,"c2" INTEGER);
+CREATE TABLE "t1" ("c0" SMALLINT NOT NULL,"c2" SMALLINT);
+INSERT INTO "t1" VALUES (4, NULL),(3, 4),(3, 5),(2, NULL),(6, NULL),(6,
NULL),(6, NULL),(6, NULL),(6, NULL),(6, NULL),(6, NULL),(6, NULL),(6, NULL),(6,
NULL),(3, NULL),(5, NULL),
+(0, 8),(3, NULL),(8, 7),(-1, 6),(3, -3),(7, 7),(0, 1),(8, NULL),(9, NULL),(9,
NULL),(-1, NULL),(2, NULL),(7, 8),(1, 2);
+CREATE TABLE "t2" ("c0" SMALLINT);
+INSERT INTO "t2" VALUES (NULL), (NULL), (0);
+
+SELECT t1.c0 FROM t1 FULL OUTER JOIN (SELECT 3.3 FROM t2) AS sub0 ON true
WHERE (EXISTS (SELECT 1)) OR greatest(TRUE, FALSE);
+ -- 90 rows
+SELECT (EXISTS (SELECT 1)) OR greatest(TRUE, FALSE) FROM t1 FULL OUTER JOIN
(SELECT 3.3 FROM t2) AS sub0 ON true;
+ -- 90 rows
+ROLLBACK;
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
