Details
-
Bug
-
Resolution: Fixed
-
Major
-
6.5.1, Cheshire-Cat
-
None
-
Untriaged
-
1
-
Unknown
Description
The MERGE statement currently allows both an UPDATE and a DELETE statement in the WHEN MATCHED clauses.
This has two issues
1- most pressing: it sends the same value down two distinct operator paths, where two different operators could work on it concurrently
2- semantically, it makes little sense to both update and delete the same document in the same statement.
Amend MERGE as required.
Attachments
Issue Links
- relates to
-
MB-40987 MERGE behavior: should UPDATE and DELETE actions be specified on the same time for the same MERGE statement?
- Closed