Hello,

After upgrading to the version 2.3.230, we hit the following regression:

SELECT DISTINCT gendate FROM mytable WHERE gendate>='2019-02-01 10:30:00'

Which gives (correctly):

2019-02-01 10:30:00
2019-02-25 08:00:00

And then, just by adding an ORDER BY clause:

SELECT DISTINCT gendate FROM mytable WHERE gendate>='2019-02-01 10:30:00' ORDER BY gendate DESC

We "lose" the first result:

2019-02-25 08:00:00

Note: It seems that the DESC order is in cause here because if it is not set or ASC is used, then both results are returned as expected.

We use H2 with the MARIADB compatibility mode and the following parameters in the JDBC connection: jdbc:h2:/home/ctabin/data/data.db;MODE=MariaDB;IGNORECASE=TRUE;WRITE_DELAY=0;OPTIMIZE_REUSE_RESULTS=0

Thanks for the amazing work ! 🙏