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

Modeler Migrate Repeatedly Asks to Set Column Type for MySQL Database

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 4.0.2, 4.1, 4.2.M1, 4.2.M2
    • Fix Version/s: 4.2.M3
    • Component/s: Modeler
    • Labels:
      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. mysql-admin-columns.png
          5 kB
          Peter Hvass
        2. modeler-setcolumntype.png
          6 kB
          Peter Hvass

          Activity

            People

            • Assignee:
              ntimofeev Nikita Timofeev
              Reporter:
              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