Uploaded image for project: 'Liquibase Core'
  1. Liquibase Core
  2. CORE-1260

liquibase treat tinyint(1) as boolean in mysql when using generateChangeLog

    Details

    • Type: Bug
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 2.0.5
    • Fix Version/s: 4.0.0
    • Environment:

      db:mysql

      Description

      If the type of column is tinyint(1) with a default value 2, liquibase may failed as:
      liquibase.exception.DatabaseException: java.text.ParseException: Unknown bit value: 2
      at liquibase.snapshot.jvm.JdbcDatabaseSnapshotGenerator.getColumnTypeAndDefValue(JdbcDatabaseSnapshotGenerator.java:404)

      Since tinyint of mysql may store any integer in the range -128..127, tinyint(1) can be used as numeric type sometime.

        Attachments

          Activity

            People

            • Reporter:
              crystal Crystal (Inactive)
            • Votes:
              2 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

              • Created:
                Updated: