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