Liquibase 3.8.8 Released, Provides Minor Bug Fixes

Bug Fixes

For both Liquibase Open Source and Liquibase Pro users, the following bugs were fixed in version 3.8.8:

• rollbackOneChangeSetSQL now works correctly with the Liquibase Maven plugin.
• Liquibase Pro no longer generates procedural code with incorrect SQL syntax when running generateChangeLog against a MySQL database.

Liquibase 3.8.7 Overview

Liquibase 3.8.7 Extends Targeted Rollbacks Capabilities for Liquibase Pro

We are excited to announce with the release of Liquibase 3.8.7, Liquibase Pro users now have additional targeted rollback capabilities with two brand new commands! The creation of the rollbackOneUpdate command allows users to rollback their last update, or target any previous update with a --deploymentId parameter, and our new rollbackOneUpdateSQL command allows you view the SQL your rollbackOneUpdate command would produce prior to deploying it. That way, you can ensure you don't encounter any unintended consequences before rolling back.

Each one of these commands come with their own --help to give you friendly command-specific assistance when you need it most. Just type liquibase rollbackOneUpdate --help or liquibase rollbackOneUpdateSQL --help to find what you need.

To also help you navigate the Targeted Rollback waters, our fantastic engineers have created a brand new command available to both Liquibase Open Source and Pro users, we call this command history. The history command lists out all of your deploymentIds and all changeSets associated with each deploymentId so you can inspect a group of changes to ensure they have been applied to the database. Just type liquibase history into your command line to see it in action. Don't forget, you can also use a --outputFile parameter to write this information to a text file!

Bug Fixes

Liquibase 3.8.7 also continues our initiative to make Liquibase bigger, badder, and even better than before. For both Liquibase Open Source and Liquibase Pro users, the following bugs were fixed in version 3.8.7:

• --help was improved to include missing commands and correct information.
• CompositeClassLoader does not implement getResource(String)

Liquibase 3.8.6 Overview

Windows and MacOS installers

In addition to the existing zip/tar distributions, there are now liquibase-installer.exe and liquibase-installer.dmg graphical installers.

These installers include everything you need to run Liquibase (including Java) to make getting started easier than ever.

GETTING_STARTED.txt

Regardless of how you install Liquibase, there is now a GETTING_STARTED.txt file that points you to some sample projects to start trying Liquibase as quickly as possible.

Targeted Rollbacks for Liquibase Pro with 'rollbackOneChangeset' command

You asked, and we listened! With the release of Liquibase 3.8.6, Liquibase Pro users will now have additional rollback capabilities with Targeted Rollback, a powerful new feature that allows you to target one changeSet to rollback, without affecting all the other changeSets which followed it. Think "git cherry pick" for rollbacks.

We even added a helper command "rollbackOneChangsetSQL", which will show you the SQL that will be used in the rollbackOneChangeset command.

You can now also receive command specific help for Targeted Rollback by typing in either
liquibase rollbackOneChangeSet --help or
liquibase rollbackOneChangeSetSql --help.

Bug Fixes

Liquibase 3.8.6 also continues our initiative to re-engage with our users by bringing new bug fixes to our Liquibase platform. For both Liquibase Open Source and Liquibase Pro users, the following bugs were fixed in version 3.8.6:

• excludeObjects& includeObjects parameters now works correctly when running diff.
• dataOutputDirectory parameter will now specify statement csv files appropriately.
• Updated default MySql driver to com.mysql.cj.jdbc.Driver

Liquibase 3.8.5

We've fixed a number of issues with this release.

Bug Fixes

For both Liquibase Open Source and Liquibase Pro users, the following bugs were fixed in version 3.8.5:

• Fixes issue in which Liquibase did not add DESC to an id column
• CLI once again accepts sqlFile, delimiter, rollbackScript, and outputSchemaAs arguments
• Fixes Stored Procedure whitespace impacting update calls
• Fixes generateChangelog failure when there are missing NOT NULL constraints
• Fixes updateSQL, which was not including schemaName for package bodies
• Fixes bug in which Liquibase was not always capturing create package body while generating changeLog
• Liquibase CLI now gives a more useful error message when an invalid character is passed to a command
• Fixes an MSSQL issue, which threw an exception when doing diff/diffChangeLog between offline connections (such as when snapshotting json files)
• Fixes an MSSQL issue, which incorrectly generated datetime data type column when using diff & diffChangeLog Liquibase Maven plugin fails while executing/using "diff" and "generateChangeLog" with PostgreSQL)

Liquibase 3.8.4 improves support for Liquibase in Spring Boot with Java 9+

For both Liquibase Open Source and Liquibase Pro users, the following bugs were fixed in version 3.8.4:

• Fixed a 'Class not Found' exception error when using Java +9.
• Fixed a 'Cannot Use Default Schema Name' error when users diff against an SQL Server snapshot file.
• Fixed an 'Unexpected type: java.util.Date' error when using a defaultValueDate attribute in a YAML changelog.

Liquibase 3.8.3 improves support for Liquibase-Maven plugin and Java 9+

It is true, sometimes things break. Sorry! However, with the release of Liquibase 3.8.3, users of both Liquibase Open Source and Liquibase Pro can enjoy improved Liquibase-Maven plugin experiences, especially when using Java 9+.

Bug Fixes

For both Liquibase Open Source and Liquibase Pro users, the following bugs were fixed in version 3.8.3:

• Liquibase-Maven plugin now works with Java 9+.
• Expired license messages should be far less verbose and excitable.

LIQUIBASE 3.8.2

With the release of Liquibase 3.8.2, Liquibase Pro users, along with support, can now enjoy even more database change control with the capability to capture and export Stored Logic objects, such as triggers, procedures, functions, and more.

WHAT’S NEW IN VERSION 3.8.2

Liquibase Pro Only: Stored Logic Objects are now captured for Postgres and DB2, so users can reverse engineer database changes, and capture triggers, functions, procedures, and more using generateChangeLog, snapshot, diff, and diffChangeLog commands.

Liquibase Pro Only: Stored logic objects will now export into local directories and files.

BUG FIXES

For both Liquibase Open Source and Liquibase Pro users, the following bugs were fixed in version 3.8.2:

• Using generateChangeLog/diffChangeLog to generate formatted sql changelogs now works with Liquibase Pro's stored logic support
• CDI-related classes moved back out of the main liquibase jar into an optional jar
• Fixed issue with indexes backing foreign keys not always being caputured in diffChangeLog/generateChangeLog
• Fixed issue with diffChangeLog/generateChangeLog generating primary keys when column order doesn't match the table's column order

• [PRO] Oracle and SQL Server users can now reverse engineer database changes for stored logic such as triggers, functions & procedures using generateChangeLog, snapshot, diff, and diffChangeLog commands. 

• Bugfixes in logging and outputFile
• Bugfixes in SQL Server index snapshot

[CORE-2379] - Project.version set to 3.3.4-SNAPSHOT in 3.3.4 final

[CORE-2360] - Maven - Skip is active by default
[CORE-2199] - Liquibase adds a semicolon after a stored proc definition making the stored proc unusable
[CORE-2344] - Unknown host exception on OS RHEL 6.5
[CORE-2346] - IncludeAll does not work when runing liquibase from inside a jar
[CORE-2357] - alterSequence does not work as expected when you need to change the cache size
[CORE-2366] - Derby Network server works with command line but not with maven "Liquibase skipped due to maven configuration"
[CORE-2368] - No SQL outputted for change

[CORE-1768] - Oracle dropAll fails on spatial tables and sequences
[CORE-1840] - Liquibase fails when run on a computer that can't connect to the internet
[CORE-1857] - Wrong column size detection on varchar2 fields with char as datatype
[CORE-1866] - Filtering changelog list by includeAll tag is not working
[CORE-1943] - Handle Error: InetAddress.getLocalHost().getHostName() UnknownHostException results in NoClassDefFoundError
[CORE-1958] - Column type of "TIMESTAMP(6)" under MySql converted to TIMESTAMP dropping fractional seconds
[CORE-1967] - includeAll uses full file path for sql changelogs
[CORE-2023] - Problem using includeAll with SpringLiquibase
[CORE-2126] - Postgres 9.3 - Drop table With Cascade - Not Supported
[CORE-2156] - Resource loader can't load changelog file
[CORE-2186] - AbstractResourceAccessor#convertToPath(String, String) fails for processing includeAll from Classpath
[CORE-2192] - NoSuchMethodException when generating offline Oracle migration script
[CORE-2199] - Liquibase adds a semicolon after a stored proc definition making the stored proc unusable
[CORE-2202] - liquibase.should.run inverted boolean
[CORE-2204] - valueNumeric not being set when using prepared statements
[CORE-2206] - diffChangeLog with JPA-annotated entities causes ConcurrentModificationException
[CORE-2208] - Typo in message
[CORE-2210] - java.lang.NullPointerException when file is empty
[CORE-2214] - When inserting string value starting and ending with apostrophes (quotes) the value is not quoted in the generated SQL
[CORE-2218] - Regression on modifyDataType : VARCHAR2 was supported on 3.2...and fails on 3.3
[CORE-2239] - Remarks attribute in renameColumn causes parse error
[CORE-2240] - setDropFirst(true) still broken on empty database
[CORE-2262] - 3.3.2 ant task dies on NPE in ChangeLogParameters
[CORE-2263] - Index Snapshot - doesn't include upper cased name indexes when db is NOT case sensitive
[CORE-2274] - Ant Upade Task does not consider changeLogFile correctly if it is contained in a JAR
[CORE-2279] - Rollback fails in MS SQL 2008 using liquibase 3.3.2
[CORE-2284] - Creating a DatabaseChangeLog() results in NPE
[CORE-2290] - Liquibase gives different results from Ant and the command line
[CORE-2301] - Regression from 3.2.3 in mssql 2000 unsupported usage of varchar(max) and sys.extenden_properties
[CORE-2304] - Autoincrement on type INT4 fails
[CORE-2310] - IncludeAll Fails with Unknown Reason Error
[CORE-2315] - NPE in CommandlineResourceAccessor
[CORE-2325] - Liquibase - New versions break DB create
[CORE-2329] - Escaped reserved keywords in HSQL are stored in lower case instead of upper case.
[CORE-2330] - includeAll uses full file path with includeAll
[CORE-2261] - UpdateSQL needs to append a "/" to the end of createProcedure for Oracle
[CORE-2287] - Improve support for Groovy-based tests in Eclipse
[CORE-2296] - Upgrade Groovy and Spock to maintained versions
[CORE-2318] - Add support for converting BigDecimal objects to a SQL string via DataTypeFactory

• Support for ignoring objects in diffChangeLog and generateChangeLog
• Bugfixes
• [CORE-875] - Ignore tables for diffs and generateChangelog
• [CORE-1877] - SQLOutput prints endDelimiter regexes
• [CORE-2114] - AddAutoIncrement on Postgres does not work when changes are applied on a specific schema
• [CORE-2141] - handling dependencies and WAR as classpath
• [CORE-2166] - SpringLiquibase: includeAll within jar causes SetupException
• [CORE-2172] - dropPrimaryKey without constraint name on sql server doesn't honour schema information
• [CORE-2174] - Bad exception handling in OracleDatabase.setConnection
• [CORE-2180] - NPE with bad name
• [CORE-2182] - ClassLoader leak due to shutdown hooks

• 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

• 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

• 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

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

• 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

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

• [CORE-14] - Dropping default values with MS-SQL
• [CORE-822] - Add a tag to add/update table/column remarks
• [CORE-864] - loaddata performance enhancement
• [CORE-1411] - MariaDB support
• [CORE-2254] - Ability to save snapshot for later comparison
• [CORE-2257] - Ability to use a previously saved database snapshot in diff and generateChangeLog
• [CORE-2302] - Add ability to load nested object/collection properties and BigDecimal properties automatically
• [CORE-2306] - Support passing in a script for rollback to override rollback logic included in the changelog
• [CORE-2308] - Track changeSet contexts and labels in databasechangelog table
• [CORE-2345] - Add XML Type
• [CORE-419] - Allowing ASC and DESC in index definitions
• [CORE-562] - Allow naming of not null constraints
• [CORE-715] - indexExists does a full snapshot
• [CORE-1731] - Support autoincrement in oracle 12c
• [CORE-2124] - Ability to pass properties to a JDBC driver required
• [CORE-2132] - Error message for missing sqlFile reference should be more descriptive
• [CORE-2147] - HsqlDatabase should emit uppercase names when quoting reserved words to preserve case insensitivity
• [CORE-2171] - New ChangeExecListener.runFailed method
• [CORE-2177] - Support NOT(X) syntax for labels
• [CORE-2185] - Few fields needs to be changed as protected and need additional field in RanChangeSet
• [CORE-2217] - Add DataTypeFactory support for delimited data type names, improve resolution of MSSQL data types
• [CORE-2228] - New usingIndexName attribute on addPrimaryKey
• [CORE-2236] - Support .yml extension in YamlChangeLogSerializer
• [CORE-2244] - Handle generating SQL Server DDL where ANSI NULL Default is false
• [CORE-2249] - Index and UniqueConstraint equivalence check should take name into account
• [CORE-2288] - Do not check/updatedatabasechangelog table on status
• [CORE-2292] - New tagExists command for command line
• [CORE-2298] - Allow HSQL to use defaultValueComputed for certain allowed functions on datetime type columns
• [CORE-2299] - Add capability to ignore missing or empty folder with includeAll
• [CORE-2307] - ChangeLog table name option in command line tool
• [CORE-2309] - global/local properties on changesets
• [CORE-2320] - MinGW (Git Bash) support for shell
• [CORE-2334] - Disable CREATE TABLE DATABASECHANGELOG generation when running on OfflineConnection
• [CORE-2336] - Use a grammer for parsing SQL rather than regexps
• [CORE-2358] - Improve data types for Liquibase tables in MSSQL
• [CORE-2359] - Consistently read dataTypeId for all databases
• [CORE-2363] - Improve robustness of MSSQL database case-insensitivity check
• [CORE-2371] - Improve Oracle snapshot performance
• [CORE-2386] - Set the connection default catalog/schema if defaultCatalogName or defaultSchemaName is set
• [CORE-2397] - MSSQL View Snapshot should not use sp_helptext
• [CORE-2399] - DBDoc improvements
• [CORE-2404] - Ability to preserve TEXT type in mssql snapshot and update
• [CORE-842] - Tag database not taking orderexecuted into account
• [CORE-1296] - drop column on ms sql server
• [CORE-1424] - SQL Generation ignores DATETIME parameters
• [CORE-1542] - Sequence is dropped not until a second run of dropAllDatabaseObjects on PostgreSQL
• [CORE-1738] - loadData from csv fails for boolean column (if another column present)
• [CORE-1749] - Update change command does not respect whereParams
• [CORE-1803] - DropAll doesn’t delete sequences if they are used as default value in postgres
• [CORE-1904] - Slow indexExists performance in Oracle
• [CORE-1924] - SQLServer diff - DATETIME2 not being handled correctly
• [CORE-2005] - /usr/bin/liquibase: Syntax error: "else" unexpected
• [CORE-2018] - Quotes stripped from index filter_conditions on snapshot
• [CORE-2019] - Comments in empty rollback prevent execution
• [CORE-2041] - Escaping of reserved keywords in HSQLDB
• [CORE-2096] - DiffChangeLog with changed indexes generates drop/add in the wrong order
• [CORE-2109] - dropAll fails for statements the database requires to run non-transactionally
• [CORE-2113] - Informix text datatype fixes
• [CORE-2133] - Oracle: GenerateChangeLog of a table with DEFAULT VALUE NULL creates defaultValueComputed="NULL"
• [CORE-2167] - Issues with generateChangeLog of unique constraints on DB2
• [CORE-2169] - offline mode seems non-deterministic
• [CORE-2178] - Fatal exception acquiring lock in SQL Server databases with case-sensitive collation
• [CORE-2196] - Ant: "Unable to update database." without explanation
• [CORE-2209] - Oracle snapshot sometimes creates "GENERATED ALWAYS AS (null)"
• [CORE-2211] - Liquibase tries to execute commented lines in custom SQL file
• [CORE-2219] - DB2 for zOs - adding primary key always emits REORG but REORG does not exist on Db2 for zOs
• [CORE-2222] - TIMESTAMP parameters dropped for PostgreSQL
• [CORE-2224] - Index uniqueness is not always recognized correctly
• [CORE-2227] - CLONE - UpdateSQL needs to append a "/" to the end of createProcedure for Oracle
• [CORE-2232] - Support schema other than public on PostgreSQL
• [CORE-2233] - Oracle Timestamp precision lost in generateChangeLog
• [CORE-2234] - columnExists precondition could be much faster (Oracle, mssql)
• [CORE-2237] - YamlChangeLogSerializer does not correctly serialize a changeset
• [CORE-2251] - Adding column with type DATETIME doesn't work for PostgreSQL
• [CORE-2252] - XMLChangeLogSerializer writes array object for rollback tag content
• [CORE-2253] - Handle oracle varchar <-> clob conversions in diffChangeLog
• [CORE-2256] - Drop Sequences before Tables
• [CORE-2266] - DiffChangeLog: Invalid changelog when a primary key backing index is changed
• [CORE-2267] - Rollback fails for mixed-case objects created with QUOTE_ALL_OBJECTS
• [CORE-2270] - Doubledash inside quoted text causes parsing error
• [CORE-2271] - CLONE - DiffChangeLog: Invalid changelog when a unique constraint backing index is changed
• [CORE-2272] - DiffChangeLog must drop foreign keys before primary keys
• [CORE-2273] - Oracle char column snapshot not differentiating between a default value of 0 and '0'
• [CORE-2275] - YAML update fails with Unexpected error running Liquibase: java.util.LinkedHashMap cannot be cast to java.util.List
• [CORE-2281] - Oracle snapshot performance issue with many multiple views
• [CORE-2291] - ObjectQuotingStrategy not reset correctly after changeSet
• [CORE-2295] - includeAll tries to load all files instead only *.xml
• [CORE-2300] - Unsigned Int / Bigint cannot be created
• [CORE-2305] - Snapshot output too verbose
• [CORE-2316] - Data type registry occasionally returns wrong data type implementation
• [CORE-2321] - Liquibase tag command tags too much
• [CORE-2324] - diffChangeLog does not handle changes in sequence incrementBy, maxValue or ordered
• [CORE-2331] - Support for MSSQL collation in data type description broken
• [CORE-2340] - Add support for extensions to override the built-in change log, snapshot serializers
• [CORE-2355] - Improve updateSQL performance
• [CORE-2361] - preConditions, rollback, property, include, includeAll cannot be serialized
• [CORE-2373] - Local DTD files not found in subdirectory
• [CORE-2378] - Adding a new "CustomChange" triggers ClassNotFoundException
• [CORE-2380] - Support reading of gzip files
• [CORE-2381] - Fix unique constraint generator for informix
• [CORE-2383] - Change formatted SQL stripComments default from "true" to "false"
• [CORE-2385] - IncludeAll does not work when runing liquibase from inside a jar
• [CORE-2387] - dropPrimaryKey without constraint name on sql server doesn't query schema correctly
• [CORE-2388] - Views not equal in different schemas
• [CORE-2390] - NullPointerException when generating changelog
• [CORE-2391] - column type doesn't respect unsigned
• [CORE-2393] - changeSet contexts created with maven generateChangeLog are in parentheses
• [CORE-2401] - MSSQL handling timestamp according to sql standard, not sqlserver usage
• [CORE-2402] - Oracle NCLOB defaultValues not read correctly

• [CORE-998] - Changing index columns leads to wrong output order in the change log xml file.
• [CORE-2104] - ConcurrentModificationException iterating over System.getProperties().entrySet()
• [CORE-2385] - IncludeAll does not work when runing liquibase from inside a jar
• [CORE-2405] - Collation not preserved, depending on configuration
• [CORE-2406] - Escaped built-in data types should be lower case
• [CORE-2408] - Unknown column 'LABELS' in 'field list'
• [CORE-2410] - Snapshot should not include paramaters for MSSQL geometry, geography or sql_variant types
• [CORE-2411] - BLOB string default values not quoted
• [CORE-2412] - Handle Oracle BFILE types
• [CORE-2414] - CLONE - generateChangeLog creates DOUBLE(22) instead of double in MySql
• [CORE-2415] - Custom Logger configuration does not work anymore
• [CORE-2416] - Diff drops and creates primary keys for all tables
• [CORE-2418] - Liquibase 3.4.0 tries to do INSERT instead of UPDATE-Statements with Postgres
• [CORE-2421] - MySQL column sizes are off by 1 in BIGINT and INT for diffChangeLog
• [CORE-2422] - Liquibase intialisation failed
• [CORE-2423] - Sybase IQ : strange procedure called
• [CORE-2426] - Default schema name missing quotes.
• [CORE-2427] - Better handle MSSQL stored procedures with a different defaultSchema and replaceOnExists=true
• [CORE-2428] - liquibase 2.0.3 to 3.3.3
• [CORE-2435] - includeSystemClasspath switch actually includes SystemClassLoader if false
• [CORE-2436] - Logging in ClassLoaderResourceAccessor prevents installation of custom Logger
• [CORE-2437] - Index.toString() contains "unique" if and only if index is NOT unique
• [CORE-2438] - DeleteGenerator does not handle parameter names and values with $ or \ properly
• [CORE-2440] - Not possible to override DefaultLogger using a Logger in a non-liquibase package.
• [CORE-2441] - Creation of foreign key fails in MySQL if database name contains dashes
• [CORE-2442] - Creating MD5 checksum fails if changeSet id contains the character "?"
• [CORE-2443] - Liquibase 3.4.0 ignores third party loggers in certain situations
• [CORE-2446] - endDelimiter splitting does not work in plain SQL files (regression)
• [CORE-2452] - Index names should be quoted on SQL Server
• [CORE-2458] - loadUpdateData will not update
• [CORE-2460] - Postgres index names cannot include schema name
• [CORE-2433] - quoting error in table creation
• [CORE-2359] - Consistently read dataTypeId for all databases
• [CORE-2419] - Support fluent/builder-style change properties
• [CORE-2449] - Correctly detect "Sybase IQ"
• [CORE-2450] - Non-bash /bin/sh gives "[[ not found" error
• [CORE-2451] - SQL scripts should have "USE " in the header on SQL Server
• [CORE-2453] - Informix: Return null for connection schema name
• [CORE-2459] - Un-change Formatted SQL stripComments default back to true
• [CORE-2461] - Don't do DATABASECHANGELOG ALTER statements if column types are different