Changeset: 736dddf2de66 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=736dddf2de66
Modified Files:
sql/test/subquery/Tests/subquery5.sql
Branch: Jun2020
Log Message:
Even more crashes
diffs (19 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
@@ -234,6 +234,15 @@ SELECT (SELECT MAX(i1.i + i2.i) FROM int
SELECT (SELECT i2.i FROM integers i2) IN (SELECT MIN(i1.i)) FROM integers i1;
--error, more than one row returned by a subquery used as an expression
+SELECT (SELECT 5) NOT IN (SELECT MIN(i1.i)) FROM integers i1;
+ -- True
+
+SELECT (SELECT 1) IN (SELECT i1.i) FROM integers i1;
+ -- True
+ -- False
+ -- False
+ -- NULL
+
DROP FUNCTION evilfunction(INT);
DROP TABLE tbl_ProductSales;
DROP TABLE another_T;
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
