SMALLINT and MEDIUMINT with autoincrement in the changelog fails on update

General Discussion
1

Autogenerated a changelog from an existing MySQL database, and got some errors when trying to sync the changelog with the database afterwords.


SMALLINT and MEDIUMINT fails if autoincrement is true. The strange thing is that if I try to create a table with e.g SMALLINT(5) and autoincrement in the annotated SQL format it works fine.


This works:

  2. --liquibase formatted sql

  4. --changeset sigurd:1
  5. create table department (
  6. at liquibase.integration.commandline.Main.main(Main.java:138)
2

I’m having the same problem. Filed it here:

https://liquibase.jira.com/browse/CORE-1336