Details
Description
Not sure if this is a bug or expected response for Upsert.
1. On Upsert non-existing values - I see mutation count+1 the value is inserted.
2. On Upsert existing value - I see mutation count+1, value is updated.
3. On UPsert no change in existing value - I see mutation count +1 – what does this mutation count indicate? ie there is no change in the value of the document, should a user expect a mutation count +1 for this case?
Update behaviour shows else
|
cbq> update `travel-sample` set id=1 where id=10;
|
{
|
"requestID": "52e63660-2a29-4086-a7ca-58b23a994b94",
|
"signature": null,
|
"results": [
|
],
|
"status": "success",
|
"metrics": {
|
"elapsedTime": "8.588421008s",
|
"executionTime": "8.58831167s",
|
"resultCount": 0,
|
"resultSize": 0,
|
"mutationCount": 1
|
}
|
}
|
|
cbq> update `travel-sample` set id=1 where id=10;
|
{
|
"requestID": "8a027de2-b4fa-4470-8536-2b0a7b3ad439",
|
"signature": null,
|
"results": [
|
],
|
"status": "success",
|
"metrics": {
|
"elapsedTime": "8.373637027s",
|
"executionTime": "8.373519109s",
|
"resultCount": 0,
|
"resultSize": 0
|
}
|
}
|
|
Upsert behaviour
cbq> upsert into `travel-sample` values ("2", "bbb");
|
{
|
"requestID": "9e8db80e-cbda-4c02-b5ec-f0ea23e360b1",
|
"signature": null,
|
"results": [
|
],
|
"status": "success",
|
"metrics": {
|
"elapsedTime": "9.392772ms",
|
"executionTime": "9.271399ms",
|
"resultCount": 0,
|
"resultSize": 0,
|
"mutationCount": 1
|
}
|
}
|
|
cbq> upsert into `travel-sample` values ("2", "bbb");
|
{
|
"requestID": "4889007a-a362-4458-a607-92944a5d17d1",
|
"signature": null,
|
"results": [
|
],
|
"status": "success",
|
"metrics": {
|
"elapsedTime": "1.9904ms",
|
"executionTime": "1.890766ms",
|
"resultCount": 0,
|
"resultSize": 0,
|
"mutationCount": 1
|
}
|
}
|