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:
Versions < 3.11.11 and < 3.12.2: Verify incorrect sorting (z, x, y).
Versions >= 3.11.11 and >= 3.12.2: Verify correct sorting (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: Versions < 3.11.11 and < 3.12.2: Verify incorrect sorting (z, x, y). Versions >= 3.11.11 and >= 3.12.2: Verify correct sorting (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