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

Reply via email to