Liquibase 3.0.8 Released

Liquibase 3.0.8 is officially released. It is purely a bugfix release that covers improvements to data type handing, performance improvements, and much more.

Download

Download Liquibase from https://www.liquibase.com/download or from the Maven repository as it winds its way through the mirror process. Visit the user forums if you have any questions.

All Closed Issues

• CORE-1224 - Enum column types are not appropriately represented in the change log created by generateChangeLog
• CORE-1299 - modifyDataType does not auto reorg on DB2
• CORE-1302 - MySQL syntax for autoincrement column with start value
• CORE-1357 - Postgresql sequences create error in log files
• CORE-1368 - Unable to recreate DB from generated change logs
• CORE-1427 - Not generateChangeLog properly for INT2 type for Postgres
• CORE-1430 – When I was in sybase database using liquibase create the index, reported “information_schema.constraints” not found error
• CORE-1432 - Liquibase H2 InsertOrUpdateGeneratorH2 fails if primary key column name contains $ character
• CORE-1446 - Liquibase changelog generation can add linefeed to defaultValueComputed if last column
• CORE-1454 - Precondition negation does not seem to work
• CORE-1455 - Value not taken into account when inserting data with YAML
• CORE-1484 - very poor performance of dropAll on Oracle
• CORE-1496 - Custom Change validation happening before being fully initialized
• CORE-1531 - includeAll with relativeToChangeLogFile fails under certain conditions
• CORE-1537 - Liquibase: diffChangeLog on DB2 performing out of order steps
• CORE-1538 - diffChangeLog for DB2 injects invalid characters in xml
• CORE-1540 – Call ‘Reorg table’ after modifyDataType on DB2
• CORE-1541 – Column type=”LONGVARCHAR” fails
• CORE-1545 - Oracle wrong LONG datatype declaration
• CORE-1547 - CLONE - H2 (and other) support for BLOB and CLOB is incorrect
• CORE-1548 - Oracle Data Type: DATE - defaultValueComputed should be defaultValue
• CORE-1549 – Oracle Data Type: INTERVAL YEAR TO MONTH – returned at “INTERNAL(2) YEAR”
• CORE-1550 - Oracle Data Type: NCLOB - Receive SQL error when specifying NCLOB size
• CORE-1551 - Oracle Data Type: NCHAR
• CORE-1552 - Oracle Data Type: NVARCHAR2 - Column sizing is wrong
• CORE-1553 - dropDefaultValue does not work on SQL Server
• CORE-1554 - dbDoc for Informix IDS
• CORE-1555 - Oracle UID reserved word not detected
• CORE-1557 - Mysql: BLOB type changes to LONGBLOB
• CORE-1559 – Columns defined as “serial” are created as “int” without autoincrement in Postgres
• CORE-1562 - update throws Recoverable Exception
• CORE-1564 - Broken links in dbDoc
• CORE-1566 - DB2 Datatype - DBCLOB, GRAPHIC, VARGRAPHIC doubling datatype size
• CORE-1567 - DB2 Datatype - defaultValueComputed being used instead of defaultValue for DBCLOB, TIME, TIMESTAMP, DATE
• CORE-1568 - DB2 Datatype - REAL and XML should not have datatype sizes
• CORE-1571 – updateDatabase can’t find a changelog
• CORE-1572 - Regression: diff generates full schema instead of changes when using liquibase-hibernate4
• CORE-1580 - Mysql SET type not handled correctly
• CORE-1581 - modifyDataType ignores additional info of newDataType
• CORE-1582 - SQLServer datatype for TIMESTAMP
• CORE-1583 - Wrong datatype with renameColumn
• CORE-1584 - Unable do rollback not in transaction block
• CORE-1586 - MySQL DataType - defaultValueComputed being injected into TIMESTAMP, VARBINARY, BINARY, YEAR
• CORE-1587 - MySQL Datatype - VARBINARY vs LONGBLOB confusion
• CORE-1588 - MySQL DataType - BIT size and default not captured on Snapshot
• CORE-1589 - MySQL DataType - BLOB becomes LONGBLOB
• CORE-1590 - MySQL DataType - DOUBLE sizing not persisted on snapshot
• CORE-1591 – MySQL DataType – TIME not persisting seconds (getting hours and minutes..so I’ve got that going for me.)
• CORE-1592 - MySQL DataType - TEXT converted to LONGTEXT
• CORE-1594 – PostgreSQL ‘bigserial’ type is automatically converted to ‘bigint’
• CORE-1595 - Schema version incompatibility is logged as INFO instead of WARN
• CORE-1596 - Liquibase 3.0.5 will not create tables in dbo schema in SQL Server
• CORE-1597 - ORA-01000: maximum open cursors exceeded
• CORE-1600 – “Collation” and “Lateral” are not escaped in Postgres (new reserved words in v9.3)
• CORE-1602 - DatabaseException in changesets that include date fields with default values
• CORE-1603 – MySQL Datatype – BIGINT, INT, MEDIUMINT, SMALLINT, TINYINT all “shaving” off sizes
• CORE-1606 - MySQL - TEXT vs. LONGTEXT for diffChangeLog presents CLOB
• CORE-1607 - MSSQL java.sql.Types.TIMESTAMP should map to DateTime
• CORE-1610 - MSSQL - NTEXT type being snapshot with MSSQL driver default size parameter.
• CORE-1611 - Avoid reverse DNS lookup with getLocalHost().getHostName();
• CORE-1612 – YAML/JSON changelogs not picking up “value” attribute on column configs
• CORE-1614 - mysql case insensitive affects databasechangelog creation
• CORE-1615 - Failed to drop default value in MSSQL
• CORE-1616 - SQLFileChange uses too many file descriptors
• CORE-1619 - MSSQL: preconditions treat object names in a case-sensitive way
• CORE-1622 - Ant not respecting diffTypes=data
• CORE-1623 – MSSQL: precondition primaryKeyExists doesn’t work
• CORE-1625 - H2 Blob Type support is incorrect
• CORE-1626 - createIndex does not work for function based indexes anymore
• CORE-1627 – Option ‘diffTypes’ does not accept type ‘indexes’
• CORE-1632 – It’s impossible to setup Logger’s log level with system property ‘liquibase.defaultlogger.level’
• CORE-1636 - Case sensitivity issue with tableExists precondition
• CORE-1640 - foreignKeyExists precondition always failing
• CORE-1641 - Add column with foreign key throws NPE
• CORE-1644 - ValidationFailedException after update to 3.0.7
• CORE-1646 - Exception when comparing two schemas
• CORE-1647 - Mysql enum default values not quoted
• CORE-1648 - Mysql columns with colons and other special chars are not quoted
• CORE-1664 – MSSQL. “DATE” type doesn’t exist for MSSQL 2005 and 2000.
• CORE-1382 - Allow to create DATABASECHANGELOG* tables in another schema
• CORE-1546 - Schema-Support on Informix
• CORE-1577 - Oracle tinyint, smallint, int being created as number(38,0)
• CORE-1604 - Minor maven pom cleanups
• CORE-1635 - Generated changelog missing unique constraints should be output before foreign keys