Details
Description
items are not updated in merge query
cbq> select meta(b0).id, click from b0 ;
{
"request_id": "6315dc36-691e-467c-baa2-941afd277048",
"signature":
,
"results": [
,
{ "click": "to edit", "id": "d2" } ],
"status": "success",
"metrics":
}
cbq> select meta(b1).id, click from b1 ;
{
"request_id": "a0c5b802-a274-4361-b2c2-bfd7d4ee5771",
"signature":
,
"results": [
,
{ "click": "to edit", "id": "d1" } ],
"status": "success",
"metrics":
}
cbq> merge into b0 using b1 on key "d1" when matched then update set b0.click='abc';
{
"request_id": "00e61c66-1c52-46e0-85f2-467800db4924",
"signature": null,
"results": [
]
"errors": [
],
"status": "errors",
"metrics":
}
cbq> select meta(b0).id, click from b0 ;
{
"request_id": "ca2f9d20-a8e7-4c34-b5ad-54bf55e18b4b",
"signature":
,
"results": [
,
{ "click": "to edit", "id": "d2" } ],
"status": "success",
"metrics":
}
cbq> select meta(b1).id, click from b1 ;
{
"request_id": "1dd1c01e-f1af-4958-afcf-4f5f0f37ccf0",
"signature":
,
"results": [
,
{ "click": "to edit", "id": "d1" } ],
"status": "success",
"metrics":
}
Attachments
For Gerrit Dashboard: MB-12982 | ||||||
---|---|---|---|---|---|---|
# | Subject | Branch | Project | Status | CR | V |
47740,2 | Fix DML operators for MB-13569 and MB-12982. Make each datastore's Fetch() include metadata in the result. Modify execution operators to use metadata from Fetch(), which fixes issue of wrong CAS value. | master | query | Status: MERGED | +2 | +1 |
47742,1 | Fix DML operators for MB-13569 and MB-12982. Make each datastore's Fetch() include metadata in the result. Modify execution operators to use metadata from Fetch(), which fixes issue of wrong CAS value. | master | query | Status: ABANDONED | 0 | 0 |
47953,2 | Correctly marshal / unmarshal JSON, including LIMIT inherited from MERGE. Applies towards MB-12982. | master | query | Status: MERGED | +2 | +1 |
47959,2 | Fix MB-12982 and make MERGE work. Use proper concurrency in merge operator. Use identical child copies in parallel operator. Set Inputs and Outputs properly in sequence operator. | master | query | Status: MERGED | +2 | +1 |