-
Type: Bug
-
Resolution: Duplicate
-
Priority: Major - P3
-
None
-
Affects Version/s: None
-
Component/s: None
-
None
-
ALL
-
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.
- is related to
-
SERVER-14832 Distinct command result set may include or exclude null/undefined depending on presence of index
- Needs Scheduling