This PR adds a test for validating VPack numerical sorting in ArangoDB, specifically addressing sorting behavior for large numeric values across different versions.
Problem
Large numeric values were previously cast to doubles for comparison, leading to incorrect sorting and potential data corruption in RocksDB. The issue is fixed in versions 3.12.2 and 3.11.11, introducing a new comparator that requires migration for proper sorting.
Test Script
Insert Test Data: Add documents with large numeric values to test collections.
Initial Sorting Check:
We now compare against both 3.11.11 and 3.12.2.
For versions older than 3.11.11: Use the incorrect sorting order (z, x, y).
For versions between 3.11.11 and 3.12.2: Still use the incorrect sorting order (z, x, y).
For versions 3.12.2 and newer: Use the correct sorting order (y, z, x).
Upgrade & Migration: Upgrade ArangoDB, run the migration, and verify sorting changes.
Final Check: Ensure correct sorting and data integrity after migration.
Scope & Purpose
This PR adds a test for validating VPack numerical sorting in ArangoDB, specifically addressing sorting behavior for large numeric values across different versions.
Problem
Large numeric values were previously cast to doubles for comparison, leading to incorrect sorting and potential data corruption in RocksDB. The issue is fixed in versions 3.12.2 and 3.11.11, introducing a new comparator that requires migration for proper sorting.
Test Script
Insert Test Data: Add documents with large numeric values to test collections. Initial Sorting Check: We now compare against both 3.11.11 and 3.12.2. For versions older than 3.11.11: Use the incorrect sorting order (z, x, y). For versions between 3.11.11 and 3.12.2: Still use the incorrect sorting order (z, x, y). For versions 3.12.2 and newer: Use the correct sorting order (y, z, x).
Upgrade & Migration: Upgrade ArangoDB, run the migration, and verify sorting changes. Final Check: Ensure correct sorting and data integrity after migration.
Checklist