Loading...

XML

Word

Printable

JSON

Type: Improvement
Resolution: Fixed
Priority: Major - P3
Fix Version/s: 8.1.0-rc0
Affects Version/s: None
Component/s: Querying
Labels:
- query-44-grooming

Assigned Teams:

Query Optimization
Backwards Compatibility:
Fully Compatible
Confidence Status:
None
Work Order:
3
CAR Domain/s:
None

Aha! Reference:
None
Tracking Level:
None
Risk Status:
None
Exec Notes:
None
Goal Name(s):
None
Goal Link:
None

Looks like it's possible to hint an index that has one collation defined but specify a different collation on the query itself.

It should probably be an error, similar to requests in SERVER-8564 but I can also see this being a warning, since it's possible to conceive a query that is using default collation but wants to use an existing different collation index for filtering in a scenario where this does not impact the results.

is related to

SERVER-62362 Hints are allowed on special indexes like 2d and text but lead to incorrect results

Open

SERVER-26413 Hinting an incompatible partial index can return incomplete results

Backlog

SERVER-18449 Hinting sparse index without sparse-compatible predicate should be disallowed

Backlog

SERVER-89744 Resharding incorrectly builds {locale: "simple"} secondary indexes with collection's non-"simple" default collation

Closed

Assignee:: Nicholas Zolnierz
Reporter:: Asya Kamsky
Participants:: Asya Kamsky, David Storch, Githook User, Nicholas Zolnierz
Votes:: 0 Vote for this issue
Watchers:: 17 Start watching this issue

Created:: Oct 11 2016 07:45:20 PM UTC
Updated:: Dec 18 2024 06:30:34 PM UTC
Resolved:: Dec 18 2024 06:30:34 PM UTC
Confidence Status Last Update:: 31/Oct/24 1:44 PM

Details

Description

Attachments

Issue Links

Forms

Activity

People

Dates