[Firebird-devel] Conversion error from string to date in Firebird 4

[Dmitry S. <dmi...@re...>]

Hello.

Some string to date conversions that work in FB3 fail with an error in FB4:

SELECT cast('01 jan 1900' as timestamp) FROM rdb$database;

Statement failed, SQLSTATE = 22018
conversion error from string "01 jan 1900"


SELECT cast('01,jan,1900' as timestamp) FROM rdb$database;

Statement failed, SQLSTATE = 22018

conversion error from string "01,jan,1900"

AFAIU the error appears after fix for CORE-5750. It's expected that 
whitespace and comma are no longer considered as date separators?

Because documentantion here 
(https://firebirdsql.org/en/firebird-date-literals/) says they are valid 
separators.

Best regards,

Dmitry Starodubov