Bug #56224 Function name is case-sensitive

Submitted: 24 Aug 2010 16:46 Modified: 7 Jun 2012 16:27
Reporter: Todd Farmer (OCA) Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Stored Routines Severity:S2 (Serious)
Version:5.1.50 OS:Any
Assigned to: CPU Architecture:Any

[24 Aug 2010 16:46] Todd Farmer
Description:
Stored function names are case sensitive, at least in some use cases:

mysql> use test
Database changed
mysql> CREATE DEFINER=`root`@`localhost` FUNCTION `testFunction`( ) RETURNS INT DETERMINISTIC RETURN 1;
Query OK, 0 rows affected (0.00 sec)

mysql> SHOW FUNCTION STATUS LIKE 'testFunction'\G
*************************** 1. row ***************************
                  Db: test
                Name: testFunction
                Type: FUNCTION
             Definer: root@localhost
            Modified: 2010-08-24 09:38:08
             Created: 2010-08-24 09:38:08
       Security_type: DEFINER
             Comment:
character_set_client: utf8
collation_connection: utf8_general_ci
  Database Collation: latin1_swedish_ci
1 row in set (0.03 sec)

mysql> SHOW FUNCTION STATUS LIKE 'testfunction'\G
Empty set (0.03 sec)

mysql> show global variables like '%case%';
+------------------------+-------+
| Variable_name          | Value |
+------------------------+-------+
| lower_case_file_system | ON    |
| lower_case_table_names | 1     |
+------------------------+-------+
2 rows in set (0.00 sec)

The documentation says this should not be the case:

"Column, index, stored routine, and event names are not case sensitive on any platform, nor are column aliases."

http://dev.mysql.com/doc/refman/5.1/en/identifier-case-sensitivity.html

How to repeat:
See above.

Suggested fix:
Make function names not case sensitive.
[7 Sep 2010 10:46] Peter Laursen
It is simply annoying!  I think this is a regression?
[7 Jun 2012 16:27] Paul DuBois
Noted in 5.1.63, 5.5.23, 5.6.6 changelogs. 

SHOW statements treated stored procedure, stored function, and event 
names as case sensitive.

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

Page generated in 0.058 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.