MySQL Bugs: #9867: Functions: Function which returns BIT cannot be created.

Bug #9867	Functions: Function which returns BIT cannot be created.
Submitted:	13 Apr 2005 12:28	Modified:	9 May 2005 7:58
Reporter:	Disha	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server	Severity:	S2 (Serious)
Version:	5.0.3	OS:	Windows (Windows 2003)
Assigned to:	Dmitry Lenev	CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:

Creating a function with BIT data type should not be stopped. Even though some database engines donot support BIT data type, function creation should always succeed.

How to repeat:
1) Create function fn1 () returns Bit(8) return 'a' //

Actual Result:
ERROR 1178 (42000): The storage engine for the table doesn't support BIT FIELD

Expected Result:
No such error should occur. We are only creating a function.

Hi!

I can't repeat this issue with current snapshot of 5.0. Since there were changes in this area recently (particularly see bug #7648) I assume that this bug is fixed now. So I am closing it.