Uploaded image for project: 'Cayenne'
  1. Cayenne
  2. CAY-2687

Modeler Migrate Repeatedly Asks to Set Column Type for MySQL Database

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Minor
    • Resolution: Fixed
    • 4.0.2, 4.1, 4.2.M1, 4.2.M2
    • 4.2.M3
    • Modeler
    • None

    Description

      Appears to be a minor bug that has affected us from versions 4.0 through 4.2.M2.

      When migrating schema using modeler we are repeatedly asked to 'Set Column Type' for a range of columns & types - we can migrate these changes time and again only to be asked to do it again on the next run - specific types;

      • BIT -> BOOLEAN (the database already reflects that this is TINYBIT)
      • LONGVARBINARY -> BLOB (the database already reflects that this is LONGBLOB)

      Screenshot of modeler and part of our schema attached for reference.

      Attachments

        1. modeler-setcolumntype.png
          6 kB
          Peter Hvass
        2. mysql-admin-columns.png
          5 kB
          Peter Hvass

        Activity

          People

            ntimofeev Nikita Timofeev
            hvass Peter Hvass
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Time Tracking

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - 0h
                0h
                Logged:
                Time Spent - 0.5h
                0.5h