DataGrid 2020.1.4 can't set auto column when creating new table Follow
Answered
By just ticking all the boxes, it always raises the error "[42000][1075] Incorrect table definition; there can be only one auto column and it must be defined as a key." I had to create the id column without ticking the boxes, then alter the table to add auto and primary key setting.
Please sign in to leave a comment.
It was with MySQL 5.7
Tom Deng,
Thank you for feedback! It looks like to be a known issue DBE-8721. Follow the issue to get updates.
@Vasily.Chernov Thanks. The bug has not been fixed for 11 months and counting, not good.