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

INLJ cannot be used if collation of the index doesn't match the effective collation of $lookup

    XMLWordPrintableJSON

Details

    • Icon: Task Task
    • Resolution: Fixed
    • Icon: Major - P3 Major - P3
    • 6.0.0-rc0
    • None
    • None
    • None
    • Fully Compatible
    • QE 2022-04-04, QE 2022-04-18

    Description

      The effective collation on $lookup can be set through various means (_internalCollation property on $lookup stage, collation property on the pipeline, collation of the local collection) and might not match the collation of the index of the foreign collection. In this case we should fall back to using NLJ/HJ algorithms.

      Attachments

        Activity

          People

            rui.liu@mongodb.com Rui Liu
            irina.yatsenko@mongodb.com Irina Yatsenko (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: