Bug #21848 Problems calling functions in Windows when name has upper case chars

• Submitted: 26 Aug 2006 5:27
• Modified: 12 Oct 2006 14:11
• Reporter: Erica Moss
• Status: Duplicate
• Category: MySQL Server: User-defined functions ( UDF )
• Severity: S1 (Critical)
• Version: 5.0.24-community-nt-log
• OS: Windows (win32 - XP SP2, Linux)
• CPU Architecture: Any

[26 Aug 2006 5:27] Erica Moss

Description:
This is an unusual problem.  If the mysqltest script below is run as written it fails with the following error:
mysqltest: At line 16: query 'select myDB.hello()' failed: 1305: FUNCTION myDB.hello does not exist

However if the commented show create line is enabled, then the script will succeed.  Also if the function call is phrased as:
select mydb.hello();
Then it will succeed even if the show create line is left commented.  Also note that the output from the first select statement is as follows:
select name,db from mysql.proc;
  name  db
  hello mydb

How to repeat:
connect (root, localhost, root,,);
CREATE DATABASE  myDB;
use myDB;

DELIMITER //;
Create function hello() Returns varchar(20)
BEGIN
   Return 'Hello';
END//
DELIMITER ;//

select name,db from mysql.proc;
#show create function myDB.hello;
select myDB.hello();

[26 Aug 2006 5:28] Erica Moss

Note: this problem was not occuring in Linux 5.0.24-log

[12 Oct 2006 10:53] Sveta Smirnova

It is also repeatable on Linux if one sets lower_case_table_names to 1.

[12 Oct 2006 14:11] Andrey Hristov

Duplicate of bug#9051