Changeset: 6fdc844c216e for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=6fdc844c216e
Modified Files:
sql/test/subquery/Tests/subquery5.sql
sql/test/subquery/Tests/subquery5.stable.out
Branch: Jun2020
Log Message:
More queries crashing for our own entertainment
diffs (57 lines):
diff --git a/sql/test/subquery/Tests/subquery5.sql
b/sql/test/subquery/Tests/subquery5.sql
--- a/sql/test/subquery/Tests/subquery5.sql
+++ b/sql/test/subquery/Tests/subquery5.sql
@@ -252,6 +252,26 @@ SELECT CORR((SELECT i1.i FROM integers i
SELECT i1.i FROM integers i1 WHERE (SELECT TRUE EXCEPT SELECT i1.i > 0);
-- NULL
+SELECT (((SELECT MIN(i2.i + i1.i) FROM integers i2) IN (SELECT i1.i)) =
EXISTS(SELECT i1.i)) = ANY(SELECT MIN(i1.i) = 1) FROM integers i1 GROUP BY i1.i;
+ -- NULL
+ -- True
+ -- True
+ -- False
+
+SELECT (((SELECT MIN(i2.i + i1.i) FROM integers i2) IN (SELECT i1.i)) =
EXISTS(SELECT i1.i)) = ANY(SELECT MIN(i1.i) = 1) FROM integers i1 GROUP BY i1.i
+HAVING (((SELECT MIN(i2.i + i1.i) FROM integers i2) IN (SELECT i1.i)) =
EXISTS(SELECT i1.i)) = ANY(SELECT MIN(i1.i) = 1);
+ -- True
+ -- True
+
+SELECT (VALUES (SUM(i1.i)),(AVG(i1.i)) INTERSECT VALUES(AVG(i1.i))) FROM
integers i1;
+ -- 2.0
+
+SELECT SUM(i1.i) FROM integers i1 HAVING (VALUES(SUM(i1.i)),(AVG(i1.i))
INTERSECT VALUES(AVG(i1.i))) > 0;
+ -- 6
+
+SELECT MAX(i1.i) FROM integers i1 HAVING (VALUES((AVG(i1.i))) EXCEPT
VALUES(AVG(i1.i))) <> 0;
+ --empty
+
DROP FUNCTION evilfunction(INT);
DROP TABLE tbl_ProductSales;
DROP TABLE another_T;
diff --git a/sql/test/subquery/Tests/subquery5.stable.out
b/sql/test/subquery/Tests/subquery5.stable.out
--- a/sql/test/subquery/Tests/subquery5.stable.out
+++ b/sql/test/subquery/Tests/subquery5.stable.out
@@ -264,6 +264,23 @@ stdout of test 'subquery5` in directory
% int # type
% 1 # length
[ NULL ]
+#SELECT (((SELECT MIN(i2.i + i1.i) FROM integers i2) IN (SELECT i1.i)) =
EXISTS(SELECT i1.i)) = ANY(SELECT MIN(i1.i) = 1) FROM integers i1 GROUP BY i1.i;
+% .%50 # table_name
+% %50 # name
+% boolean # type
+% 5 # length
+[ false ]
+[ true ]
+[ true ]
+[ NULL ]
+#SELECT (((SELECT MIN(i2.i + i1.i) FROM integers i2) IN (SELECT i1.i)) =
EXISTS(SELECT i1.i)) = ANY(SELECT MIN(i1.i) = 1) FROM integers i1 GROUP BY i1.i
+#HAVING (((SELECT MIN(i2.i + i1.i) FROM integers i2) IN (SELECT i1.i)) =
EXISTS(SELECT i1.i)) = ANY(SELECT MIN(i1.i) = 1);
+% .%62 # table_name
+% %62 # name
+% boolean # type
+% 5 # length
+[ true ]
+[ true ]
#DROP FUNCTION evilfunction(INT);
#DROP TABLE tbl_ProductSales;
#DROP TABLE another_T;
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
