Files
Vinod Sridharan 0c81ad7665 Merged PR 1775707: Order by fixes for backward scans
### Does this PR have any customer impact?
Yes

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

### Does it involve schema level changes? (Table, Column, Index, UDF, etc level changes)
No
### Are you introducing any new config? If yes, do you have tests with and without them being set?
No
### ChangeLog (Refer [Template](../oss/CHANGELOG.md))

### Description

Fix two bugs found in backward scan.

----
#### AI description  (iteration 1)
#### PR Classification
Bug fix enhancing ordering behavior during backward scans.

#### PR Summary
This pull request refines the logic for backward scans to ensure correct order-by results and updates related pipelines for schema version management.
- `/.pipelines/templates/single_node_tests.yml`: Introduced the `useNextSchemaVersionOverride` parameter and conditional assignment for `CurrentSchemaVersion`.
- `/oss/pg_documentdb/src/opclass/bson_gin_composite_entrypoint.c`: Modified comparator logic to adjust return values for backward scans, ensuring proper boundary handling.
- `/pgmongo_rum/src/rumget.c`: Adjusted order scan offset for backward scanning in the order-by process.
- `/.pipelines/pgmongo_backend_test.yml`: Enabled the schema version override by setting `useNextSchemaVersionOverride` to true.
<!-- GitOpsUserAgent=GitOps.Apps.Server.pullrequestcopilot -->
2025-08-21 20:14:39 +08:00
..