I’m experimenting with liquibase and DB2i (GitHub - liquibase/liquibase-db2i: Liquibase DB2 for iSeries support). I’m doing a very simple update (to create a table), but it fails with:
liquibase.exception.DatabaseException: [SQL0204] BOOLEAN in *LIBL type *SQLUDT not found. [Failed SQL: (-204) CREATE TABLE “LBDBTEST”.DATABASECHANGELOGLOCK (ID INTEGER NOT NULL, LOCKED BOOLEAN NOT NULL, LOCKGRANTED TIMESTAMP, LOCKEDBY VARCHAR(255), CONSTRAINT PK_DBCHGLOGLOCK PRIMARY KEY (ID))]
It is on this line of code in StandardLockService.init():
executor.execute(new CreateDatabaseChangeLogLockTableStatement());
I see further down in the init() method there are some checks for supportsBooleanDataType() (which I added to DB2iDatabase on my local copy of the extension, to return ‘false’), but it doesn’t get that far because of the above fail.
Any suggestions? Is this a bug in the init() method?