Details
-
Improvement
-
Resolution: Fixed
-
Major - P3
-
None
-
None
-
Query Integration
-
Fully Compatible
-
Execution Team 2023-04-03
Description
Currently explain for timeseries deletes / updates is not supported.
MongoDB Enterprise > db.runCommand({
|
... explain: {
|
... delete: "ts", |
... deletes: [{q: {x: 1}, limit: 0}] |
... }
|
... })
|
{
|
"ok" : 0, |
"errmsg" : "Taking test.ts lock for timeseries is not allowed", |
"code" : 166, |
"codeName" : "CommandNotSupportedOnView" |
}
|
> db.createCollection("ts", {timeseries: {timeField: "t", metaField: "m"}}); |
{ "ok" : 1 } |
> db.runCommand({explain: {update: "ts", updates: [{q: {m: 1}, u: {$inc: {a: 1}}, multi: true}]}}); |
{
|
"ok" : 0, |
"errmsg" : "Taking test.ts lock for timeseries is not allowed", |
"code" : 166, |
"codeName" : "CommandNotSupportedOnView" |
}
|
We need to test whether explain command works correctly for the sharded time-series collection too.
Attachments
Issue Links
- split to
-
SERVER-75478 Support explain for timeseries updates
-
- Closed
-
-
SERVER-75518 Support explain for deleteOne on a sharded timeseries collection
-
- Closed
-