Changeset: a6c3dcdc1186 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/a6c3dcdc1186 Modified Files: sql/test/subquery/Tests/all.test sql/test/subquery/Tests/any.test sql/test/subquery/Tests/any_all.test sql/test/subquery/Tests/correlated.test sql/test/subquery/Tests/exists.test sql/test/subquery/Tests/scalar.test sql/test/subquery/Tests/subquery0.test sql/test/subquery/Tests/subquery2.test sql/test/subquery/Tests/subquery3.test sql/test/subquery/Tests/subquery4.test sql/test/subquery/Tests/subquery5.test sql/test/subquery/Tests/subquery6.test sql/test/subquery/Tests/subquery9.test testing/mktest.py Branch: Jul2021 Log Message:
Ouput number of affected rows and expected error message on automatic test conversion. This will help on the continuous integration and detect bugs on feature branches. And yes, this should be on Jul2021 branch. diffs (truncated from 5395 to 300 lines): diff --git a/sql/test/subquery/Tests/all.test b/sql/test/subquery/Tests/all.test --- a/sql/test/subquery/Tests/all.test +++ b/sql/test/subquery/Tests/all.test @@ -1,23 +1,23 @@ statement ok CREATE TABLE integers(i INTEGER) -statement ok +statement ok rowcount 4 INSERT INTO integers VALUES (1), (2), (3), (NULL) query I rowsort SELECT i FROM integers WHERE i >= ALL(SELECT i FROM integers) ---- -query II rowsort +query IT nosort SELECT i, i >= ALL(SELECT i FROM integers) FROM integers ORDER BY i ---- -1 -0 -2 -0 -3 NULL NULL +1 +False +2 +False +3 NULL query I rowsort @@ -25,17 +25,17 @@ SELECT i FROM integers WHERE i >= ALL(SE ---- 3 -query II rowsort +query IT nosort SELECT i, i >= ALL(SELECT i FROM integers WHERE i IS NOT NULL) FROM integers ORDER BY i ---- -1 -0 -2 -0 -3 -1 NULL NULL +1 +False +2 +False +3 +True query I rowsort SELECT i FROM integers WHERE i >= ALL(SELECT i FROM integers WHERE i IS NOT NULL) @@ -82,135 +82,136 @@ query I rowsort SELECT i FROM integers WHERE i <> ALL(SELECT i FROM integers WHERE i IS NOT NULL) ---- -query I rowsort +query I nosort SELECT i FROM integers WHERE i <> ALL(SELECT i FROM integers WHERE i>10) ORDER BY i ---- +NULL 1 2 3 -NULL -query II rowsort +query IT nosort SELECT i, i <> ALL(SELECT i FROM integers WHERE i>10) FROM integers ORDER BY i ---- -1 +NULL +True 1 +True 2 -1 +True 3 -1 -NULL -1 +True -query II rowsort +query IT nosort SELECT i, i > ANY(SELECT i FROM integers WHERE i>10) FROM integers ORDER BY i ---- +NULL +False 1 -0 +False 2 -0 +False 3 -0 -NULL -0 +False -query II rowsort +query IT nosort SELECT i, i = ANY(SELECT i FROM integers WHERE i>10) FROM integers ORDER BY i ---- +NULL +False 1 -0 +False 2 -0 +False 3 -0 -NULL -0 +False -query II rowsort +query IT nosort SELECT i, i >= ANY(SELECT i FROM integers WHERE i>10) FROM integers ORDER BY i ---- +NULL +False 1 -0 +False 2 -0 +False 3 -0 -NULL -0 +False -query II rowsort +query IT nosort SELECT i, i <= ANY(SELECT i FROM integers WHERE i>10) FROM integers ORDER BY i ---- +NULL +False 1 -0 +False 2 -0 +False 3 -0 -NULL -0 +False -query II rowsort +query IT nosort SELECT i, i < ANY(SELECT i FROM integers WHERE i>10) FROM integers ORDER BY i ---- +NULL +False 1 -0 +False 2 -0 +False 3 -0 -NULL -0 +False -query II rowsort +query IT nosort SELECT i, i <> ANY(SELECT i FROM integers WHERE i>10) FROM integers ORDER BY i ---- +NULL +False 1 -0 +False 2 -0 +False 3 -0 -NULL -0 +False -query II rowsort +query TI nosort SELECT i >= ALL(SELECT i FROM integers WHERE i IS NOT NULL) AS k, CAST(SUM(i) AS BIGINT) FROM integers GROUP BY k ORDER BY k ---- -0 -3 -1 -3 NULL NULL +False +3 +True +3 -query I rowsort +query I nosort SELECT CAST(SUM(i) AS BIGINT) FROM integers GROUP BY (i >= ALL(SELECT i FROM integers WHERE i IS NOT NULL)) ORDER BY 1 ---- +NULL 3 3 -NULL -query II rowsort +query TI nosort SELECT i >= ALL(SELECT MIN(i) FROM integers WHERE i IS NOT NULL) AS k, CAST(SUM(i) AS BIGINT) FROM integers GROUP BY k ORDER BY k ---- -1 -6 NULL NULL +True +6 -query II rowsort +query II nosort SELECT i, CAST(SUM(CASE WHEN (i >= ALL(SELECT i FROM integers WHERE i=2)) THEN 1 ELSE 0 END) AS BIGINT) FROM integers GROUP BY i ORDER BY i ---- +NULL +0 1 0 2 1 3 1 -NULL -0 statement ok DROP TABLE integers + 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 @@ -1,7 +1,7 @@ statement ok CREATE TABLE integers(i INTEGER) -statement ok +statement ok rowcount 4 INSERT INTO integers VALUES (1), (2), (3), (NULL) query I rowsort @@ -17,53 +17,53 @@ SELECT i FROM integers WHERE i > ANY(SEL 2 3 -query II rowsort +query IT nosort SELECT i, i > ANY(SELECT i FROM integers) FROM integers ORDER BY i ---- +NULL +NULL 1 NULL 2 -1 +True 3 -1 -NULL -NULL +True -query II rowsort +query IT nosort SELECT i, i > ANY(SELECT i FROM integers WHERE i IS NOT NULL) FROM integers ORDER BY i ---- -1 -0 -2 -1 -3 -1 NULL NULL +1 +False _______________________________________________ checkin-list mailing list [email protected] https://www.monetdb.org/mailman/listinfo/checkin-list
