-
Type:
Bug
-
Resolution: Unresolved
-
Priority:
Major - P3
-
None
-
Affects Version/s: None
-
Component/s: None
-
None
-
Query Integration
-
ALL
While working on SERVER-93881 we introduced a query_shape_hash_stability suite that runs explain on each query multiple times and ensures that reported QueryShapeHash value is same.
However, jstests/core/timeseries/timeseries_union_with.js had to be excluded because while the run() command succeeded, the explain() failed for the given query:
{
"aggregate" : "a",
"pipeline" : [
{
"$unionWith" : {
"coll" : "b",
"pipeline" : [
{
"$match" : {
"$expr" : {
"$eq" : [
{
"$mod" : [
{
"$toInt" : {
"$substr" : [
"$tags.hostname",
5,
-1
]
}
},
2
]
},
0
]
}
}
}
]
}
},
{
"$group" : {
"_id" : "$tags.hostname",
"count" : {
"$sum" : 1
}
}
},
{
"$sort" : {
"_id" : 1
}
}
],
"cursor" : { },
"lsid" : {
"id" : UUID("ba0aa2a3-b85d-4096-8312-40ba6759f158")
},
"$clusterTime" : {
"clusterTime" : Timestamp(1727271933, 20),
"signature" : {
"hash" : BinData(0,"AAAAAAAAAAAAAAAAAAAAAAAAAAA="),
"keyId" : NumberLong(0)
}
}
}