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":
}