Changeset: 77ae2ef5e33a for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/77ae2ef5e33a Modified Files: sql/test/BugTracker-2009/Tests/limit_in_subquery.SF-2620437.test sql/test/BugTracker/Tests/between_with_column.SF-1959410.test sql/test/SQLancer/Tests/sqlancer17.test sql/test/subquery/Tests/any.test sql/test/subquery/Tests/correlated.test Branch: clean_parser Log Message:
approved output diffs (91 lines): diff --git a/sql/test/BugTracker-2009/Tests/limit_in_subquery.SF-2620437.test b/sql/test/BugTracker-2009/Tests/limit_in_subquery.SF-2620437.test --- a/sql/test/BugTracker-2009/Tests/limit_in_subquery.SF-2620437.test +++ b/sql/test/BugTracker-2009/Tests/limit_in_subquery.SF-2620437.test @@ -1,3 +1,3 @@ -statement error -select id from tables where id not in (select id from columns limit 10) - +query I +select id from tables where id not in (select id from columns limit 10) and false; +---- diff --git a/sql/test/BugTracker/Tests/between_with_column.SF-1959410.test b/sql/test/BugTracker/Tests/between_with_column.SF-1959410.test --- a/sql/test/BugTracker/Tests/between_with_column.SF-1959410.test +++ b/sql/test/BugTracker/Tests/between_with_column.SF-1959410.test @@ -4,8 +4,9 @@ create table t1959410d (id int) statement ok create table t1959410e (age float, yea int) -statement error +query I select yea from t1959410d, t1959410e where age between 0.03 and id < 30 +---- statement ok drop table t1959410d diff --git a/sql/test/SQLancer/Tests/sqlancer17.test b/sql/test/SQLancer/Tests/sqlancer17.test --- a/sql/test/SQLancer/Tests/sqlancer17.test +++ b/sql/test/SQLancer/Tests/sqlancer17.test @@ -712,20 +712,23 @@ SELECT 1 FROM (SELECT 'a') vx(vc0) HAVIN statement error 42000!SELECT: cannot use non GROUP BY column 'vx.vc0' in query results without an aggregate function SELECT MIN(2) IS NULL FROM (SELECT 3) vx(vc0) HAVING vx.vc0 > 1 -statement error 42000!SELECT: cannot use non GROUP BY column 'vx.vc0' in query results without an aggregate function +query I SELECT vx.vc0 FROM (SELECT 3) vx(vc0) HAVING MIN(2) IS NULL +---- statement error 42000!SELECT: cannot use non GROUP BY column 'vx.vc0' in query results without an aggregate function SELECT 1 IN (MIN(2)) FROM (SELECT 3) vx(vc0) HAVING vx.vc0 > 1 -statement error 42000!SELECT: cannot use non GROUP BY column 'vx.vc0' in query results without an aggregate function +query I SELECT vx.vc0 FROM (SELECT 3) vx(vc0) HAVING 1 IN (MIN(2)) +---- statement error 42000!SELECT: cannot use non GROUP BY column 'vx.vc0' in query results without an aggregate function SELECT MIN(2) > 2 FROM (SELECT TRUE) vx(vc0) HAVING vx.vc0 -statement error 42000!SELECT: cannot use non GROUP BY column 'vx.vc0' in query results without an aggregate function +query I SELECT vx.vc0 FROM (SELECT TRUE) vx(vc0) HAVING MIN(2) > 2 +---- statement error 42000!SELECT: cannot use non GROUP BY column 'vx.vc0' in query results without an aggregate function SELECT MIN(2) > 2, vx.vc0 FROM (SELECT 3) vx(vc0) diff --git a/sql/test/subquery/Tests/any.test b/sql/test/subquery/Tests/any.test --- a/sql/test/subquery/Tests/any.test +++ b/sql/test/subquery/Tests/any.test @@ -156,8 +156,17 @@ 1 3 1 -statement error +query II nosort SELECT i, i >= ANY(SELECT i1.i FROM integers i1, integers i2, integers i3, integers i4, integers i5, integers i6 WHERE i1.i IS NOT NULL AND i1.i <> 1 LIMIT 1) FROM integers ORDER BY i +---- +NULL +NULL +1 +0 +2 +1 +3 +1 statement error 42000!SELECT: subquery must return only one column SELECT 1 >= ANY(SELECT 2, 3) diff --git a/sql/test/subquery/Tests/correlated.test b/sql/test/subquery/Tests/correlated.test --- a/sql/test/subquery/Tests/correlated.test +++ b/sql/test/subquery/Tests/correlated.test @@ -367,8 +367,10 @@ SELECT i % 2 AS j, CAST(SUM(i) AS BIGINT 1 4 -statement error +query I nosort SELECT CAST((SELECT i+SUM(i1.i) FROM integers WHERE i=1 LIMIT 1) AS BIGINT) FROM integers i1 +---- +7 query I nosort SELECT CAST((SELECT SUM(i)+SUM(i1.i) FROM integers) AS BIGINT) FROM integers i1 ORDER BY 1 _______________________________________________ checkin-list mailing list -- checkin-list@monetdb.org To unsubscribe send an email to checkin-list-le...@monetdb.org
