Skip to content

Releases: liquibase/liquibase

v3.3.1

20 Aug 03:20

Choose a tag to compare

  • IncludeAll bugfixes
  • Performance improvements
  • Datatype handling fixes
  • Fix for JSON parsing
  • Other bugfixes
  • [CORE-1920] - SpringLiqubase includeAll is not including files
  • [CORE-2009] - ClassCastException when executing a custom task change (AntClassLoader problem)
  • [CORE-2097] - "mvn liquibase:futureRollbackSQL" asks for tag, count or date
  • [CORE-2099] - SQLAnywhere support (Driver not capable)
  • [CORE-2103] - changelogSchemaName/changelogCatalogName configuration options will not work on Oracle DB
  • [CORE-2104] - ConcurrentModificationException iterating over System.getProperties().entrySet()
  • [CORE-2105] - Maven profile performing dropAll and update on Oracle failing with an error on populated database.
  • [CORE-2107] - LOWER() keyword fails on Postgres createIndex task
  • [CORE-2108] - dropAll command trying to drop column on table that has already been dropped
  • [CORE-2114] - AddAutoIncrement on Postgres does not work when changes are applied on a specific schema
  • [CORE-2116] - Could not find implementation of liquibase.logging.Logger
  • [CORE-2118] - Change default diffChangeLog/generateChangeLog objectQuotingStrategy back to LEGACY
  • [CORE-2119] - Bad finally block in SpringLiquibase.afterPropertiesSet()
  • [CORE-2120] - LoadUpdateData with value=NUMERIC quoting values
  • [CORE-2121] - DB2: DiffChangeLog/GenerateChangeLog/DropAll sees alias column and tries to drop/add them
  • [CORE-2127] - updateSQL creates duplicate DATABASECHANGELOGLOCK tables
  • [CORE-2130] - setFetchSize to a negative value breaks Oracle JDBC Driver
  • [CORE-2134] - ExecuteCommand won't run with no os attribute.
  • [CORE-2136] - Mysql must quote PARTITION as a keyword
  • [CORE-2137] - Special characters ( ) copied during generateChangelog on DB2/400
  • [CORE-2139] - H2Database.supportsDropTableCascadeConstraints() returns false
  • [CORE-2141] - handling dependencies and WAR as classpath
  • [CORE-2142] - generateChangeLog not including all columns in a table
  • [CORE-2146] - snakeyaml is pulled in as transitive dependency for using projects
  • [CORE-2149] - Liquibase command line fails
  • [CORE-2150] - On the 3.3.0-SNAPSHOT, liquibase --version returns 3.2.0
  • [CORE-2153] - Liquibase 3.2.1 is no longer compatible with Oracle 9
  • [CORE-2155] - diffTypes=data fails with java.sql.SQLException: Attribute value not valid (dataOutputDirectory attribute causes build to fail)
  • [CORE-2156] - Resource loader can't load changelog file
  • [CORE-2157] - SQLException if there are single quotes in ChangeSet
  • [CORE-2159] - Datetime2 no longer used for MSSQL
  • [CORE-2161] - includeAll relativeToChangelogFile="true" doesn't work
  • [CORE-2164] - SpringLiquibase: includeAll within jar causes NullPointerException
  • [CORE-2115] - Really slow when using fat jars
  • [CORE-2125] - Make DatabaseChangeLog#include(String, boolean, ResourceAccessor) public
  • [CORE-2148] - Build failure on jdk-1.8
  • [CORE-2152] - Change logs in json format not processed by liquibase - parsing errors

v3.3.0

20 Aug 03:20

Choose a tag to compare

  • New "label" attribute on changeSet
  • New empty and output change tags
  • Support for clustered/nonclustered primary keys and indexes
  • Saving of remarks in mysql and mssql
  • Official RPM and DEB packages
  • Refactoring/update of Ant integration
  • [CORE-16] – Support for “nonclustered” primary keys in mssql
  • [CORE-54] – Support System Properties in Maven Plugin
  • [CORE-1528] – Installer for Liquibase
  • [CORE-1598] – support for rename sequence
  • [CORE-1914] – New Change function: output
  • [CORE-1942] – Support for changeSet “labels”
  • [CORE-549] – relativeToChangelogFile for loadData, loadUpdateData, sqlFile
  • [CORE-1438] – createView should support having the entire view definition in the change body
  • [CORE-1502] – CLONE – UpdateSQL needs to append a “/” to the end of createProcedure for Oracle
  • [CORE-1654] – logicalFilePath support in formatted sql
  • [CORE-1660] – “remarks” attribute is ignored in MSSQL
  • [CORE-1932] – support for encrypted passwords / custom properties
  • [CORE-1946] – Have a rpm package for liquibase (built with maven)
  • [CORE-1963] – Ability to define full CREATE VIEW statement in change.
  • [CORE-1990] – Preserve inline comments in view snapshots in mssql
  • [CORE-2060] – Support liquibase.properties files with unknown properties
  • [CORE-2061] – Improvements to Informix support
  • [CORE-2062] – Add onlyUpdate flag to loadUpdateData
  • [CORE-2064] – Use ignoreClassPathPrefix for rollback as well
  • [CORE-2065] – Use DOUBLE PRECISION for DOUBLE with Firebird
  • [CORE-2066] – Support for –outputFile in command line
  • [CORE-2067] – Refactor Ant Task codebase
  • [CORE-2068] – New liquibase.hostDescription property for additional details in the DATABASECHANGELOGLOCK table
  • [CORE-2069] – Use prepared statement in change whenever a clob type is used
  • [CORE-2072] – Do not include Oracle internal tables in snapshot/diff
  • [CORE-870] – Postgres, in an ALTER TABLE ALTER COLUMN statement, sometimes needs USING clause
  • [CORE-945] – Oracle : Temporary tables are created as regular tables
  • [CORE-1463] – Views not generated correctly with generateChangelog
  • [CORE-1556] – remarks attribute ignored for mysql
  • [CORE-1723] – unable to update on DB2/400, version V6R1, on jt400-6.7.jar
  • [CORE-1745] – afterColumn not working in MySQL
  • [CORE-1774] – Autocommit not restored on close in SpringLiquibase
  • [CORE-1882] – NullPointerException when MySQL foreign key points to an invalid table
  • [CORE-1919] – SpringLiquibase fails when dropFirst is true
  • [CORE-1922] – Sequence is not a reserved object name in HSQLDB
  • [CORE-1925] – liquibase scripts can not represent clustered indexes
  • [CORE-1937] – Oracle Float and VARCHAR precisions in changelog generated by generateChangeLog are incorrect
  • [CORE-1952] – liquibase loadData does not properly load numeric field in boolean always as false
  • [CORE-1956] – Double and float converted to FLOAT8(, 17) and FLOAT4(, 8) in PostgreSQL
  • [CORE-1958] – Column type of “TIMESTAMP(6)” under MySql converted to TIMESTAMP dropping fractional seconds
  • [CORE-1974] – dbchangelog-3.1.xsd missing
  • [CORE-1977] – CreateSequence with cacheSize=0 failing on Oracle
  • [CORE-1979] – MSSQL should not include parameters in SYSNAME data types
  • [CORE-1981] – Parameters set in included file are no longer set in 3.2.0
  • [CORE-1982] – Snapshot outputs defautlValueDate as defaultValueComputed on MSSQL for dates not in ISO format with a T in the middle
  • [CORE-1986] – includeAll from changeLogs within a jar is not working
  • [CORE-1988] – Reported size for Oracle NVARCHAR2 columns is wrong
  • [CORE-1993] – Drop table with cascade is not supported by Sybase
  • [CORE-1996] – addNotNullConstraint on h2 database has unexpected side effects
  • [CORE-1997] – Bit changelog default value of 1 executed as 0
  • [CORE-2002] – AbstractResourceAccessor generates path in a unpredictable way
  • [CORE-2010] – Oracle data type SDO_GEOMETRY snapshotted as SDO_GEOMETRY(1)
  • [CORE-2014] – applyToRollback property ignored when rollback changes are specified
  • [CORE-2015] – DiffChangeLog writes to the wrong point in the file on windows if file uses \n not \r\n
  • [CORE-2020] – Oracle default value current_timestamp converted to systimestamp
  • [CORE-2021] – Column remarks not snapshotted in mssql
  • [CORE-2026] – Oracle columns of type ANYDATA are snapshotted with a size
  • [CORE-2028] – generateChangeLog on SQL Anywhere 11.0.1 throws DatabaseException Driver Not Capable
  • [CORE-2032] – Snapshot incorrectly including clob/blob sizes on diff
  • [CORE-2051] – Not quoting VIEW params with spaces when snapshotting
  • [CORE-2054] – Add new “computed” column attribute to differentiate between an actual column name and a function as a column
  • [CORE-2063] – Fix for H2 autoincrement “start with” and “increment by” syntax
  • [CORE-2070] – dropAllForeignKeyConstraints does not work on Firebird databases
  • [CORE-2075] – generateChangelog generates bad definition for TIME type
  • [CORE-2080] – Liquibase “empty” change not present in XSD version 3.2
  • [CORE-2081] – PrimaryKeyExists precondition without tableName is broken
  • [CORE-2082] – Column snapshot on PostgreSQL does not include precision information for numeric data type
  • [CORE-2087] – Executing against Oracle doesn’t respect liquibaseSchemaName or liquibaseCatalogName
  • [CORE-2088] – outputDefaultSchema and outputDefaultCatalog command line parameters not respected
  • [CORE-2093] – Error: Property ‘relativeToChangelogFile’ not found on object type liquibase.change.core.LoadDataChange
  • [CORE-2094] – Liquibase.dropAll() should reset the lock service
  • [CORE-2095] – Invalid generated changeset for mysql bit with defaultValue 0

v3.2.3

20 Aug 03:19

Choose a tag to compare

  • Bugfixes
  • [CORE-1919] – SpringLiquibase fails when dropFirst is true
  • [CORE-1987] – “mvn liquibase:diff” does not find any differences between databases
  • [CORE-1988] – Reported size for Oracle NVARCHAR2 columns is wrong
  • [CORE-1989] – Cannot set objectQuotingStrategy on root databaseChangeLog node
  • [CORE-2002] – AbstractResourceAccessor generates path in a unpredictable way
  • [CORE-2003] – Could not find implementation of liquibase.logging.Logger
  • [CORE-2042] – If liquibase.jar is nested in another jar/war/ear, it fails to start with a “cannot find implementation of liquibase.logging.Logger” error
  • [CORE-2058] – Load/Update tags should use “is null” not “= null” for null comparisons
  • [CORE-2070] – dropAllForeignKeyConstraints does not work on Firebird databases
  • [CORE-2075] – generateChangelog generates bad definition for TIME type
  • [CORE-2080] – Liquibase “empty” change not present in XSD version 3.2
  • [CORE-2065] – Use DOUBLE PRECISION for DOUBLE with Firebird
  • [CORE-54] – Support System Properties in Maven Plugin

v3.1.1

20 Aug 03:19

Choose a tag to compare

Bug Fix release. Most critical bug is CORE-1704

  • [CORE-1704] - Checksum errors for changeSets with createProcedure in 3.1.0 vs 3.0.x
  • [CORE-1707] - TableRowCountGenerator shouldn't pass tableName as catalogName
  • [CORE-1710] - Oracle: NUMBER data type size specification is deployed with a precision specifier even though precision isn't specified in the change log
  • [CORE-1711] - rowCount doesn't work if only the tableName is given
  • [CORE-1713] - liquibase.precondition.core.ForeignKeyExistsPrecondition exception
  • [CORE-1715] - Errors if there are single quotes in comments
  • [CORE-1709] - generateChangeLog returns tables created by Materialized Views as standard tables

v3.0.8

20 Aug 03:19

Choose a tag to compare

  • Major Changes:
    Improvements to data type handling
    Bug fixes
    Performance improvements
  • [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

v2.0.5

20 Aug 03:19

Choose a tag to compare

  • Reverted load blog/clob data from files feature
  • Fixed linux distribution script
  • Fixed command line output back to stdout

v1.9.5

15 Jun 19:03

Choose a tag to compare

Last 1.x release