Changeset: b29eefa306fc for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=b29eefa306fc
Modified Files:
sql/ChangeLog
Branch: default
Log Message:
Updated ChangeLog.
diffs (26 lines):
diff --git a/sql/ChangeLog b/sql/ChangeLog
--- a/sql/ChangeLog
+++ b/sql/ChangeLog
@@ -1,6 +1,22 @@
# ChangeLog file for sql
# This file is updated with Maddlog
+* Mon Dec 17 2018 Pedro Ferreira <pedro.ferre...@monetdbsolutions.com>
+- Implemented merge statements from SQL:2003 standard. Using a source
+ relation R, a target table T is updating depending on the result of
+ the merge. In case of a match, the table T's row is either updated
+ or deleted with R's row. In a non-match case, R's row is inserted
+ into T. The grammar is the follows:
+ > MERGE INTO target [ [AS] ident ] USING source ON search_condition
+ { WHEN MATCHED [ AND search_condition ] THEN
+ { UPDATE SET assignment_list | DELETE } } |
+ { WHEN NOT MATCHED [ AND search_condition ] THEN
+ INSERT [ column_list ] [ { DEFAULT VALUES | VALUES row_values } ] }
+- Added possibility to change the schema of a table with the syntax:
+ > ALTER TABLE [ IF EXISTS ] qname SET SCHEMA ident
+- Added optional alias option for target table in update and delete
+ statements: (e.g. UPDATE target AS alias SET col1=...)
+
* Thu Nov 29 2018 Martin van Dinther <martin.van.dint...@monetdbsolutions.com>
- Improved and extended storagemodel functionality. Changes include:
- Added views sys."tablestorage" and sys."schemastorage" for easy and
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
