$match stage in Aggregation Pipeline builder does not find int64 fields

XMLWordPrintableJSON

    • Type: Bug
    • Resolution: Fixed
    • Priority: Major - P3
    • 1.23.0
    • Affects Version/s: None
    • Component/s: Aggregation pipeline
    • None
    • Iteration Jackfruit, Iteration Kiwi, Iteration Lime
    • Not Needed
    • None

      The aggregation pipeline builder doesn't find the correct documents for $match stages on int64 fields. Attached is a screenshot of an example. I think this may have something to do with the EJSON parsing converting the int64 value to a double along the way as I discovered this bug while working on CLOUDP-66548 which also involved int64s accidentally being converted to doubles.

        1. Screen Shot 2020-07-15 at 4.18.10 PM.png
          181 kB
          Julia Ruddy
        2. Screen Shot 2020-10-20 at 4.09.00 PM.png
          260 kB
          Rhys Howell
        3. Screen Shot 2020-10-20 at 9.58.07 AM.png
          66 kB
          Julia Ruddy

            Assignee:
            Maurizio Casimirri
            Reporter:
            Julia Ruddy (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Created:
              Updated:
              Resolved: