Details
-
Bug
-
Resolution: Duplicate
-
Major - P3
-
None
-
None
-
None
-
None
-
ALL
-
Description
When executing a distinct command to identify distinct values within a collection, if the winning plan is a COLLSCAN the result set will exclude null values. If the winning plan is an IXSCAN (or a PROJECTION_COVERED/DISTINCT_SCAN) the result set will include the null values.
I'm assuming this is by design, so if that's the case perhaps there's a documentation gap here.
Attachments
Issue Links
- is related to
-
SERVER-14832 Distinct command result set may include or exclude null/undefined depending on presence of index
-
- Needs Scheduling
-