FrontBase 3.6.37 - Release Notes

This is a maintenance release with focus on bug fixes and performance.

In certain situations a query running in REPEATABLE READ, OPTIMISTIC could become very slow if other connections were accessing the same tables, as referenced in the query, simultaneously with the query.

FrontBase 3.6.37 - BugFixes

CASTing character strings to CLOB could cause the server to stop.

<column> LIKE <expr> COLLATE <collation> would incorrectly use an index on <column>.

SET SESSION AUTHORIZATION <user> + ROLLBACK caused an incorrect state in the server.

HAVING <column> <op> <expr> didn't work properly.

VALUES(CAST (TIMESTAMP '2002-01-01 23:59:59-07:00' AS DATE)); returned DATE '2002-01-02'.

CAST(<column> AS FLOAT) * 86400 the calculated FLOAT value wasn't properly truncated wrt. mantissa.