Liquibase 3.5.2 Released
September 21, 2016
Bugfix release Liquibase 3.5.2 is now available from liquibase.org/download and through the Maven repositories.
Highlights include:
- Formatted SQL added rollbackSplitStatements and rollbackEndDelimiter changeSet attributes
- Fixes for running in Spring boot 1.4.0
- Performance improvements
- More consistent use of the character encoding set with the liquibase.file.encoding system property
- Improvements in support for clustered primary keys
- Improved BINARY data type handling
- Upgraded to SnakeYAML 1.17
Full changelog:
- [CORE-1863] – PostgreSQL blob is mapped to bytea instead of oid
- [CORE-2693] – Postgresql dropAll with serial columns fails because tables are dropped then sequences which no longer exist
- [CORE-2698] – Oracle scripts with ending / are not actually getting executed even with splitStatements=”false”
- [CORE-2752] – Jtds has silent exceptions in db.getConnectionSchemaName
- [CORE-2753] – defaultValueSequenceNext forgets schema name
- [CORE-2754] – update table columns are not quoted when requested
- [CORE-2756] – Null pointer exception from FileSystemResourceAccessor
- [CORE-2757] – Databasechangelog ORDEREXECUTED and DEPLOYMENT_ID not updated when a changeSet is reran
- [CORE-2758] – Debian package shouldn’t symlink liquibase binary to absolute path
- [CORE-2761] – 3.5.1: includeAll from the command line uses the absolute path as the changeSet path
- [CORE-2763] – Postgresql schemas should default to lower case
- [CORE-2765] – dbms in preConditions yaml changelog causes parsing error
- [CORE-2770] – Can’t read remarks from mssql 2000
- [CORE-2774] – Can’t read all columns from mssql2000
- [CORE-2775] – Oracle Sequences not Generated in generateChangeLog after 3.4.1
- [CORE-2778] – Sybase ASE: Incorrect syntax near the keyword ‘ALTER’
- [CORE-2780] – java.sql.SQLException: PooledConnection has already been closed
- [CORE-2781] – DB2: custom-generated indexes for primary keys are not preserved in diff/generateChangeLog
- [CORE-2784] – REGRESSION: Column creation of type ‘TIMESTAMP WITHOUT TIMEZONE’ fails on PostgreSQL
- [CORE-2785] – Status command inconsistent with databasechangelog table
- [CORE-2786] – Incorrect xml scheme for changlog file
- [CORE-2787] – YAML Snapshot parser not handling strings that get stored as binary
- [CORE-2789] – Postgres does not have a type “BINARY”
- [CORE-2791] – Strip off trailing end delimiter in createProcedure on update, include on updateSql
- [CORE-2793] – using property as startWith attribute
- [CORE-2794] – Make CSV files created by Liquibase readable by Liquibase
- [CORE-2795] – Fix a NullPointerException in DiffToChangeLog.sortMissingObjects
- [CORE-2804] – defaultValueSequenceNext forgets schema name H2/PG/etc
- [CORE-2805] – Multiple calls to generateChecksum() impacting deploy performance
- [CORE-2806] – JsonSnapshotParser does not close stream after parsing
- [CORE-2807] – Column data type “real” incorrectly translated to “double precision” for PostgreSQL, should be “real”
- [CORE-2810] – defaultValueBoolean=”false” generates wrong SQL for MySQL
- [CORE-2811] – FileSystemResourceAccessor basepath/includeAll
- [CORE-2813] – java.lang.NullPointerException when creating new ClassLoaderResourceAccessor();
- [CORE-2814] – DB2: Quoting strategy not respected, objects are always saved as upper case
- [CORE-2815] – Rollback by tag doesn’t roll back tagDatabase changeSet
- [CORE-2816] – Snapshot error when snapshotting an index or primary key against a case-sensitive column
- [CORE-2818] – DEPLOYMENT_ID not created for Sybase in DATABASECHANGELOG, liquibase 3.5.1
- [CORE-2819] – AbstractJdbcData getConnectionSchemaName() methods fails for Sybase
- [CORE-2823] – DROP PRIMARY KEY fails for Sybase database update
- [CORE-2827] – MSSQL: misc default value fixes
- [CORE-2828] – MSSQL not capturing that primary key are non-clustered in generateChangeLog
- [CORE-2830] – GenerateChangeLog does not handle tables with compound primary keys
- [CORE-2831] – MySql BIT(1) defaultValue not snapshotted as Boolean
- [CORE-2835] – GenerateChangeLog doesn’t correctly “numeric DEFAULT ‘” “ columns
- [CORE-2836] – addAutoIncrement generates inconsistent sequence name for mixed-case table
- [CORE-2837] – addAutoIncrement doesn’t apply default schema in nextval call (PostgreSQL)
- [CORE-2838] – createProcedure schema in the changelog is overwritten by defaultSchemaName
- [CORE-2840] – MSSQL createProcedure for CREATE MERGE AS procedures need a trailing semicolon
- [CORE-2843] – Sql wrong lexical analysis for string literals – escaped single quotes are misparsed
- [CORE-2846] – DATABASECHANGELOG table query failed on postgres on first run
- [CORE-2849] – Fail to execute with sequences
- [CORE-2853] – Diff comparisions reporting differences between ‘0.0’ and ‘0’ in decimals
- [CORE-2863] – Issue with Spring boot 1.4.0
- [CORE-2864] – Regression for defaultSchemaName on MSSQL
- [CORE-2867] – liquibase with MySQL raises exception “Table ‘DATABASECHANGELOG’ already exists” when using separate liquibase schema
- [CORE-2868] – Adds schema/username to package and package body in oracle making them invalid
- [CORE-2869] – Without a specified classpath, using includeAll with relativeToChangelogFile=”true” fails
- [CORE-2872] – “ON DELETE” not supported for FK constraints in Sybase
- [CORE-2876] – Issue with Spring boot 1.4.0 Repackaged
- [CORE-2878] – MSSQL setTableRemarks limited to 200 chars
- [CORE-2881] – DiffChangeLog unnecessarily includes referenceTableCatalogName attribute if comparing Schema with different names
- [CORE-2885] – AddColumn with defaultValueSequenceNext generated incorrect SQL for PostgreSQL
- [CORE-2788] – handle VARBINARY type in Oracle and H2
- [CORE-2800] – Add flag to diff command that suppresses reporting of column order difference in tables
- [CORE-1984] – Support for non-split rollback statements in Formatted SQL
- [CORE-2768] – Have the .deb and .rpm part of the release on github
- [CORE-2782] – Update SnakeYAML version to 1.17
- [CORE-2801] – Add method to Logger to allow closing of the output file stream
- [CORE-2844] – Traverse parent changelogs for rollbacks
- [CORE-2848] – Oracle: primary keys that use a pre-existing index drop the index along with the primary key on rollback
- [CORE-2852] – Postgresql snapshots not correctly handling serial-backing sequences
- [CORE-2857] – Support clustered primary keys in postgresql
- [CORE-2873] – Postgresql custom types are snapshotted as having length 2147483647
- [CORE-2874] – Ensure consistent charset encoding usage
Article author
Nathan Voxland Project Founder