[ https://issues.apache.org/jira/browse/CAY-2687?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17230529#comment-17230529 ]
Peter Hvass edited comment on CAY-2687 at 11/12/20, 11:17 AM: -------------------------------------------------------------- Hi [~ntimofeev]! We were able to reproduce this using two wildly different MySQL Server versions (two of our developers' local setups); - 5.6.44 - 8.0.21 JDBC mysql-connector-java; * 8.0.22 Have a great day! Peter was (Author: hvass): Hi [~ntimofeev]! We were able to reproduce this using two wildly different MySQL Server versions (two of our developers' local setups); - 5.6.44 - 8.0.21 JDBC mysql-connector-java 8.0.22 Have a great day! Peter > 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)