Loading...

XML

Word

Printable

JSON

Type: Bug
Resolution: Fixed
Priority: Major - P3
Fix Version/s: 5.2.0, 5.1.2
Affects Version/s: None
Component/s: Querying
Labels:
- query-director-triage

Backwards Compatibility:
Fully Compatible
Operating System:
ALL
Backport Requested:

v5.1
Sprint:
QO 2021-11-29

db.getSiblingDB("test").weather.insertMany( [
   {
       "_id": 0,
       "metadata": { "sensorId": 5578, "type": "temperature" },
       "timestamp": ISODate("2021-05-18T00:00:00.000Z"),
       "temp": 12
   },
   {"_id": 1,
       "metadata": { "sensorId": 5578, "type": "temperature" },
       "timestamp": ISODate("2021-05-18T02:00:00.000Z"),
       "temp": 14
   }
] );

db.getSiblingDB("test").weather.aggregate([
    {
            $densify: {
                field: "timestamp",
                partitionByFields: ["metadata.sensorId"],
                range: {
                     step: 1,
                     unit: "hour",
                     bounds: "full"
                }
            }
        }
    ]);

Output:
1) It was supposed to create just one new document, but there's an extra document in the end without partition filed.
2) In the created document partition field metadata: {sensorId: 5578} became "metadata.sensorId": 5578

[
  {
    "_id": 0,
    "metadata": {
      "sensorId": 5578,
      "type": "temperature"
    },
    "timestamp": {
      "$date": "2021-05-18T00:00:00Z"
    },
    "temp": 12
  },
  {
    "metadata.sensorId": 5578,
    "timestamp": {
      "$date": "2021-05-18T01:00:00Z"
    }
  },
  {
    "_id": 1,
    "metadata": {
      "sensorId": 5578,
      "type": "temperature"
    },
    "timestamp": {
      "$date": "2021-05-18T02:00:00Z"
    },
    "temp": 14
  },
  {
    "timestamp": {
      "$date": "2021-05-18T02:00:00Z"
    }
  }
]

Expected output:

[
  {
    "_id": 0,
    "metadata": {
      "sensorId": 5578,
      "type": "temperature"
    },
    "timestamp": {
      "$date": "2021-05-18T00:00:00Z"
    },
    "temp": 12
  },
  {
    "metadata": {
      "sensorId": 5578
    },
    "timestamp": {
      "$date": "2021-05-18T01:00:00Z"
    }
  },
  {
    "_id": 1,
    "metadata": {
      "sensorId": 5578,
      "type": "temperature"
    },
    "timestamp": {
      "$date": "2021-05-18T02:00:00Z"
    },
    "temp": 14
  }
]