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

Difference for datatype DATETIME and DATETIME(6) not picked up

    Details

    • Type: Bug
    • Status: Open
    • Priority: Minor
    • Resolution: Unresolved
    • Affects versions: 3.5.4
    • Fix versions: None
    • Environment:

      MYSQL 5.7.22- On Ubuntu

    • Sprint:

      Description

      The Liquibase is not generating difference between two columns of datatype datetime in MYSQL.
      Liquibase says no difference found.

      Eg: Column name dob.

      Source:

      mysql> desc test;
      -------------------------------------+

      Field Type Null Key Default Extra

      -------------------------------------+

      sno int(10) YES   NULL  
      name varchar(10) YES   NULL  
      dob datetime YES   NULL  

      -------------------------------------+
      3 rows in set (0.00 sec)

      Target :

      mysql> desc test;
      -------------------------------------+

      Field Type Null Key Default Extra

      -------------------------------------+

      sno int(10) YES   NULL  
      name varchar(10) YES   NULL  
      dob datetime(6) YES   NULL  

      -------------------------------------+
      3 rows in set (0.00 sec)

        Attachments

          Activity

            People

            • Reporter:
              dpadmanabhan Dilip Padmanabhan
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated: