Details
-
Bug
-
Resolution: Fixed
-
Major
-
7.6.0, 7.2.4
-
7.6.0-2097
-
Untriaged
-
0
-
Unknown
Description
default bucket with employee data
travel-sample bucket
Running this merge
MERGE INTO default d USING `travel-sample`.inventory.hotel t ON t.country = d.country and any r in d.reviews satisfies r.author like 'M%' and r.ratings.Overall > 3 END WHEN MATCHED THEN DELETE WHERE d.free_parking = true
now gives an error
"msg": "Multiple UPDATE/DELETE of the same document (document key 'doc_10013') in a MERGE statement"
in 7.2.x this error is not thrown.
If the statement is run inside a transaction, then in both 7.6.0 and 7.2.x we'll get the above error.
Backup data is attached
Attachments
Issue Links
For Gerrit Dashboard: MB-60762 | ||||||
---|---|---|---|---|---|---|
# | Subject | Branch | Project | Status | CR | V |
205534,7 | MB-60762 Proper detection of duplication error in MERGE statement | 7.6.0 | query | Status: MERGED | +2 | +1 |
205847,5 | MB-60762 Copy over META information if inside transaction | 7.6.0 | query | Status: MERGED | +2 | +1 |
206337,2 | MB-60942 Revert previous changes for MB-60762 | 7.6.0 | query | Status: MERGED | +2 | +1 |
206897,3 | MB-60762 Delay processing of MERGE actions | trinity | query | Status: MERGED | +2 | +1 |
208473,1 | MB-61484 Retain original AnnotatedValue for MERGE DELETE action | master | query | Status: ABANDONED | +2 | +1 |
208537,2 | MB-61485 Fix issues with RETURNING clause of MERGE statement | trinity | query | Status: MERGED | +2 | +1 |