Release Notes - Liquibase Core - No new issues - report new issues in GitHub - Version 3.0.0 - HTML format

Bug

  • [CORE-152] - SqlDatabaseSnapshot doesn't support multiple composite FK's
  • [CORE-154] - Composite foreign key cannot be found in foreign keys
  • [CORE-159] - generateChangeLog does not generate correct uniqueness attr.
  • [CORE-162] - I can't gen dbDoc from changeLog like this
  • [CORE-163] - Postgres contraint not dropped during rollback
  • [CORE-170] - Change Set not applied from WAR file
  • [CORE-181] - Modify Column doesn't persist NOT NULL attribute in MSSQL
  • [CORE-184] - dropAllForeignKeyConstraints only supports Postgres
  • [CORE-194] - Building diff does not honor unique indices
  • [CORE-195] - liquibase not recognizing that the indexes already exist.
  • [CORE-196] - liquibase Diff nullpointer with case sensitive columnnames
  • [CORE-201] - diffChangeLog generates not-null constraint onalready-not-n
  • [CORE-205] - MySQL: PK changes (Missing & Unexpected PK change order)
  • [CORE-211] - onUpdate="CASCADE" fails on DB2
  • [CORE-374] - HSQLDB Dialect keywords
  • [CORE-386] - sequenceExists does not detect pre-existing autoincrement sequences
  • [CORE-396] - IncludeAll: Could not find directory
  • [CORE-432] - MySQL Mediumtext column snapshots include default value
  • [CORE-450] - Liquibase converts TIMESTAMP to DATETIME on MySQL
  • [CORE-479] - UTF8 and FIrebird
  • [CORE-512] - Incorrectly generated changelog
  • [CORE-648] - JdbcDatabaeSNapshotGenerator.readUniqueConstraints() is not implemented
  • [CORE-657] - indexExists pre-condition failes to detect some indexes
  • [CORE-740] - Escaping Oracle objects (commit 1731) breaks existing liquibase files
  • [CORE-781] - 2.0.0 RC6 generateChangeLog generates redundant unique index on PK column
  • [CORE-815] - Diff does not check autoincrement correctly
  • [CORE-829] - Embedded Derby shutdown does not work with Maven
  • [CORE-832] - No tags documentation
  • [CORE-833] - Not precondition failed
  • [CORE-847] - Derby shutdown log message
  • [CORE-851] - generateChangeLog creates indexes belonging to another owner on Oracle10g database
  • [CORE-857] - Generation of invalid SQL statement from generated diff
  • [CORE-861] - Preconditions for dbms-filtered-out changesets still run
  • [CORE-884] - generateChangerLog in postgres do not generate tables that ends with "_key" in the name
  • [CORE-890] - missing final parentheses on insert
  • [CORE-891] - Column <constrants> results in syntax error with mysql 5.1
  • [CORE-892] - Exception when views are used in MySQL
  • [CORE-895] - Incorrect type generated for MySQL unsigned decimal
  • [CORE-911] - Extra attempt to lock database on sybase
  • [CORE-916] - CLONE - NullPointerException on 'status' w/o LiquiBase's tables
  • [CORE-933] - CreateTableGenerator.java ignores foreign key constraint name on Informix
  • [CORE-934] - CreateView on mssql can easily fail with replaceIfExists="true"
  • [CORE-942] - columnDataType attribute on renameColumn tag doesn't support java.sql.Types
  • [CORE-944] - Diff tool doesn't include sequences for PostgreSQL
  • [CORE-946] - diffChangeLog does not detect case differences in table names
  • [CORE-950] - Standardize line breaks for sql file changesets
  • [CORE-953] - LoadUpdateData doesn't work with postgres less than 9
  • [CORE-959] - Random select from ALL_VIEWS when creating an indexExists preCondition
  • [CORE-960] - indexExists is extremely slow
  • [CORE-969] - "All" is not escaped when creating a database snapshot on postgresql
  • [CORE-977] - StringIndexOutOfBounds in InsertOrUpdateGeneratorMySQL
  • [CORE-980] - DATABASECHANGELOG table not checked in Liquibase.listUnrunChangeSets()
  • [CORE-983] - Out of date documentation in the ANT manual
  • [CORE-989] - Invalid column name Exception in Sybase ASE 15
  • [CORE-993] - TINYTEXT is a constant type of column
  • [CORE-999] - Rollback documentation missing rollbackToDate
  • [CORE-1004] - throw "invalid column name" exception while executing generateChangeLog
  • [CORE-1008] - API at http://www.liquibase.org/api/index.html references 1.9.0
  • [CORE-1010] - tableExists and columnExists preConditions fail due to case-sensitivity on PostgreSQL
  • [CORE-1013] - Data Truncation not handled correction when having to long id value of ChangeSet
  • [CORE-1026] - Database diff index name comparsion should be optional
  • [CORE-1030] - Trailing spaces in author name of changelog prevent proper validation
  • [CORE-1035] - Cannot get loadData to work with a CSV with a DATE field
  • [CORE-1037] - CustomTaskChange should not call validate() method before the <param> methods
  • [CORE-1040] - Case sensitive identifier names and escaping
  • [CORE-1042] - NullPointerException during changelogSyncSQL
  • [CORE-1045] - liquibase-maven-plugin doesn't look for changelogs in transitive jar dependencies
  • [CORE-1049] - Preconditions should use defaultSchema if no schemaName provided
  • [CORE-1050] - Executing executeCommand by calling dbDoc
  • [CORE-1054] - Using hyphenated context names in formatted-sql changelogs can cause changesets to be silently ignored.
  • [CORE-1056] - SelectFromDatabaseChangeLogGenerator and SelectFromDatabaseChangeLogLockGenerator produces SQL that is not escaped and causes SQL exception under postgresql
  • [CORE-1057] - AbstractDatabase.supportsDropTableCascadeConstraints does not include Postgresql and Oracle in the check - those databases do support cascade constraints
  • [CORE-1058] - DropTableGenerator incorrectly checks if the database supports drop table cascade constraints
  • [CORE-1065] - nvarchar(max) should be detectable by diff
  • [CORE-1069] - dropIndex fails without a schema name supplied (sends literal "null")
  • [CORE-1073] - includeAll doesn't work with ClassLoaderResourceAccessor
  • [CORE-1083] - ModifyDataType refactoring doesn't support nullable, althought docs states such support
  • [CORE-1094] - Temp files not being cleaned up
  • [CORE-1095] - generateChangeLog on Oracle with nchar
  • [CORE-1102] - ORA-01439 thrown for MODIFY MD5SUM VARCHAR2(35) on Oracle 11g
  • [CORE-1109] - Remove log message from standard output
  • [CORE-1111] - Liquibase.dropAll() throws an error when trying to delete a table in Oracle/DB2, when the table has a quoted lower-case name
  • [CORE-1115] - indexExists precondition ignores tableName attribute
  • [CORE-1117] - JavaDoc of liquibase.integration.spring.SpringLiquibase is not up to date
  • [CORE-1120] - Lock not released if changelog "include" references non-existent file
  • [CORE-1121] - diffChangeLog on oracle DBMS fails on add Column of type NUMBER(16,6)
  • [CORE-1125] - Ignored ${liquibase.referenceUsername} and ${liquibase.referencePassword} in maven plugin
  • [CORE-1126] - checkSum is OS-dependent
  • [CORE-1131] - Rollback maven classloader change
  • [CORE-1135] - Column with missing type throws NullPointerException
  • [CORE-1136] - jacoco and liquibase
  • [CORE-1137] - Invalid sql statement for oracle DB
  • [CORE-1141] - Liquibase dropDefaultValue causes errors on SQL Server 2005 (mssql)
  • [CORE-1144] - promptForNonLocalDatabase not being used except in ant and maven
  • [CORE-1153] - Database.dropDatabaseObjects doesn't remove PostgreSQL sequences that are used as column defaults
  • [CORE-1160] - MSSQL is mistakenly marked as supporting cascade table drop
  • [CORE-1165] - Case insensitivity is broken for SQL visitors in ContextChangeSetFilter
  • [CORE-1168] - default schema determined incorrectly for db2
  • [CORE-1169] - drop table with cascade option does not work on db2
  • [CORE-1172] - Exception thrown when rolling back change sets with dollar signs in the identifier
  • [CORE-1175] - Unable to use dropAll with tables with foreign key constraints with Microsoft SQL Server
  • [CORE-1179] - Whitespace changes in SQL commands results in different checksums
  • [CORE-1182] - MSSQL syntax for autoincrement column with start value
  • [CORE-1183] - default schema determined incorrectly for mssql
  • [CORE-1184] - SQL formatted files only support a single context
  • [CORE-1189] - Error creating index when using hyphenated Oracle schema
  • [CORE-1190] - More missing keywords in OracleDatabase
  • [CORE-1191] - Special Characters are not recognized when doing output to sql file
  • [CORE-1193] - NullPointerException during generateChangeLog against MySQL (catalog issue)
  • [CORE-1194] - does not create auto-increment on mysql
  • [CORE-1195] - Databases change the auto-commit mode but do not restore it
  • [CORE-1197] - DropDefaultValue doesn't work in SQL Server 2012
  • [CORE-1198] - RenameColumnGenerator doesn't use TypeConverter in MySQL
  • [CORE-1201] - OSGI build problem
  • [CORE-1203] - Drop index problem
  • [CORE-1204] - Generate dropPrimaryKey before addPrimaryKey
  • [CORE-1209] - ISODateFormat removes leading zeros for milliseconds when formatting dates
  • [CORE-1210] - dropAll in Firebird 2.5
  • [CORE-1212] - Database.escapeStringForDatabase for mySQL does not work
  • [CORE-1213] - HSQLDB Sequence should probably default to bigint
  • [CORE-1215] - Unable to 'update' or 'generateChangeLog' in MS SQL Server '08 or '12 due to SQLServerException
  • [CORE-1216] - generateChangeLog pulls data with schema by default
  • [CORE-1220] - If Size is associated with MEDIUMBLOB or TINYBLOB update fails
  • [CORE-1222] - Wrong regular expression in databaseChangelog XML Schema
  • [CORE-1223] - add comment field to RanChangeSet
  • [CORE-1226] - Columns of type DOUBLE are saved with an unnecessary size specification during generateChangeLog that prevents update operation success
  • [CORE-1227] - Indexes with VARBINARY/BLOB/TEXT types are not created due to missing key length designation
  • [CORE-1229] - HSQLDB ViewDefinitionGenerator uses wrong SQL to query for Views
  • [CORE-1230] - [Derby] Liquibase attempts to shutdown connections to non-embedded Derby database
  • [CORE-1231] - NPE from liquibase.sql.UnparsedSql
  • [CORE-1237] - loadData generates invalid SQL for H2 db
  • [CORE-1242] - Database.doesTagExist() ignores parameter value
  • [CORE-1243] - Exception during CSV parsing is not thrown when it should be.
  • [CORE-1244] - Rollback on formatted sql throws NPE
  • [CORE-1245] - endDelimiter in Formatted SQL Changelogs
  • [CORE-1246] - Liquidbase puts wrong baseTableSchemaName into addForeignKeyConstraint
  • [CORE-1250] - primaryKeyExists and indexExists preconditions create a new database snapshot on each execution
  • [CORE-1251] - in H2, the default schema cannot be changed
  • [CORE-1252] - Remove build-helper-maven-plugin from liquibase-core/pom.xml
  • [CORE-1253] - Precondition onError="CONTINUE" still executes the changeset
  • [CORE-1255] - Change Set with numeric values like 0.001 has different checksum with Java 6 and 7
  • [CORE-1259] - Liquibase 3.0 beta 1 Liquibase Update Failed: Unknown Reason
  • [CORE-1262] - NullPointerException in AbstractDatabase if DatabaseConnection.getURL() returns null
  • [CORE-1263] - markNextChangeSetRan wrong EXECTYPE
  • [CORE-1267] - Invalid SQL rendered when creating snapshot of an H2 database, whose column names are case-sensitive
  • [CORE-1294] - Test failures trying to build 2_0_x branch.
  • [CORE-1304] - Liquibase Ant tasks change Ant's classloader to something else
  • [CORE-1307] - sequenceExists does find non existing sequence
  • [CORE-1311] - generateChangeLog: NullPointerException
  • [CORE-1349] - liquibase.diff.DiffResult#differencesFound disregards changedColumns

New Feature

  • [CORE-2] - more detailed Error-messages
  • [CORE-38] - Read unique constraints when performing a diff
  • [CORE-42] - startValue for alterSequence
  • [CORE-764] - Register custom Type converters
  • [CORE-841] - Add an option to make the tableExists preConditions convert the tableName to lowercase.
  • [CORE-939] - Properties in preconditions
  • [CORE-1082] - Add maven support for hibernate integration
  • [CORE-1106] - Allow simple rules for setting dbms a changeset is executed in
  • [CORE-1181] - Support generateChangeLog in Maven plugin
  • [CORE-1202] - Filtering changelog list by includeAll tag

Improvement

  • [CORE-480] - Generate Remarks for other databases
  • [CORE-482] - Please add relative-path attribute to the sqlFile element.
  • [CORE-497] - Add ability to move changeSets from one databaseChangeLog file to another
  • [CORE-499] - Some databases should not have FK/PK indexes removed from generateChangeLog output
  • [CORE-695] - Remove not-null constraint documenatation page should be renamed to Drop not-null constraint
  • [CORE-767] - Support renameColumn on DB2
  • [CORE-793] - Allow context to be specified per databaseChangeLog
  • [CORE-947] - using tag replaceIfExists on PostgreSql can fail
  • [CORE-956] - Do not leave zillions of temp directories like sax-liquibase123123123.dir
  • [CORE-961] - JDBC calls to getMetaData are potentially expensive - they should be logged at DEBUG level
  • [CORE-965] - Correct column tag documentation to also list the valueComputed field
  • [CORE-995] - Increase max size on DATABASECHANGELOG ID column from 63 to 255
  • [CORE-1041] - Drop FK constraint sql statements also prints schema name
  • [CORE-1044] - generateStatements should only be called once
  • [CORE-1052] - Consider adding database.defaultSchemaPrefix property
  • [CORE-1070] - Preconditions should support parameters
  • [CORE-1072] - CustomerPreconditions should have access to the same information as built-in Preconditions
  • [CORE-1076] - CustomTaskChange should be able to validate its parameters first
  • [CORE-1100] - loadUpdateData support for HSQLDB 2.2+
  • [CORE-1101] - liquibase-maven-plugin: "Liquibase skipped due to maven configuration" should be at most INFO and not WARNING
  • [CORE-1104] - Please update javadoc of SpringLiquibase
  • [CORE-1113] - Add support for calculateCheckSum command
  • [CORE-1173] - Allow for Spring controlled startup in SpringLiquibase class.
  • [CORE-1205] - Improve LiquibaseServletListener: "should run" and support for JNDI
  • [CORE-1206] - Misleading error message when using referencesUniqueColumn=true on postgres
  • [CORE-1218] - Control whether to include schemas in generateChangeLog
  • [CORE-1256] - Allow sqlFile tag to specify end of line character to prevent checksum errors in different environments
  • [CORE-1265] - Allow diff tool comparisons to be extended and/or overridden
  • [CORE-1268] - Add common API for Table and View
  • [CORE-1319] - dropAllForeignKeyConstraints runs very slowly in mysql

The text area below allows the project release notes to be copied to another document.