crdv7 opened a new pull request, #2558:
URL: https://github.com/apache/age/pull/2558

   The `issue_1446` regression test orders `labels(n)` inside Cypher. Since the
   result is an agtype value, its string components are compared using the
   database's default collation. This makes the output order locale-dependent.
   For example, the unmodified test returns the mixed-case labels in the
   following orders:
   
   ```text
   C:             X, Y, Z, hub, shared
   en_US.utf8:    hub, shared, X, Y, Z
   ```
   
   The entities and counts are correct in both cases, but `pg_regress` reports a
   failure because the row order differs from the expected output.
   
   Move the incidental ordering out of Cypher and sort the displayed label text
   with an explicit `C` collation. Apply the same deterministic ordering to both
   `issue_1446` verification queries. The test continues to verify the same
   MERGE results without depending on the database locale.
   
   This is the same class of regression-test portability issue addressed by
   [#2439](https://github.com/apache/age/pull/2439).


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]

Reply via email to