DataGrid 2020.1.4 can't set auto column when creating new table

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. 

3 comments
Comment actions Permalink

It was with MySQL 5.7

0
Comment actions Permalink

Tom Deng,

Thank you for feedback! It looks like to be a known issue DBE-8721. Follow the issue to get updates.

0
Comment actions Permalink

@Vasily.Chernov  Thanks. The bug has not been fixed for 11 months and counting, not good.

0

Please sign in to leave a comment.