Support for SQL:2003 MERGE statement
------------------------------------
Key: DERBY-3155
URL: https://issues.apache.org/jira/browse/DERBY-3155
Project: Derby
Issue Type: New Feature
Components: SQL
Reporter: Trejkaz
A relatively common piece of logic in a database application is to check for a
row's existence and then either update or insert depending on its existence.
SQL:2003 added a MERGE statement to perform this operation. It looks like this:
MERGE INTO table_name USING table_name ON (condition)
WHEN MATCHED THEN UPDATE SET column1 = value1 [, column2 = value2 ...]
WHEN NOT MATCHED THEN INSERT column1 [, column2 ...] VALUES (value1 [,
value2 ...])
At the moment, the only workaround for this would be to write a stored
procedure to do the same operation, or to implement the logic client-side.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
