mongo_fdw icon indicating copy to clipboard operation
mongo_fdw copied to clipboard

fix: change default collation allowance

Open Climax777 opened this issue 1 year ago • 2 comments

Make provision for C_COLLATION_OID and POSIX_COLLATION_OID, which are also built-in types.

I'm not 100% sure what the impact will be, but everywhere specifically DEFAULT_COLLATION_OID was used, the other two are allowed now as well.

This fixes #169 and pushes down ObjectID queries for all columns.

Climax777 avatar Nov 13 '23 13:11 Climax777

@Climax777 , Thanks for the patches. At a glance, changes looks good to me. However, I will have a deeper look into it.

vaibhavdalvi93 avatar Nov 16 '23 03:11 vaibhavdalvi93

I found out that $in and $expr cannot make use of indexes. Only equality tests.

I will work in a bigger patch for normal top level $match requests to be flattened and just use normal query style formatting.

Should I rather make a new pull request to keep things simple and clear?

Climax777 avatar Nov 16 '23 04:11 Climax777