Bug #34125 Can't create function

• Submitted: 29 Jan 2008 7:14
• Modified: 29 Jan 2008 8:06
• Reporter: Georg Richter
• Status: Can't repeat
• Category: MySQL Server: Maria storage engine
• Severity: S3 (Non-critical)
• OS: Any
• Assigned to: Oleksandr Byelkin
• CPU Architecture: Any

[29 Jan 2008 7:14] Georg Richter

Description:
When running the php test suite against Maria the function related tests will fail cause it's not possible to create a function.

How to repeat:
mysql> select version();
+------------------------------+
| version()                    |
+------------------------------+
| 5.1.23-maria-alpha-pb292-log |
+------------------------------+
1 row in set (0.00 sec)

mysql> CREATE FUNCTION f( ver_param VARCHAR(25)) RETURNS VARCHAR(25) DETERMINISTIC RETURN ver_param;
ERROR 1307 (HY000): Failed to CREATE FUNCTION f

[29 Jan 2008 8:06] Georg Richter

The problem only occurs when using datadir from 5.1 and running mysql_upgrade - when running mysql_install_db from maria tree everything works as expected.