Search code examples
firebirdfirebird-4.0

Firebird 4 Get "Incompatible data type" error when using gsec or isql

I'm facing an issue when I try to use gsec or isql on v4.0.1:

# "${PREFIX}"/bin/gsec -database "security.db" -display MYUSER
Incompatible data type

Or via isql:

# "${PREFIX}"/bin/isql -user sysdba security.db
Database: security.db, User: SYSDBA
SQL> create or alter user SYSDBA password '${ISC_PASSWORD}' using plugin Srp;
Statement failed, SQLSTATE = HY000
no operation specified
-Incompatible data type

I've deleted then recreated security4.fdb and I'm still getting this error.

Solution

  • This is https://github.com/FirebirdSQL/firebird/issues/6860 and it is supposed be fixed in version 4.0.1. Check server version twice or just remove DataTypeCompatibility setting from firebird.conf.