Cornelius Boateng f9e51fce34 Merged PR 1783524: [fix][collation] Simple Locale ...

### Does this PR have any customer impact?

### Type (Feature, Refactoring, Bugfix, DevOps, Testing, Perf, etc)

### Does it involve schema level changes? (Table, Column, Index, UDF, etc level changes)

### Are you introducing any new config? If yes, do you have tests with and without them being set?

### ChangeLog (Refer [Template](../oss/CHANGELOG.md))

### Description
Simple locale must use binary comparison and not necessarily case-insensitive comparison.

----
#### AI description  (iteration 1)
#### PR Classification
This pull request is a bug fix to correctly handle the simple collation locale.

#### PR Summary
The changes ensure that when the collation locale is specified as `simple`, all additional collation options are ignored and binary comparison is applied.
- `oss/pg_documentdb_core/src/collation/collation.c`: Added logic to bypass extra collation options when the locale is `simple`.
- `oss/pg_documentdb_core/src/query/bson_compare.c`: Updated string comparison to use binary comparison for the `simple` collation.
- Test files under `oss/internal/pg_documentdb_distributed/src/test` and `pgmongo/src/test` were updated to add regression checks for simple collation behavior.
<!-- GitOpsUserAgent=GitOps.Apps.Server.pullrequestcopilot -->

2025-09-09 11:03:42 +08:00

..

collation.h

Merged PR 1783524: [fix][collation] Simple Locale

2025-09-09 11:03:42 +08:00