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

[29 Mar 2005 15:22] Disha
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 for Memory 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='Memory';"

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='Memory';
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
[29 Mar 2005 19:45] Sergei Golubchik
BIT type at the moment is implemented only for MyISAM
[31 Mar 2005 4:00] Paul DuBois
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

Additional info:

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