Uploaded image for project: 'Core Server'
  1. Core Server
  2. SERVER-82035

TSCellToBlock generates less data than expected

    • Type: Icon: Bug Bug
    • Resolution: Fixed
    • Priority: Icon: Major - P3 Major - P3
    • 7.2.0-rc0
    • Affects Version/s: None
    • Component/s: None
    • Labels:
      None
    • Fully Compatible
    • ALL
    • 150

      db.coll.drop();
      db.createCollection("coll", { timeseries: {timeField: 'time', metaField: 'tag'}});
      db.coll.insertMany([
          {_id: 0, time: new Date("2022-11-10T07:13:25.328Z"), tag: {scientist: 2, assistant: 1, }, measurement0: -274.0481977094897,measurement1: -869.4111318887465,measurement2: -577.7916965645944,measurement3: -896.2859729462822,measurement4: 299.4164236882775,measurement5: -185.39383643936367,measurement6: 810.2683694297002,}, // 0
          {_id: 36, time: new Date("2022-11-10T16:03:59.621Z"), tag: {scientist: 2, assistant: 1, }, measurement0: -551.7474541368974,measurement1: -843.95416820435,measurement2: -856.6619235474826,measurement3: 224.0404998802594,measurement4: -432.7157828489778,measurement5: 300.89096330137954,measurement6: 483.020870344061,"str": "Tasty Open-architected", "num": NumberDecimal("252.24702537886742"), "date": new Date("2019-01-19T21:36:09.786Z"), "array": ["backing up Tasty", new Date("2019-01-28T15:23:57.661Z"), "Practical Electronics", [], {_id: 37, "str": "functionalities Industrial", "num": NumberLong("21448"), "array": ["Paradigm"], "geoJson": {type: "Point", coordinates: [158.14385171852598, -48.5800706985095] }, "any": NaN, }, NumberInt(92656), NumberLong("32124"), new Date("2019-03-07T12:43:15.103Z"), new Date("2019-06-22T18:01:45.664Z"), {_id: 38, "str": null, "num": NumberLong("5562"), "date": new Date("2019-10-31T20:52:30.301Z"), "array": [NumberLong("64494"), NumberInt(28859)], "obj": {_id: 39, "date": new Date("2019-08-26T04:51:46.616Z"), "array": [null, {_id: 40, "str": "Neck Iranian Rial generate", "obj": {_id: 41, "str": "Liaison ability", "num": NumberInt(87029), "date": new Date("2019-09-21T07:16:51.429Z"), "array": [], "obj": {_id: 42, "str": null, "date": new Date("2019-01-15T05:29:49.219Z"), "obj": {}, }, "geoLegacy": {x: -122.74420266330026, y: -4.838553684234128}, "any": "Product", }, }, []], "any": null, }, "geoJson": {type: "Point", coordinates: [102.98243671251737, 21.17868547675883] }, "any": "Bedfordshire", }, ["Dominican Peso"], NumberDecimal("648.8193628008639"), []], }, // 14
          {_id: 50, time: new Date("2022-11-11T01:49:15.500Z"), tag: {scientist: 2, assistant: 1, }, measurement0: -14.046107990871405,measurement1: -643.5073887166849,measurement2: -260.2887483636041,measurement3: 703.2269811852411,measurement4: 148.34276713140753,measurement5: -634.0355370520534,measurement6: 643.4389243089097,}, // 20
          {_id: 61, time: new Date("2022-11-11T05:03:48.538Z"), tag: {scientist: 2, assistant: 1, }, measurement0: -900.4511927914439,measurement1: -164.25936766101916,measurement2: 830.9455109350047,measurement3: -592.5276321465672,measurement4: 486.8164008076201,measurement5: 885.7825328991826,measurement6: -710.2418769628057,"str": "Hat", "num": NumberLong("58022"), "date": new Date("2019-12-22T17:06:04.342Z"), "array": [NumberDecimal("-694.4684880200178"), "Berkshire Total synthesizing", NumberLong("97325"), new Date("2019-12-23T05:32:58.490Z"), {_id: 62, "str": "Representative open-source invoice", "num": NumberLong("68019"), "date": new Date("2019-05-14T21:13:57.613Z"), "array": [{_id: 63, "num": NumberInt(4800), "date": new Date("2019-10-27T17:04:50.354Z"), "array": [new Date("2019-02-08T23:31:53.176Z"), NumberInt(35569)], "obj": {_id: 64, "str": "Investment Account mobile", "date": new Date("2019-09-02T17:31:31.252Z"), "obj": {_id: 65, "num": NumberInt(74338), "array": [], "any": {_id: 66, "str": "Mountains", "obj": {_id: 67, "str": "override", "num": NumberDecimal("-220.39424188477903"), "date": new Date("2019-05-21T07:04:39.681Z"), "obj": {}, }, "geoJson": {type: "Point", coordinates: [0.7357858588841566, 77.13268473580919] }, "any": [null, null], }, }, "geoLegacy": {x: -22.836668779775806, y: -20.85574811878182}, }, }, {_id: 68, "num": NumberInt(21247), "date": new Date("2019-07-16T09:44:53.627Z"), "array": [], "obj": {_id: 69, "str": "Technician", "array": [new Date("2019-10-07T11:54:26.514Z"), new Date("2019-10-01T21:37:19.515Z")], "geoLegacy": [-39.56419820293314, 82.32587185154534], "any": [], }, "any": "Coordinator Tasty", }], }, null, null, NumberLong("20401"), NumberDecimal("-55.86354170203833"), NumberDecimal("-461.0811080277457"), "Incredible Frozen Fish payment hack", null, {_id: 70, "num": NumberInt(49843), "any": ["Credit Card Account Senior Handcrafted"], }], "obj": {_id: 71, "str": "toolset Washington generating", "num": Infinity, "date": null, "obj": {}, "geoJson": {type: "Point", coordinates: [-108.1970083109777, -62.470700182405] }, "any": null, }, }, // 26
          {_id: 117, time: new Date("2022-11-11T09:48:45.915Z"), tag: {scientist: 2, assistant: 1, }, measurement0: -222.07599653479758,measurement1: 871.3174224438314,measurement2: -343.2935152655059,measurement3: 479.05467237689754,measurement4: -374.52498042997354,measurement5: 817.9356862627794,measurement6: -707.2713383520925,}, // 40
          {_id: 152, time: new Date("2022-11-11T20:19:20.034Z"), tag: {scientist: 2, assistant: 1, }, measurement0: 316.78806537321316,measurement1: 886.0630483764053,measurement2: -665.0498285562462,measurement3: 84.54080456850352,measurement4: -701.4137417865185,measurement5: -116.80834847495555,measurement6: 277.0410101989428,}, // 61
          {_id: 153, time: new Date("2022-11-11T21:52:06.896Z"), tag: {scientist: 2, assistant: 1, }, measurement0: 243.2935413040925,measurement1: 733.1857013722206,measurement2: 428.24775925088784,measurement3: -917.3357142340946,measurement4: -17.24552790682594,measurement5: -864.2645318692926,measurement6: -118.48241765530031,}, // 62
      ]);
      db.coll.aggregate(    [{$match: {"str": {$lt: "e-services Cambridgeshire"}}}, {$match: {"array": {$size: 5}}}, {$replaceRoot: {newRoot: {k: "payment Metal e-markets", v: "$obj.obj.obj.date"}}}]);
      

      The call to getValueBlock on the cell object returns just 1 or 2 entries instead of 7

            Assignee:
            ian.boros@mongodb.com Ian Boros
            Reporter:
            alberto.massari@mongodb.com Alberto Massari
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Created:
              Updated:
              Resolved: