[jira] [Commented] (CAY-2687) Modeler Migrate Repeatedly Asks to Set Column Type for MySQL Database

["Nikita Timofeev (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/CAY-2687?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17230480#comment-17230480 ] 

Nikita Timofeev commented on CAY-2687:
--------------------------------------

Hi [~hvass]! What MySQL server and JDBC driver versions do you use?

> Modeler Migrate Repeatedly Asks to Set Column Type for MySQL Database
> ---------------------------------------------------------------------
>
>                 Key: CAY-2687
>                 URL: https://issues.apache.org/jira/browse/CAY-2687
>             Project: Cayenne
>          Issue Type: Bug
>          Components: Modeler
>    Affects Versions: 4.0.2, 4.1, 4.2.M1, 4.2.M2
>            Reporter: Peter Hvass
>            Priority: Minor
>             Fix For: 4.2.M3
>
>         Attachments: modeler-setcolumntype.png, mysql-admin-columns.png
>
>
> 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.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)