[Feature Request] Support or ignore `hint`

[AlekSi]

Purpose of the feature.

Some MongoDB commands (aggregate, find, count, findAndModify, update, delete) accept a hint parameter that could be used to suggest an index to use. Currently, DocumentDB does not support it. FerretDB has users reporting compatibility problems due to this.

Alternatively, that parameter could just be ignored. It would be nice to check that specified index still exists (and return an error if it does not), but not do anything beyond that.

Describe the solution you'd like

hint parameter is implemented or ignored.

Describe alternatives you've considered

Decode all queries in FerretDB and remove that parameter before sending the request to DocumentDB. But that would make things slower.

Additional context

• Achieve compatibility with Ratus FerretDB/FerretDB#2256 (comment)
• feature-request: postgres storage support hyperonym/ratus#10 (comment)

[lichoil]

yes, i think we can ignore this parameter.

[c-nv-s]

just to get a rough idea on timeframe... how low is this request on the priority list/road map?

[duanpei-ms]

I'm working on it, expect that publish the PR before this weekend.

[c-nv-s]

@wwey-payton any update?

[c-nv-s]

@lichoil I just checked the github profile for wwey-payton and I'm not going to hold my breath for a solution from them

[duanpei-ms]

PR in review

[c-nv-s]

any update?

[c-nv-s]

@shuaitian-git PR still in review?

[c-nv-s]

@duanpei-ms @shuaitian-git please would anyone be able to estimate when this PR might be merged and available?