Bug #95561 Workbench alter table uncheck AUTO_INCREMENT option
Submitted: 29 May 13:07 Modified: 29 May 14:15
Reporter: MISAEL AMORIM Email Updates:
Status: Can't repeat Impact on me:
Category:MySQL Workbench: Modeling Severity:S3 (Non-critical)
Version:8.0.16 OS:Ubuntu (Ubuntu 18.04.2)
Assigned to: CPU Architecture:Any
Tags: auto_increment, workbench

[29 May 13:07] MISAEL AMORIM
In table editor when alter the field datatype workbench disable the AUTO_INCREMENT without alert or confirmation.

How to repeat:
In workbench alter the table using the visual editor (right click, alter table) and change the datatype from INT to BIGINT.

Suggested fix:
Keeps the auto_increment for compatible datatypes or alert when disabling.
[29 May 13:50] Miguel Solorzano
Thank you for the bug report. Which exactly 8.0.X are you using?.
[29 May 14:13] Miguel Solorzano
I coulodn't repeat with WorkBench 8.0.16 when editing the column with BIGINT(20).
[29 May 14:15] MISAEL AMORIM
Workbench 8.0.16 / Ubuntu 18.04.2