we have now tried to test our scripts using LB 3.0.7(liquibase-teradata-3.0-beta1.jar) against Teradata 14.0.0.01 but unfortunately we failed because of following errors:
Error executing SQL CREATE TABLE LB_TEST.DATABASECHANGELOGLOCK (ID int NOT NULL, LOCKED boolean NOT NULL, LOCKGRANTED datetime, LOCKEDBY varchar(255), CONSTRAINT PK_DATABASECHANGELOGLOCK PRIMARY KEY (ID));
Syntax error: Data Type “boolean” does not match a Defined Type name.
Seems like LB is trying to create the table DATABASECHANGELOGLOCK using datatype boolean for the column “LOCKED”, which isn’t supported in Teradata. With LB 2.0.1 this table was created with the datatype BYTEINT used for the named column.
After we manually created the table DATABASECHANGELOGLOCK using the same DDL script as the LB 2.0.1 used, there occured another error:
Error executing SQL INSERT INTO LB_TEST.DATABASECHANGELOGLOCK (ID, LOCKED) VALUES (1, FALSE);
Column FALSE not found in LB_TEST.DATABASECHANGELOGLOCK.
So LB 3.0.7 goes on and also tries to set the lock by inserting a