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 Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server: User-defined functions ( UDF ) Severity:S1 (Critical)
Version:5.0.24-community-nt-log OS:Windows (win32 - XP SP2, Linux)
Assigned to: 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

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.040 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.