Details
Description
Insert or upsert with -1 expiration:
cbq> UPSERT INTO default (KEY, VALUE) VALUES ("K0", {"id":"K0"}, {"expiration": -1}); |
{
|
"requestID": "0313824b-d611-4f8c-85ec-cfafe3f940f3", |
"signature": null, |
"results": [ |
],
|
"status": "success", |
"metrics": { |
"elapsedTime": "2.516431ms", |
"executionTime": "2.372433ms", |
"resultCount": 0, |
"resultSize": 0, |
"mutationCount": 1 |
}
|
}
|
|
check expiration, should be 0:
cbq> SELECT META().expiration FROM default WHERE META().id = 'K0' ; |
{
|
"requestID": "041b3d02-ecc6-4458-8261-94a82ffbf505", |
"signature": { |
"expiration": "json" |
},
|
"results": [ |
{
|
"expiration": 4294967295 |
}
|
],
|
"status": "success", |
"metrics": { |
"elapsedTime": "3.805892ms", |
"executionTime": "3.680625ms", |
"resultCount": 1, |
"resultSize": 40 |
}
|
}
|
|
Attachments
Issue Links
- relates to
-
MB-54393 [BP to 6.6.6 MB-54390] - INSERT/UPSERT options should not be shared
-
- Closed
-