Bug #47605 Stored function disappears suddenly after adding one char into return value

• Submitted: 24 Sep 2009 11:43
• Modified: 28 Sep 2009 10:45
• Reporter: Mike Drapolyuk
• Status: Can't repeat
• Category: MySQL Server: Stored Routines
• Severity: S2 (Serious)
• Version: 5.0.67
• OS: Linux
• CPU Architecture: Any

[24 Sep 2009 11:43] Mike Drapolyuk

Description:
I have one function:

CREATE FUNCTION `f`(a BIGINT UNSIGNED, b DOUBLE) RETURNS ENUM('123456789012', '12', '123456789012345678901')

When i try to add one more character to eny enum's value, for example:

CREATE FUNCTION `f`(a BIGINT UNSIGNED, b DOUBLE) RETURNS ENUM('123456789012', '123', '123456789012345678901')

this function is disappears (ERROR 1115 (42000) at line 22: Unknown character set: 'latin' when i try to SHOW CREATE FUNCTION)...

How to repeat:
Use following sql code:

============ test.sql ============

DELIMITER $$

DROP FUNCTION IF EXISTS `f` $$
CREATE FUNCTION `f`(a BIGINT UNSIGNED, b DOUBLE) RETURNS ENUM('123456789012', '12', '123456789012345678901')
DETERMINISTIC
BEGIN

RETURN '123456789012';
END $$

SHOW CREATE FUNCTION f$$

DROP FUNCTION IF EXISTS `f` $$
CREATE FUNCTION `f`(a BIGINT UNSIGNED, b DOUBLE) RETURNS ENUM('123456789012', '123', '123456789012345678901')
DETERMINISTIC
BEGIN

RETURN '123456789012';
END $$

SHOW CREATE FUNCTION f$$

DELIMITER ;

============ test.sql end ============

ns@lhc:~$ mysqladmin -u root -p create tmp2
Enter password:
ns@lhc:~$ mysql -u root -p tmp2 < test.sql
Enter password:
Function sql_mode Create Function
f CREATE DEFINER=`root`@`localhost` FUNCTION `f`(a BIGINT UNSIGNED, b DOUBLE) RETURNS enum('123456789012','12','123456789012345678901') CHARSET latin1\n DETERMINISTIC\nBEGIN\n\nRETURN 'ok';\nEND
ERROR 1115 (42000) at line 22: Unknown character set: 'latin'

[24 Sep 2009 11:51] Valeriy Kravchuk

Thank you for the problem report. Please, try to repeat with a recent version of MySQL server, 5.0.86, and inform about the results. I can not repeat with 5.0.85, for example.

[28 Sep 2009 9:22] Mike Drapolyuk

With version 5.0.84-r1 everything is good.

[28 Sep 2009 10:45] Valeriy Kravchuk

Not repeatable with recent versions.