MySQL Bugs: #9456: InnoDB: Creation of table having a BIT type field fails

Bug #9456	InnoDB: Creation of table having a BIT type field fails
Submitted:	29 Mar 2005 15:16	Modified:	31 Mar 2005 3:59
Reporter:	Disha	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Documentation	Severity:	S2 (Serious)
Version:	5.0.3 - Beta	OS:	Windows (Windows Server 2003)
Assigned to:	Paul DuBois	CPU Architecture:	Any

Description:
When we try to create a table having a BIT data type field, the creation fails with an error for the data type not being supported by InnoDB engine.

How to repeat:
Repro Steps:
  
1. Use the database 'Test' i.e. execute the following SQL statement:
	"use Test;"

2. Run the SQL statement below to create a table with BIT type field:
	"CREATE TABLE t1 (f1 BIT(8)) engine='innodb';"

3. Observe that  'create table' statement fails with an error stating 
'ERROR 1178 (42000): The storage engine for the table doesn't support BIT FIELD'
    
 
Expected Result: The table creation should succeed without any errors or warnings
   

Actual Result: The table creation fails with an error
        
mysql> CREATE TABLE t1 (f1 BIT(8)) engine='innodb';
ERROR 1178 (42000): The storage engine for the table doesn't support BIT FIELD

Additional Info : We can create table having BIT type field on MyISAM engine successfully

4.1.11 works correctly

BIT type at the moment is implemented only for MyISAM

Hi!

It is not in the TODO of InnoDB to implement a BIT type.

Why not use TINYBLOB?

Regards,

Heikki

Thank you for your bug report. This issue has been addressed in the
documentation. The updated documentation will appear on our website
shortly, and will be included in the next release of the relevant
product(s).

Additional info:

I updated the description of BIT to indicate
that it's MyISAM-only currently.