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

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-18449 Hinting sparse index without sparse-compatible predicate should be disallowed

Backlog

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

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

Details

Description

Attachments

Issue Links

Activity

People

Dates