Issues
- liquibase.bat cannot be called from a path containing spacesCORE-3602
- Race condition for DATABASECHANGELOG table creation for concurrent start of multiple instancesCORE-3601
- oracle autoIncrement doesn't work without generationTypeCORE-3600
- Sources artifact contains rogue entries (/var/jenkins/workspace/...)CORE-3599
- SQL Server createTable column with defaultValueSequenceNext cannot find sequence, unable to specify schemaCORE-3598
- includeObjects/excludeObjects not respecting order of objects when multiple objects are providedCORE-3597
- Use LinkedHashMap for a deterministic iteration order in DependencyUtil.javaCORE-3596
- PostgreSQL primary key with autoIncrement causes "ERROR: both default and identity specified for column"CORE-3595
- Automatic dropping of default values on MS SQLCORE-3594
- InvalidModuleDescriptorException since 3.8.1CORE-3593
- generateChangelog produces incorrect values for binary type (MSSQL)CORE-3592
- updateSQL generates invalid SQL for multi statement SQL (triggers, procedures)CORE-3591
- unable to create valid postgres tables with sql changesetsCORE-3590Resolved issue: CORE-3590
- Oracle varchar2 value beginning with "to_date" is parsed as date valueCORE-3589
- Output yaml and resulting sql is ordering incorrectly for foreign keys on new columnsCORE-3588
- Postgresql foreign key across schema not recorded correctlyCORE-3587
- Unsigned Smallint cannot be createdCORE-3586
- CSV loadUpdateData fails because a space exists between column valuesCORE-3585
- sql changesets should allow setting of the tag attributeCORE-3584
- dropAll does not drop databasechangelog tableCORE-3583
- Hitting Conversion Issue When Varbinary and DateTime2 Data Type been Used in the same ChangeSetCORE-3582
- ALLOCATE support for variable fields (NVARCHAR...)CORE-3581
- sysproc.env_get_inst_info() does not existCORE-3580
- updateTestingRollback does not execute rollbacks when system timezone is ahead of UTCCORE-3579
- liquibase diff failed, Unable to resolve persistence unit root URLCORE-3578
- After migrating Java liquibase-core library from 3.6.3 to 3.7.0 the XML starts generating invalid table schema for SERIAL type in PSQLCORE-3577
- loadData fails for Postgres when column is of an enum type.CORE-3576
- runOnChange="false" does not work properly.CORE-3575
- Update snowflake extension to work with Liquibase 3.8.x+CORE-3574
- Make Liquibase AutoCloseableCORE-3573
- Unable to create an Integer column with Sybase databaseCORE-3572
- Document includeAll does so in depth recursivelyCORE-3571
- ChangeLog incorrect Postgresql; Integer becomes "Year(10)"CORE-3570
- diffCangeLog creates statement that can't be applied to DB with dataCORE-3569
- Liquibase Not Assigning Right Default Values to Primary Key Columns on MSSQL databaseCORE-3568
- Liquibase very slow to check that table does not exist on OracleCORE-3567
- Class-Path entry in the jar could simplify executionCORE-3566
- Liquibase >= 3.8.1 causes JVM EXIT when attempting to use structured loggingCORE-3565
- Attribute 'path' is not allowed to appear in element 'createView' (liquibase-maven-plugin)CORE-3564
- Split liquibase-core Jar into community and pro partsCORE-3563
- Provide better user perspective output for Update command instead of Message "Liquibase: Update has been successful."CORE-3562
- createSequence does not work with PostgreSQL below 9.5CORE-3561
- Allow to flexibility for --force continue execution of ChangeSet' s SqlQueries when encounters errorsCORE-3560
- AbstractSqlGenerator.validate shall have default empty implementationCORE-3559
- Unique constraint name is ignored when using the addColumn changeCORE-3558
- NullPointerException id 'file' empty or not defined for 'loadData'CORE-3557
- No default values for changes' properties as documentedCORE-3556
- load[Update]Data/column@defaultValue[XXX] not usedCORE-3555
- load[Update]Data treats values differently depending column type is definedCORE-3554
- Primary key of type int does not have `NUMBER generated as identity` and has not sequence created on Oracle12CORE-3553
50 of
generateChangeLog generates too many 'constraints'
Fixed
Description
Environment
PostgeSQL 9.3.5.1, OS X 10.9.5, Maven 3.2.1, Java 8, Spring Boot 1.1.7
Attachments
2
Created October 4, 2014 at 6:52 PM
Updated March 14, 2016 at 4:40 PM
Resolved March 14, 2016 at 4:40 PM
Activity
Show:
Nathan Voxland March 14, 2016 at 4:40 PM
Fixed for 3.5.0
David B Malkovsky September 22, 2015 at 12:49 PM
This issue appears to be directly related to issues https://liquibase.jira.com/browse/CORE-2439#icft=CORE-2439 and CORE-2277.
When I run the generateChangeLog command against a Hibernate-generated PostgreSQL database, I get a YAML file with the following contents. Notice that there's two 'constraints', when the correct behavior seems to be one.
databaseChangeLog: changeSet: id: 1412448028962-1 author: mraible (generated) changes: - createSequence: sequenceName: hibernate_sequence changeSet: id: 1412448028962-2 author: mraible (generated) changes: - createTable: columns: - column: constraints: constraints: nullable: false name: id type: VARCHAR(255) - column: name: content type: TEXT
If I change it from:
- column: constraints: constraints: nullable: false
to:
- column: constraints: nullable: false
then it seems to work correctly. Using Liquibase with Spring Boot.