Changeset: d10c9e35a11c for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/d10c9e35a11c
Modified Files:
        sql/test/SQLancer/Tests/sqlancer23.test
Branch: default
Log Message:

Next crash, missing error message


diffs (27 lines):

diff --git a/sql/test/SQLancer/Tests/sqlancer23.test 
b/sql/test/SQLancer/Tests/sqlancer23.test
--- a/sql/test/SQLancer/Tests/sqlancer23.test
+++ b/sql/test/SQLancer/Tests/sqlancer23.test
@@ -133,7 +133,6 @@ SELECT 1 FROM (SELECT TRUE) v0(c0) WHERE
 ----
 1
 
-# this one is right
 query I nosort
 SELECT CAST(SUM(count) AS BIGINT) FROM (SELECT CAST(NOT EXISTS (SELECT v0.c0 
FROM (SELECT 1 WHERE FALSE)
 x(x)) = TRUE AS INT) as count FROM (SELECT TRUE) v0(c0)) as res
@@ -202,3 +201,15 @@ SELECT 1 FROM (SELECT 1) x(x) JOIN (SELE
 
 statement error 42000!SELECT: aggregate functions not allowed in JOIN 
conditions
 SELECT 1 FROM (SELECT 1) x(x) JOIN (SELECT 1) y(y) ON (SELECT 1 WHERE EXISTS 
(SELECT max(x.x)))
+
+statement error 42000!MIN: aggregate functions cannot be nested
+SELECT (SELECT 1 FROM (SELECT 1) x(x) HAVING min((SELECT 1 HAVING min(x.x + 
y.y) > 0))) FROM (SELECT 1) y(y)
+
+statement error 42000!MIN: aggregate functions cannot be nested
+SELECT (SELECT 1 FROM (SELECT 1) x(x) HAVING min((SELECT min(x.x + y.y)))) 
FROM (SELECT 1) y(y)
+
+statement error 42000!MIN: aggregate functions cannot be nested
+SELECT (SELECT 1 FROM (SELECT 1) x(x) HAVING min(min(x.x + y.y))) FROM (SELECT 
1) y(y)
+
+statement error 42000!MIN: aggregate functions cannot be nested
+SELECT (SELECT min(min(x.x + y.y)) FROM (SELECT 1) x(x)) FROM (SELECT 1) y(y)
_______________________________________________
checkin-list mailing list -- checkin-list@monetdb.org
To unsubscribe send an email to checkin-list-le...@monetdb.org

Reply via email to