MySQL Bugs: #16760: Incorrect Column Specifier

Bug #16760	Incorrect Column Specifier
Submitted:	24 Jan 2006 23:48	Modified:	14 Jun 2006 15:13
Reporter:	Ilya Tsymbal	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Migration Toolkit	Severity:	S3 (Non-critical)
Version:	1.0.21 rc	OS:	Windows (Windows XP)
Assigned to:	Michael G. Zinner	CPU Architecture:	Any

Description:
While migrating from SQL Server 2005 Express, got an error:

During migration on a table, migration fails with a message 'Incorrect Column Specifier'. This happens during Object Creation stage. 

How to repeat:
During migration on a table, migration fails with a message 'Incorrect Column Specifier'. This happens during Object Creation stage. 

SQL Table was created with SQL:

CREATE TABLE [dbo].[TABLE2](
	[UNIQUEid] [numeric](18, 0) IDENTITY(1,1) NOT NULL
) ON [PRIMARY]

SQL Create Script  for this object for MySQL becomes:

CREATE TABLE `ISIS3_dbo`.`TABLE2` (
  `UNIQUEid` DECIMAL(18, 0) NOT NULL AUTO_INCREMENT
)

Apparently DECIMAL(18,0) is not a valid definition

Suggested fix:
Change the datatype for MS SQL table to INTEGER:

alter table [dbo].[TABLE2] ALTER COLUMN UNIQUEid INTEGER 
go
This is a work-around; ideally the toolkit should be able to translate it into workable MySQL SQL.

The problem: AUTO_INCREMENT is legal only for integer data types.

Thank you for the bug report.

DROP TABLE IF EXISTS `bugdb_dbo`.`TABLE2`;
CREATE TABLE `bugdb_dbo`.`TABLE2` (
  `UNIQUEid` DECIMAL(18, 0) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`UNIQUEid`),
  INDEX `PRIMARY` (`UNIQUEid`)
)
ENGINE = INNODB;

Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.

If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html

create table `test`.`bitDatatyTableExam`( 
   `col1` bit(12) NOT NULL AUTO_INCREMENT , 
   PRIMARY KEY (`col1`)
 )

i am trying create above table but i got 
following error 

Incorrect column specifier for column 'col1'