No boolean definition in Firebird 2.5 – Liquibase can‘t create the DATABASECHANGELOGLOCK table

Description

When using Liquibase on a Firebird database prior to Firebird 3.0 liquibase crashes sometimes with the following execption:

Liquibase.exception.DatabaseException: Dynamic SQL Error; SQL error code = -607; Invalid command; Specified domain or source column BOOLEAN does not exist [SQLState:42000, ISC error code:335544641] [Failed SQL: (335544641) CREATE TABLE DATABASECHANGELOGLOCK (ID INT NOT NULL, LOCKED BOOLEAN NOT NULL, LOCKGRANTED TIMESTAMP, LOCKEDBY VARCHAR(255), CONSTRAINT PK_DATABASECHANGELOGLOCK PRIMARY KEY (ID))]

Liquibase sometimes uses the Firebird3Database Class for a FirebirdDatabase (with version 2.5).

Environment

Firebird 2.5

Activity

Show:

Details

Reporter

Components

Affects versions

Priority

Created December 2, 2019 at 9:45 AM
Updated January 22, 2020 at 7:44 AM