Hi,
Take a look at these steps (https://snipboard.io/Tzkq47.jpg) that produces an error like that: "Statement failed, SQLSTATE = HY000 message length error (encountered 12, expected 16)" Here are the steps to reproduce: ================================ isql -USER SYSDBA -pass masterkey CREATE DATABASE "D:\FOOBAR.FDB"; COMMIT; CREATE TABLE FOOBARTABLE( DATECOLUMN1 TIMESTAMP ); COMMIT; INSERT INTO FOOBARTABLE( DATECOLUMN1 ) VALUES(CURRENT_TIMESTAMP); COMMIT; SELECT COALESCE(DATECOLUMN1, CURRENT_TIMESTAMP) FROM FOOBARTABLE; ================================ Here is my "show version": ISQL Version: WI-V4.0.0.2187 Firebird 4.0 Release Candidate 1 Server version: Firebird/Windows/AMD/Intel/x64 (access method), version "WI-V4.0.0.2187 Firebird 4.0 Release Candidate 1" Firebird/Windows/AMD/Intel/x64 (remote server), version "WI-V4.0.0.2187 Firebird 4.0 Release Candidate 1/tcp (zepc)/P16:C" Firebird/Windows/AMD/Intel/x64 (remote interface), version "WI-V4.0.0.2187 Firebird 4.0 Release Candidate 1/tcp (zepc)/P16:C" on disk structure version 13.0 And here is my custom firebird.conf: AuthServer = Srp256, Srp, WinSspi, Legacy_Auth UserManager = Srp, Legacy_UserManager DataTypeCompatibility = 2.5 WireCrypt = Enabled I also tried with "DataTypeCompatibility = 3.0" and with "#DataTypeCompatibility = ". Regards, -- Eliezer Riani
Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel