model-writtenrun 8148 - may be wrong, links go to the source messages. Commit-by-commit LLM analysis is in the Commits dialog.
- Roman Lytovchenko reported that an index using the ICU digitslast collation returned no matching rows while a sequential scan returned 1001; Peter Geoghegan traced the inconsistent ordering to ICU comparison and sort-key functions, and Thomas Munro reproduced it with additional ICU versions #1 #2 #3 #4.
- Nearly two years later, Jehan-Guillaume de Rorthais reproduced the bug with current ICU, submitted an upstream regression test, and investigated alternative comparison functions and user workarounds #5.
- Jehan-Guillaume proposed switching to ucol_strcollIter, reporting roughly 20% slower sorting for UTF8 databases and little slowdown for LATIN1, then added a regression test without changing the implementation #6 #7.
- Peter Geoghegan suggested extending the existing ICU-version guard, but Jehan-Guillaume explained that both comparison functions remained affected in current ICU; Daniel Verite corroborated this, and Peter withdrew the suggestion #8 #9 #10 #11.
- Peter Eisentraut questioned the scope of the ICU defect, and Daniel Verite found no comparable failures in other tested reorderings; Peter opposed slowing normal operations for this specialized ICU bug, while Jehan-Guillaume argued that warnings alone would leave users exposed to incorrect indexes #12 #13 #14 #15 #16.
- Daniel Verite suggested removing the problematic example from the documentation because users appeared to be copying it, and Jehan-Guillaume submitted a separate documentation patch that removed digitslast and retained a combined-options example using numeric ordering #17 #18.
- Peter Eisentraut requested retaining a reordering example using Latin and Greek, which Jehan-Guillaume implemented in the final documentation patch #19 #20.
- Peter Eisentraut committed the final documentation patch with an added explanation of the default ordering as 4fff515e9e and confirmed backpatching it; the runtime workaround did not land, leaving the underlying ICU defect awaiting an upstream fix #21.