• 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

• [CORE-2328] - AbstractExecutor should implement execute(Change)
• [CORE-2475] - Informix: Insert valueComputed not used correctly
• [CORE-2543] - Improved support for time stamps in oracle insert change data types
• [CORE-1778] - createSequence doesn't work on MSSQL
• [CORE-1840] - Liquibase fails when run on a computer that can't connect to the internet
• [CORE-2273] - Oracle char column snapshot not differentiating between a default value of 0 and '0'
• [CORE-2285] - Code in Liquibase class inconsistent
• [CORE-2317] - Custom ConfigurationValueProvider not working
• [CORE-2349] - loadUpdateData does not escape column names in "ON DUPLICATE" clause
• [CORE-2407] - Derby keywords not escaped when used as column/table names
• [CORE-2447] - In sybase, schema is bad preixed
• [CORE-2466] - Rollback referencing a change set in another file cannot be parsed
• [CORE-2467] - SSO with jtds MSSQL doesn't work after 3.3.5 for update - null user error
• [CORE-2469] - Error in method ColumnConfig.setValueNumeric(String)
• [CORE-2470] - MSSQL: FindForeignKeyConstraintsGeneratorMSSQL doesn't honor specified schema
• [CORE-2480] - Primary key exist works fine with 3.3.3 not with 3.4.0 in SQL SERVER
• [CORE-2481] - Primary key creation issue with informix
• [CORE-2482] - Number type issue with informix
• [CORE-2484] - dropAll command crashes because it drops sequences before tables
• [CORE-2487] - updateSql does not output anything for prepared statements
• [CORE-2490] - If you have more than one :name token in the where clause of a delete change, you get an Exception
• [CORE-2491] - Shouldn't a custom change produce a warning if run in updateSql mode
• [CORE-2492] - Logger extension liquibase-slf4j no longer usable with 3.4.1
• [CORE-2494] - Pgsql: Exporting/generating badly formatted SQL
• [CORE-2498] - Generation of TIMESTAMP(29) causing error in PSQL log TIMESTAMP(6) WITHOUT TIME ZONE
• [CORE-2500] - Fast check of ColumnExistsPrecondition causing transaction abort on PostgreSQL database
• [CORE-2505] - Missing keywords for H2 database
• [CORE-2510] - loadData on MySQL with > 50 rows fails
• [CORE-2544] - LogFactory does not get reset
• [CORE-2549] - Performance regression in resolving local host
• [CORE-2554] - updateSql command fails on validation when upgrading (2.0.5 ->3.4.1)
• [CORE-2566] - Maven - setting skip= true does not work
• [CORE-2571] - primaryKeyExists precondition generating wrong query
• [CORE-2576] - The 'dbms' attribute on is not not taken into account when parsing changes
• [CORE-2579] - dropAll failed for Oracle 12c
• [CORE-2580] - Escape column, table and schema on ColumnExistsPrecondition
• [CORE-2588] - Bad cast
• [CORE-2590] - Default constraint names are not quoted
• [CORE-2596] - DatabaseChangeLogLock race condition exists if two nodes both try to create the table
• [CORE-2598] - Postgres generateChangeLog: "length for type varchar cannot exceed 10485760"

Highlights

• New "created" attribute on changeSet
• New runOrder="first|last" attribute on changeSet to override where in the changelog it is ran
• New "context" attribute on and to control when changelogs are included
• Support for AND/OR context expressions in formatted SQL changelogs
• Support for changelog parameters in formatted SQL chagnelogs
• Improved multi-schema snapshot and comparison
• Improved SQL parsing
• Performance improvements
• Lots of bug fixes

Full Change Log

• [CORE-155] - Default-context attribute in databaseChangeLog tag
• [CORE-575] - foreign key constraint is generated with onUpdate and onDelete restrict
• [CORE-910] - Lock is not released if nocount is on for sql server 2008
• [CORE-1166] - Diff doesn't detect 'on delete cascade' statements
• [CORE-1447] - Inconsistent line endings in updateSQL produced files
• [CORE-1468] - Number / Numeric handling must differ between different database systems
• [CORE-1679] - Changelog SQL routines are partially aware of Database quoting strategy
• [CORE-1690] - OSGiPackageScanClassResolver does not search extensions in Fragment bundles
• [CORE-1836] - Oracle Integer mapping
• [CORE-1839] - H2 multicolumn unique constraints
• [CORE-1883] - Performance issue with large datamodels
• [CORE-1887] - Including the same ChangeSet twice causes ValidationFailedException
• [CORE-1897] - stripComments from SQL is trimming quoted string
• [CORE-1935] - Formatted SQL generateChangeLog failed
• [CORE-1966] - Invalid object name 'INFORMATION_SCHEMA.SEQUENCES' when running generateChangeLog with SQL Azure
• [CORE-1985] - constraints tag is missing referencedTableSchemaName
• [CORE-2024] - Move SDK to its own module
• [CORE-2056] - generateChangeLog generates too many 'constraints'
• [CORE-2059] - escapeObjectName has no respect for quotingStrategy QUOTE_ONLY_RESERVED_WORDS on Postgres
• [CORE-2184] - diff doesn't write correct Changesets for foreign key constraints with ON DELETE CASCADE
• [CORE-2211] - Liquibase tries to execute commented lines in custom SQL file
• [CORE-2213] - Liquibase does not support comments in a line after the semicolon
• [CORE-2333] - loadData fails with quoted string containing a comma
• [CORE-2376] - LiquibaseCatalogName in commandLine not working correctly
• [CORE-2438] - DeleteGenerator does not handle parameter names and values with $ or \ properly
• [CORE-2456] - includeObjects/excludeObjects not work for UniqueConstraint
• [CORE-2474] - dropFirst does not drop objects in not default schemas on Postgres 9+ using sql format with multiple schemas
• [CORE-2483] - Liquibase does not delete unzip directories from temporary directory
• [CORE-2501] - Derby sequenceCurrentValue Incorrect SQL
• [CORE-2502] - Handle single-tag tag on diffChangeLog
• [CORE-2504] - NumberFormatException while checking precondition
• [CORE-2508] - GlobalConfiguration liquibase.should.run alias is incorrect
• [CORE-2512] - Both defautValueComputed and defaultValue included in addColumn diffChangeLog outputs if value is a computed value
• [CORE-2513] - DiffChangeLog fixing changed indexes misses "unique" attribute
• [CORE-2514] - bad Maven documentation for outputDefaultCatalog and outputDefaultSchema
• [CORE-2517] - Foreign key snapshot improvements for DB2
• [CORE-2518] - DB2: snapshot sees DATE types as TIMESTAMP
• [CORE-2520] - Spurious warning with includeAll: file is not a recognized file type
• [CORE-2521] - addAutoIncrement on Postgres generates invalid SQL when specific schema is used
• [CORE-2522] - Derby: support for findForeignKeyConstraints
• [CORE-2523] - H2: use "REAL" as datatype for "FLOAT"
• [CORE-2524] - MSSQL: need to escape default value constraint names
• [CORE-2525] - Error on dropping sequence
• [CORE-2526] - Oracle 12: TIMESTAMP(3) not handled
• [CORE-2528] - Oracle: improve unique constraint snapshot query performance
• [CORE-2529] - MSSQL auto_increment numeric is 1 smaller in generateChangeLog
• [CORE-2531] - Wrong type mapping of BINARY type in MySQL, H2, HSQLDB and Postgresql
• [CORE-2533] - Poor runtime performance
• [CORE-2538] - regenerate maven documentation for liqubase on website
• [CORE-2545] - MSSQL: createProcedure fails if replaceIfExists=true and body uses "create proc" rather than "create procedure"
• [CORE-2547] - liquibase.database.core.DB2Database - Improper Resource Shutdown or Release
• [CORE-2548] - primaryKeyTablespace is ignored in PostgreSQL
• [CORE-2550] - Proper handling BINARY type in MySQL and H2
• [CORE-2552] - Oracle performance: fetch view definition along with original view to reduce the number of needed queries
• [CORE-2553] - DB2: add ability to disable automatic reorg statements
• [CORE-2556] - Cannot execute update code including quoted strings containing semicolons
• [CORE-2558] - includeAll incorrectly sorting by including WEB-INF/classes when running in an ear
• [CORE-2561] - Add "cycle" attribute to alterSequence
• [CORE-2562] - MSSQL: Snapshot errors if table names have single quote marks in them
• [CORE-2563] - DiffChangeLog that adds columns does not preserve column order
• [CORE-2565] - Escaping of the sequence names with schema generates invalid statements for Oracle DB
• [CORE-2581] - mysql update emits incorrect sql for BIT(1) when default specified
• [CORE-2587] - Validation not performed before rollback
• [CORE-2591] - autoincrement problem with ORA 12c + COMPATIBLE param to 11
• [CORE-2595] - DefaultPackageScanClassResolver fails if "fat" jar has dirs and files with same name
• [CORE-2599] - generateChangelog produces incorrect values for binary type
• [CORE-2601] - ORDER keyword isn't escaped for Oracle
• [CORE-2602] - StackOverflowError generating snapshot
• [CORE-2604] - PostgreSQL datatype bit(n) column gives BOOLEAN(n) type for CreateTableChange genearated sql statement
• [CORE-2605] - addColumn with multiple columns, does not create the constraints
• [CORE-2606] - PostgreSQL : Table creation with datatype smallserial fails.
• [CORE-2609] - Liquibase command line fails when using JTDS driver with SSO
• [CORE-2611] - Sybase ASE generated table name is wrong. Roll back CORE-2447
• [CORE-2615] - Multi-schema snapshot bugfixes
• [CORE-2623] - Oracle: primary keys on tables recovered from recyclebin are not properly snapshotted
• [CORE-2624] - MSSQL: better support for user defined types
• [CORE-2625] - Diff: should not be case sensitive in column default value functions
• [CORE-2629] - SQL syntax doesn't allow commenting indepenrent parts.
• [CORE-2632] - Postgres index drop needs schema
• [CORE-2635] - Applied changeset not detected
• [CORE-2636] - includeAll uses full file path
• [CORE-2637] - Creating column with tinyint(1) instead created as default tinyint
• [CORE-2641] - runOnChange change set runs every time even if there wasn't changed
• [CORE-2642] - Xsd files are not resolved from classpath when resolving from resourceAccessor fails.
• [CORE-2643] - loadData
• [CORE-2645] - Rollback referencing a change set in current child file cannot be parsed
• [CORE-2653] - Liquibase show difference for some UniqueConstraint and Views in SQL SERVER databases but Actually there is NO difference when i compare the SQL scripts manually
• [CORE-2660] - Multiple contexts not recognized in formatted SQL when using AND
• [CORE-2662] - NumberFormatException with default values of type 'real' in postgresql
• [CORE-2663] - New MySQL 5.7.x reserved keywords are not being escaped
• [CORE-2664] - createChangeLog has incorrect nesting of constraints in YAML format
• [CORE-2666] - InsertSetGenerator hard-codes the InsertGenerator
• [CORE-2669] - Impossible to extend BaseLiquibaseTask in a non-deprecated way
• [CORE-2670] - Impossible to create table on mssql with remarks containing apostrophes
• [CORE-2671] - oracle timestamps with time zone
• [CORE-2672] - createSequence with order produces invalid statement on postgresql
• [CORE-2673] - includeAll relativeToChangelogFile doesn't work for FileSystemResourceAccessor
• [CORE-2674] - LoadUpdateData with onlyUpdate="true" generates invalid statements for Oracle DB
• [CORE-2677] - Dropping a postgres index fails
• [CORE-2679] - Hibernate diffChangeLog NullPointerException @ MissingPrimaryKeyChangeGenerator.fixMissing(MissingPrimaryKeyChangeGenerator.java:76)
• [CORE-2680] - Generating a futureRollbackSql when using "classpath:" prefix doesn't recognise any of the ran change sets.
• [CORE-2681] - H2 (automatic mixed mode): createTable: columns remarks ignored
• [CORE-2683] - dropAll dropping sequences that have been dropped via earlier cascade
• [CORE-2684] - Context is ignored with runOnChange and including file (sqlFile/loadUpdateData)
• [CORE-2686] - StandardChangeLogHistoryService.hasDatabaseChangeLogTable value is cached too aggressively
• [CORE-2687] - <sqlFile endDelimiter="go" if endDelimiter has whitespace in my sql it is not spliting
• [CORE-2688] - Loading data from csv with number of rows dividable by 51
• [CORE-2689] - TIMESTAMP parameters dropped for DB2
• [CORE-2690] - SetTableRemarksGenerator double escapes remark
• [CORE-2693] - Postgresql dropAll with serial columns fails because tables are dropped then sequences which no longer exist
• [CORE-2694] - "national character varying" type is not recognized
• [CORE-2698] - Oracle scripts with ending / are not actually getting executed even with splitStatements="false"
• [CORE-2699] - concurrency causes NullPointerException in DatabaseObjectComparatorFactory.getInstance()
• [CORE-2705] - diffChangeLog generates dropColumn when dropping an index with a computed column
• [CORE-2706] - Two sides of equal are the same
• [CORE-2709] - endDelimiter regexp problem
• [CORE-2711] - Cannot load CSV via loadData
• [CORE-2713] - CreateView disregards replaceIfExists=true when fullDefinition=true
• [CORE-2715] - tableExists and columnExists preconditions fail on MySQL
• [CORE-2718] - H2 Database should query for default schema instead always use PUBLIC
• [CORE-2719] - Oracle: Cannot snapshot primary keys on lower-case tables
• [CORE-2720] - DB2: Capture full view definition in snapshot/generateChangeLog to support column options
• [CORE-2721] - endDelimiter regex does not work in SQL changelogs/changesets
• [CORE-2725] - DB2: Don't include system-generated indexes
• [CORE-521] - Handle Timestamp with Time Zone types where supported
• [CORE-2448] - New "created" attribute on changeSet
• [CORE-2478] - Liquibase dropAll command line does not allow dropping multiple schemas
• [CORE-2540] - Allow vendor independent SEQUENCE definition
• [CORE-2541] - Add support for registering a Change Exec Listener on command line
• [CORE-2560] - Add new runOrder="first|last" attribute to control when a changeSet is ran
• [CORE-2577] - Add resourceComparator attribute to includeAll to override sorting
• [CORE-2578] - Added addUniqueConstraint deferrable"support for Postgresql
• [CORE-449] - Same changeLog can be included multiple times
• [CORE-1969] - Support for AND/OR context expressions in formatted sql
• [CORE-2100] - formatted sql validCheckSum
• [CORE-2115] - Really slow when using fat jars
• [CORE-2225] - please add the OLD check sum to the validation error message
• [CORE-2336] - Use a grammer for parsing SQL rather than regexps
• [CORE-2419] - Support fluent/builder-style change properties
• [CORE-2455] - Improve messages in databasechangelog.description column
• [CORE-2463] - Don't include liquibase tables in dbdoc
• [CORE-2493] - ExecuteShellCommand improvements
• [CORE-2497] - Support setColumnRemarks and setTableRemarks on MSSQL
• [CORE-2499] - Support for commenting lines in csv files
• [CORE-2539] - Ensure each data row in CSV has same # cols as header
• [CORE-2584] - ValidCheckSum is valid for both stored database values and current changeSet checksum
• [CORE-2589] - Output xml changelogs as xml version="1.1"
• [CORE-2612] - Oracle: include BYTE in CHAR and VARCHAR types from snapshot/generateChangeLog
• [CORE-2619] - Make changeLogFile optional for changeSetExecuted
• [CORE-2622] - Maven: Support ISO date syntax for rollback
• [CORE-2626] - Use schemaName in createProcedure
• [CORE-2638] - GenerateChangeLog should include replaceIfExists=true for changed views
• [CORE-2640] - Better handling of replaceIfExists in createProcedure
• [CORE-2651] - Derby: Default unknown version to 10.6 to support sequences
• [CORE-2652] - Formatted sql precondition not expanding changelog parameters
• [CORE-2657] - Add new DATABASECHANGELOG.DEPLOYMENT_ID column to track changeSets deployed together
• [CORE-2658] - Move the liquibase-debian module to a separate profile
• [CORE-2703] - MySQL NCLOB should conver to LONGTEXT CHARACTER SET utf8
• [CORE-2724] - Support offline databases in ant-tasks

• [CORE-2727] - NPE in DiffToReport.print() method
• [CORE-2728] - Classloading broken in 3.5.0 with nested jars
• [CORE-2729] - NullPointerException on Diff
• [CORE-2731] - diff fails with NullPointerException
• [CORE-2732] - releaseLock fails because ObjectQuotingStrategy is reset to LEGACY
• [CORE-2733] - relativeToChangelogFile fails with FileSystemResourceAccessor
• [CORE-2734] - Liquibase no longer handle newline correctly in endDelimiter when using sqlFile change
• [CORE-2743] - CSV whitespace trimmed in 3.5.0
• [CORE-2744] - changeset with loadUpdateData changes checksum in 3.5.0
• [CORE-2745] - Performance degradation of sqlFile change
• [CORE-2746] - Oracle: handle case when schema name contains a hyphen
• [CORE-2750] - MSSQL catalog/database included all the time

• [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

False alarm pulled the 3.5.2 release. This is a re-release with no new changes.

• [CORE-2851] - includeAll tag with a relative path duplicates the database changes with an absolute and with a relative changelog
• [CORE-2863] - Issue with Spring boot 1.4.0 - 1.4.3
• [CORE-2898] - includeAll broken in 3.5.1
• [CORE-2948] - Changelog with includeAll will not find child changelogs in Spring Boot's executable JAR
• [CORE-2978] - AddAutoIncrement on Postgres does not work when no schema is specified
• [CORE-3123] - ResourceComparator is not applied for includeAll
• [CORE-3139] - ClassLoaderResourceAccessor cannot read jar path resources from SpringLiquibase
• [CORE-3015] - Oracle: diffChangeLog TIMESTAMP WITH LOCAL TIME ZONE correctly

[CORE-2851] - includeAll tag with a relative path duplicates the database changes with an absolute and with a relative changelog

• [CORE-1609] - Command Prompt: Can't connect to database with a special character in pwd
• [CORE-1852] - checksums depend on environment
• [CORE-1888] - Sybase error for TINYINT, INT, BIGINT: Can’t specify a length, scale or storage property on type ‘int/tinyint/bigint’.
• [CORE-2008] - H2 Supports minValue and maxValue in Sequences since Version 1.3.175, but Liquibase does not
• [CORE-2033] - NPE during Diff when case sensitive table missing
• [CORE-2135] - liquibase corrupting UTF-8 changesets
• [CORE-2162] - MSSQL: Multiple inserts in sqlFile do not fail as expected
• [CORE-2191] - Update on SQL Azure database fails due to unavailable sys.extended_properties
• [CORE-2527] - Sybase create table fails because column name is too long
• [CORE-2631] - dbdoc does not specify content type
• [CORE-2739] - --delimiter parameter in liquibase --help
• [CORE-2747] - CreateView / Oracle: Keyword REPLACE in view definition prohibits "or replace" in DDL statement
• [CORE-2772] - primaryKeyExists check fails on Turkish locale for some chars
• [CORE-2773] - DB2 AS/400 - generateChangeLog throwing Exception
• [CORE-2796] - Handle TimeStamps with nano second precision correctly
• [CORE-2797] - Determine the DB2 data server type correctly
• [CORE-2820] - Unsupported ReorganizeTable for DB2 z/OS causes changelog validation to fail
• [CORE-2821] - AddForeignKey statement generates incorrect SQL for DB2 z/OS
• [CORE-2826] - indexExists precondition fails on AS400 + JDBCDatabaseSnapshot/Snapshot generator code is not coded generically?
• [CORE-2843] - Sql wrong lexical analysis for string literals - escaped single quotes are misparsed
• [CORE-2875] - UTF-8 character not understood
• [CORE-2894] - Oracle snapshot not detecting custom datatypes in different schemas
• [CORE-2909] - column remarks for mysql should be escaped
• [CORE-2911] - Oracle: generateChangeLog on RAW types not including the size param
• [CORE-2928] - Invalid snapshot of "duplicate" foreign keys
• [CORE-2929] - Views with definitions that start with a comment are not captured correctly in generateChangeLog
• [CORE-2940] - Do not print warning when DBA_RECYCLEBIN is not available
• [CORE-2944] - outputDefaultSchema and outputDefaultCatalog command line parameters not respected
• [CORE-2953] - update with valueSequenceNext and schema produces wrong SQL on oracle
• [CORE-2965] - Custom Properties XML Changelog
• [CORE-2992] - liquibase.util.grammar.TokenMgrError: Lexical error at line 1, column 71. Encountered: "\u00b4" (180), after : ""
• [CORE-2993] - createSequence with order denied on DB2
• [CORE-3002] - SQLAnywhere: Revert Unique Index failed
• [CORE-3006] - Oracle CSV-Import: "String index out of range: -1"
• [CORE-3009] - SQLAnywhere: Drop Default Value failed
• [CORE-3020] - No warning when included file doesn't exist (missing extension)
• [CORE-3033] - typo in postgresql reserverd word
• [CORE-3040] - onlyUpdate="true" flag generates empty statements for MySQL DB
• [CORE-3046] - Fix faulty snakeyaml class-path entry after upgrade to 1.17
• [CORE-3051] - SQLAnywhere: Drop Table does not support CASCADE
• [CORE-3054] - SQLAnywhere: java-coredump on changeSet-SQL
• [CORE-3055] - SQLAnywhere: supports Sequences
• [CORE-3063] - Integration tests failing on master
• [CORE-3069] - Checksum: line endings not standardized on windows if multiple lines
• [CORE-3072] - Add usePreparedStatements="true|false" flag to loadData
• [CORE-3076] - SUM is not reserved word for HsqlDB
• [CORE-3099] - Non English environment; invalid tablename and column name can be generated because of toUpperCase toLowerCase method which is dependent to locale in java
• [CORE-3101] - dropPrimaryKey TABLE_SCHEMA = 'null'
• [CORE-3106] - SQLAnywhere: DROP INDEX should use tablename
• [CORE-3115] - Prefix space in column type causing the Unknown LiquibaseDataType with the latest release
• [CORE-3117] - TIMESTAMP WITH TIME ZONE datatype is changed to TIMESTAMP in H2
• [CORE-3119] - Maven failing to use driverPropertiesFile from Liquibase Properties File
• [CORE-3135] - Column t1.tgconstrname does not exist
• [CORE-3138] - SQLAnywhere: AddAutoIncrement-Statement is wrong
• [CORE-3140] - MSSQL2005 doesn't support built-in function original_db_name()
• [CORE-3155] - CSV line content behind inline comment character doesn't contribute to checksum
• [CORE-3162] - Diff problem with MSSQL case sensitive database
• [CORE-3171] - LoadUpdateData doesn't work on SAP SQLAnywhere
• [CORE-3180] - A DBMS-specific change set referencing a DBMS-specific rollback can't be parsed on a different DBMS
• [CORE-2735] - Add possibility to test rollback with SpringLiquibase
• [CORE-1225] - Add support for tablespace assigned to liquibase metadata tables
• [CORE-2628] - defaultSchema parameter doesn't do Connection.setCatalog() for SpringLiquibase
• [CORE-2842] - MSSQL: Support creating clustered unique constraints
• [CORE-2891] - Liquibase "Command" objects can be extended and overridden
• [CORE-2919] - Make all variants of Liquibase.listUnrunChangeSets public
• [CORE-2952] - Use the clustered index if duplicate indexes are defined
• [CORE-2955] - MSSQL: Capture explicit null default values on snapshot and generate/diffChangeLog
• [CORE-2970] - MSSQL: Support default value constraint names
• [CORE-2977] - Generated primary key constraint name doesn't match Postgres default
• [CORE-2985] - MSSQL Snapshot performance improvements
• [CORE-3000] - Oracle JDBC batch for load_data
• [CORE-3005] - Consideration of DB2/400 system views
• [CORE-3017] - Add path attribute to createView
• [CORE-3018] - Oracle: support remarks on createView
• [CORE-3045] - Support indexes on views
• [CORE-3079] - Make includeObjects and excludeObjects affect which objects are snapshotted
• [CORE-3094] - HSQLDB UUID support
• [CORE-2920] - Using "//" as an endDelimiter stopped working 3.5.0

• [CORE-3200] - Wrong SQL generator is selected
• [CORE-3201] - Command line missing required dependencies in 3.6.0 tarball
• [CORE-3198] - Configuration option to prefer internal XSD usage

• [CORE-3129] - PostgreSQL dropPrimaryKey with objectQuotingStrategy="QUOTE_ALL_OBJECTS"
• [CORE-3206] - Liquibase 3.6.x is binary api-incompatible with 3.5.x
• [CORE-3213] - Changelog with includeAll will not find child changelogs in multi-modules Spring Boot's executable JAR
• [CORE-3229] - Oracle 11g doesn't support TIMESTAMP WITHOUT TIME ZONE data type

[CORE-3100] - diff with uppercase reference database name
[CORE-3141] - ForeignKeySnapshotGenerator broken with recent SQL Server driver
[CORE-3192] - Error while including resources with includeAll directive
[CORE-3221] - Parsing valueDate Attribute of column Tag leads to precision loss and generating SQL for Oracle DB is broken
[CORE-3222] - Bin zip doesn't work due to missing slf4j-api JAR
[CORE-3231] - NPE in LogService.pushContext for MDCs that don't allow null values
[CORE-3242] - MS SQL Server 2008 support issue
[CORE-3256] - Verbose flag not getting interperated during 'status' command.
[CORE-3293] - Non global change log parameters are wrongly resolved in inner files
[CORE-3296] - CommandLineUtils::getBanner fails if manifest entries are missing
[CORE-3335] - Not possible to register/unregister SqlGenerators during execution of changeSet
[CORE-3348] - MSSQLDatabase class has a bug when connecting to SQL Server 2008 databases

• [CORE-3303] - Allow disabling shouldRun configuration via CDI integration
• [CORE-3388] - DB2 LUW supports boolean data type column from version 11.1.1.1
• [CORE-3400] - add "manifoldclass:" to list of skipped URL protocols in DefaultPackageScanClassResolver
• [CORE-2377] - Using replaceIfExists with generates DROP statements
• [CORE-2971] - Comments at end of statements are incorrectly parsed
• [CORE-3124] - Indexes with DESC sorting are not created for PostgreSQL
• [CORE-3159] - class cast exception when running command line
• [CORE-3174] - Plugin does not create parent directory
• [CORE-3211] - Firebird does not support RESTRICT option on Foreign Keys
• [CORE-3251] - SQL Server Changesets Not Escaping Keywords
• [CORE-3365] - PrimaryKeySnapshotGenerator throws NPE for SQLite
• [CORE-3375] - addNotNullConstraint on h2 still requires (unused) columnDataType
• [CORE-3386] - includeAll can't resolve relativeToChangelogFile path within a jar file
• [CORE-3437] - MariaDB 10.3.4+ problem with add column PERIOD
• [CORE-2235] - Support priority-based selection of Precondition implementation
• [CORE-3205] - Change Log Parameters from Environment Variable

Liquibase now comes in two modes:

• Liquibase Open Source
• Liquibase Pro

The 3.8.0 release adds the ability to enter a license key for a Liquibase Pro trial or full Liquibase Pro license.

Liquibase Open Source

Liquibase is open source now and always. We’ll continue to provide the great Apache v2-licensed database change and version control tool you know and love. We’re excited to provide better documentation, better community support and more functionality for many future releases.

Liquibase Pro

Liquibase Pro gives teams an option to get support and expert answers for their use case so they don’t have to go it alone. Liquibase Pro also adds functions to change sets for updating procedural database code. Liquibase Pro is available under a commercial license as a yearly subscription.

Issues addressed

[CORE-3462] - Add new procedural database code change types for Liquibase Pro

Pre-release build of 3.6.0 for testing purposes