Loading...

XML

Word

Printable

JSON

Assigned Teams:

Query Integration
Operating System:
ALL
Steps To Reproduce:
Hide

Create a time-series collection with metaField called "meta".

db.ts.explain().aggregate([{$match: {$expr: {$lt: ["$meta",1]}}}, {$match: {$expr: {$gt: ["$meta", 1]}}}]) ... "parsedQuery" : { "$and" : [ {"$expr" : {"$gt" : ["$meta", {"$const" : 1 }] }}, {"meta" : {"$_internalExprGt" : 1 }}, {"meta" : {"$_internalExprGt" : 1 }} ] },
Show
Create a time-series collection with metaField called "meta". db.ts.explain().aggregate([{$match: {$expr: {$lt: [ "$meta" ,1]}}}, {$match: {$expr: {$gt: [ "$meta" , 1]}}}]) ... "parsedQuery" : { "$and" : [ { "$expr" : { "$gt" : [ "$meta" , { "$ const " : 1 }] }}, { "meta" : { "$_internalExprGt" : 1 }}, { "meta" : { "$_internalExprGt" : 1 }} ] },
Confidence Status:
None
Work Order:
3

When multiple $match stages use expressions on the metaField we might create duplicated predicates on the bucketing collection

depends on

SERVER-84113 Remove circular dependency between optimize() and optimizeAt() in DocumentSources

is related to

SERVER-79585 A valid $match query fails on time-series collection