MVStore / TransactionStore: concurrent updates could result in a "Too many open transactions" exception.

StringUtils.toUpperEnglish now has a small cache. This should speed up reading from a ResultSet when using the column name.

all of the GROUP BY columns are not mentioned in the select. Patch by Frederico (zepfred).

Issue 598: parser fails on timestamp "24:00:00.1234" - prevent the creation of out-of-range time values.

MVStore: up to 65535 open transactions are now supported. Previously, the limit was at most 65535 transactions between the oldest open and the newest open transaction (which was quite a strange limit).

The default limit for in-place LOB objects was changed from 128 to 256 bytes. This is because each read creates a reference to a LOB, and maintaining the references is a big overhead. With the higher limit, less references are needed.

Creating a linked table from an MVStore database to a non-MVStore database created a second (non-MVStore) database file.

The LIRS cache now resizes the table automatically in all cases and no longer needs the averageMemory configuration.

In version 1.4.184, a bug was introduced that broke queries that have both joins and wildcards, for example: select * from dual join(select x from dual) on 1=1

In version 1.4.184, "group by" ignored the table name, and could pick a select column by mistake. Example: select 0 as x from system_range(1, 2) d group by d.x;

found by CodePro

found by CodePro

found by CodePro

the logic that cleared the flag could never be reached, resulting in performance degradation.
Reported by Alexander Nesterov.