Changeset: dbd49b5acddf for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=dbd49b5acddf
Modified Files:
sql/test/subquery/Tests/subquery2.sql
Branch: Nov2019
Log Message:
Correlated subquery crashing
diffs (45 lines):
diff --git a/sql/test/subquery/Tests/subquery2.sql
b/sql/test/subquery/Tests/subquery2.sql
--- a/sql/test/subquery/Tests/subquery2.sql
+++ b/sql/test/subquery/Tests/subquery2.sql
@@ -106,7 +106,7 @@ GROUP BY col1;
-- TODO incorrect empty result
SELECT NOT col2 <> ANY (SELECT 20 FROM tbl_ProductSales GROUP BY ColID HAVING
NOT MAX(col1) <> col1 * AVG(col1 + ColID) * ColID) FROM another_T GROUP BY
col1, col2, col5, col8;
-/*
+/* BROKEN
SELECT
NOT -SUM(col2) NOT IN (SELECT ColID FROM tbl_ProductSales GROUP BY
ColID HAVING SUM(ColID - col8) <> col5),
NOT col5 = ALL (SELECT 1 FROM tbl_ProductSales HAVING MAX(col8) > 2 AND
MIN(col8) IS NOT NULL),
@@ -220,6 +220,32 @@ FROM another_T t1;
-- NULL
SELECT
+ CASE WHEN 1 IN (SELECT MAX(col7) UNION ALL (SELECT MIN(ColID) FROM
tbl_ProductSales INNER JOIN another_T t2 ON t2.col5 = t2.col1)) THEN 2 ELSE
NULL END
+FROM another_T t1;
+ -- NULL
+ -- NULL
+ -- NULL
+ -- NULL
+
+/* BROKEN
+SELECT
+ CASE WHEN 1 IN (SELECT (SELECT MAX(col7))) THEN 2 ELSE NULL END
+FROM another_T t1;
+*/
+ -- NULL
+ -- NULL
+ -- NULL
+ -- NULL
+
+SELECT
+ CASE WHEN 1 IN (SELECT (SELECT MIN(ColID) FROM tbl_ProductSales INNER
JOIN another_T t2 ON t2.col5 = t2.col1) UNION ALL (SELECT MAX(col7))) THEN 2
ELSE NULL END
+FROM another_T t1;
+ -- NULL
+ -- NULL
+ -- NULL
+ -- NULL
+
+SELECT
CASE WHEN NOT col1 NOT IN (SELECT (SELECT MAX(col7)) UNION (SELECT
MIN(ColID) FROM tbl_ProductSales LEFT JOIN another_T t2 ON t2.col5 = t1.col1))
THEN 1 ELSE 2 END
FROM another_T t1
GROUP BY col1;
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
