Uploaded image for project: 'Documentation'
  1. Documentation
  2. DOCS-7652

geo and text indexes are always sparse (not merely 'default' to sparse)

    • Type: Icon: Improvement Improvement
    • Resolution: Done
    • Priority: Icon: Major - P3 Major - P3
    • Server_Docs_20231030
    • Affects Version/s: None
    • Component/s: Server
    • Labels:
      None

      RE:
      https://docs.mongodb.org/manual/core/index-text/#sparse-property
      https://docs.mongodb.org/manual/core/2dsphere/#sparse-property
      https://docs.mongodb.org/manual/core/2d/#sparse-property

      [2d/2dsphere/text] indexes are sparse by default and ignores the sparse: true option.

      They also ignore explicitly specifying "sparse:false". The statement should be clarified in these 3 locations to be just "are always sparse and ignore the sparse option".

      Somewhat counter-intuitively, specifying "sparse:false" makes the index definition retain it and even print it back on request, clearly showing the "sparse:false" option but it is ignored; SERVER-13808.

      These indexes are always sparse no matter what options are passed in.

            Assignee:
            kay.kim@mongodb.com Kay Kim (Inactive)
            Reporter:
            andrew.ryder@mongodb.com Andrew Ryder (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved:
              6 years, 11 weeks, 1 day ago