Bug #26853 DATETIME columns allow "Auto Inc" to be checked
Submitted: 5 Mar 2007 23:02 Modified: 12 May 2009 12:49
Reporter: Marc Hodgins (Candidate Quality Contributor) Email Updates:
Status: Won't fix Impact on me:
None 
Category:MySQL Administrator Severity:S3 (Non-critical)
Version:1.2.10 OS:Windows (Windows XP)
Assigned to: CPU Architecture:Any
Tags: qc

[5 Mar 2007 23:02] Marc Hodgins 
Description:
When creating a new column, those of Datatype DATETIME currently allow the "Auto Inc" field to be checked.  When doing so and then clicking "Apply Changes", this results in MySQL Error Number 1063 "Incorrect column specifier for column 'column_name'" since DATETIME columns can not be autoincrement.

How to repeat:
Start MySQL Administrator
Click Catalogs
Click a Schema
Click "Create Table"
Create a column of Datatype DATETIME
Check "Auto Inc"
Click "Apply Changes"

Suggested fix:
Disable "Auto Inc" field on DATETIME columns
[6 Mar 2007 5:30] Valeriy Kravchuk 
Thank you for a bug report. Verified just as described.
[12 May 2009 12:49] Susanne Ebrecht 
Many thanks for writing a bug report. We are on the way to implement full functionality of MySQL Administrator into MySQL Workbench. We won't fix this anymore in MySQL Administrator because this is already fixed in Workbench.

More informations about MySQL Workbench you will find here:

http://dev.mysql.com/workbench/