This PR introduces a new test to validate the sorting order of Unicode characters following an upgrade to the ICU library in version 3.12. This change affects the comparison results and sorting order in ArangoDB, specifically in indexes.
The main objective of this test is to identify and document any changes in sorting behavior resulting from the ICU library upgrade. The test script 800_icu.js has been created to automate the validation process by:
Creating a collection and inserting specific Unicode character data.
Ensuring the collection has a persistent index.
Validating the sort order of the data using AQL queries.
Final Output:
Based on the thorough testing conducted, the following observations were made:
AQL Sorting Comparison:
Version 3.11.9 and version 3.12.0-2 showed similar sorting behavior during AQL query testing.
Version 3.12.0 exhibited different sorting behavior compared to the other versions.
UDF Testing in JavaScript:
All outputs during the testing of UDFs in JavaScript were identical across versions.
No differences were found in the outputs among the tested versions.
dothebart
commented
1 month ago
Scope & Purpose
This PR introduces a new test to validate the sorting order of Unicode characters following an upgrade to the ICU library in version 3.12. This change affects the comparison results and sorting order in ArangoDB, specifically in indexes.
The main objective of this test is to identify and document any changes in sorting behavior resulting from the ICU library upgrade. The test script 800_icu.js has been created to automate the validation process by:
Creating a collection and inserting specific Unicode character data. Ensuring the collection has a persistent index. Validating the sort order of the data using AQL queries. Final Output: Based on the thorough testing conducted, the following observations were made:
AQL Sorting Comparison:
Version 3.11.9 and version 3.12.0-2 showed similar sorting behavior during AQL query testing. Version 3.12.0 exhibited different sorting behavior compared to the other versions. UDF Testing in JavaScript:
All outputs during the testing of UDFs in JavaScript were identical across versions. No differences were found in the outputs among the tested versions.
Checklist