Changeset: 379601b03a29 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/379601b03a29 Added Files: sql/test/2024/Tests/returning.test Modified Files: sql/test/2024/Tests/All Branch: returning Log Message:
add first tests for RETURNING clause diffs (79 lines): diff --git a/sql/test/2024/Tests/All b/sql/test/2024/Tests/All --- a/sql/test/2024/Tests/All +++ b/sql/test/2024/Tests/All @@ -1,4 +1,1 @@ -groupby_primary_key_project_unique_key -distinct_from -check -nextafter +returning diff --git a/sql/test/2024/Tests/returning.test b/sql/test/2024/Tests/returning.test new file mode 100644 --- /dev/null +++ b/sql/test/2024/Tests/returning.test @@ -0,0 +1,65 @@ +statement ok +create table foo (i int , j int); + +statement ok +insert into foo values (1, 10), (2, 20), (3, 30); + +query II nosort +delete from foo where i > 1 returning i*2, j*j as k +---- +4 +400 +6 +900 + +query I nosort +select count(*) from foo +---- +1 + +statement ok +truncate foo + +statement ok +insert into foo values (1, 10), (2, 20), (3, 30); + +query II nosort +update foo set j = -j where i < 3 returning j+5 as bla, i+i +---- +-5 +2 +-15 +4 + +statement ok +truncate foo + +statement ok +insert into foo values (1, 10), (2, 20), (3, 30); + + +query I nosort +update foo set j = -j returning j+5 +---- +-5 +-15 +-25 + +query I nosort +update foo set i = -i returning -j +---- +10 +20 +30 + +statement error 42000!SELECT: identifier 'k' unknown +update foo set i = -i returning k + +statement error 42000!SELECT: identifier 'k' unknown +delete from foo where i > 0 returning k + +statement error 42000!SUM: aggregate functions not allowed in SET, WHILE, IF, ELSE, CASE, WHEN, RETURN, ANALYZE, RETURNING clauses (use subquery) +update foo set i = -i returning sum(i) + +statement error 42000!SELECT: subquery not allowed +update foo set i = -i returning i in (select j from foo) _______________________________________________ checkin-list mailing list -- checkin-list@monetdb.org To unsubscribe send an email to checkin-list-le...@monetdb.org
