h2database/h2database ↗
Distinct query ignores DESC when there is an index
- Contribution
- Fixed SELECT DISTINCT … ORDER BY … DESC returning the smallest value when an index exists. Root cause: Index.findNext() always walked the index in ascending order. It now takes a reverse flag, so DESC queries walk the index backwards. Added a regression test.