Changeset: 51a1af4bfd05 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/51a1af4bfd05 Modified Files: sql/ChangeLog Branch: default Log Message:
Changelog blurb for parser changes. diffs (33 lines): diff --git a/sql/ChangeLog b/sql/ChangeLog --- a/sql/ChangeLog +++ b/sql/ChangeLog @@ -1,20 +1,26 @@ # ChangeLog file for sql # This file is updated with Maddlog +* Fri Dec 20 2024 Sjoerd Mullender <sjo...@acm.org> +- The SQL parser was cleaned up. This resulted in some keywords being + used more strictly. If any of these keywords are to be used as column + names, they have to be quoted using double quotes: AS, TABLE, COLUMN, + DISTINCT, EXEC, EXECUTE. + * Tue Oct 8 2024 Yunus Koning <yunus.kon...@monetdbsolutions.com> - Introduce the RETURNING clause for INSERT, UPDATE and DELETE statements. Specifying a RETURNING clause causes the SQL statement to return the modified records which can be queried using SELECT like expressions in the RETURNING clause. Aggregate functions are allowed. This is a common non-standard SQL extension. - + Examples: - + INSERT INTO foo values (1,10), (-1,-10) RETURNING i+2*j AS bar ---- 21 -21 - + UPDATE foo SET i = -i WHERE i >0 RETURNING sum(j), count(j) ---- -60|3 _______________________________________________ checkin-list mailing list -- checkin-list@monetdb.org To unsubscribe send an email to checkin-list-le...@monetdb.org
