diff options
| author | Praveenkumar Hulakund <praveenkumar.hulakund@oracle.com> | 2012-03-28 12:05:31 +0530 |
|---|---|---|
| committer | Praveenkumar Hulakund <praveenkumar.hulakund@oracle.com> | 2012-03-28 12:05:31 +0530 |
| commit | f3d5127f4d1c9cccf9f1ab74ef2fa290b33f234d (patch) | |
| tree | 620ef3d2b4e401a2edb2d9573a916f8ed05dfb47 /mysql-test/t/sp-bugs.test | |
| parent | 83a5a20d81a43425dae8a63ab581eea7864c25c8 (diff) | |
| download | mariadb-git-f3d5127f4d1c9cccf9f1ab74ef2fa290b33f234d.tar.gz | |
Bug#11763507 - 56224: FUNCTION NAME IS CASE-SENSITIVE
Analysis:
-------------------------------
According to the Manual
(http://dev.mysql.com/doc/refman/5.1/en/identifier-case-sensitivity.html):
"Column, index, stored routine, and event names are not case sensitive on any
platform, nor are column aliases."
In other words, 'lower_case_table_names' does not affect the behaviour of
those identifiers.
On the other hand, trigger names are case sensitive on some platforms,
and case insensitive on others. 'lower_case_table_names' does not affect
the behaviour of trigger names either.
The bug was that SHOW statements did case sensitive comparison
for stored procedure / stored function / event names.
Fix:
Modified the code so that comparison in case insensitive for routines
and events for "SHOW" operation.
As part of this commit, only fixing the test failures due to the actual code fix.
Diffstat (limited to 'mysql-test/t/sp-bugs.test')
| -rw-r--r-- | mysql-test/t/sp-bugs.test | 21 |
1 files changed, 0 insertions, 21 deletions
diff --git a/mysql-test/t/sp-bugs.test b/mysql-test/t/sp-bugs.test index 88b12b0ec61..3ab1689e8b2 100644 --- a/mysql-test/t/sp-bugs.test +++ b/mysql-test/t/sp-bugs.test @@ -183,9 +183,6 @@ BEGIN END $ -CREATE EVENT teste_bug11763507 ON SCHEDULE AT CURRENT_TIMESTAMP + INTERVAL 1 HOUR -DO SELECT 1 $ - DELIMITER ;$ # STORED FUNCTIONS @@ -204,9 +201,6 @@ SHOW FUNCTION STATUS WHERE NAME='TESTF_bug11763507'; SHOW CREATE FUNCTION testf_bug11763507; SHOW CREATE FUNCTION TESTF_bug11763507; -SHOW FUNCTION CODE testf_bug11763507; -SHOW FUNCTION CODE TESTF_bug11763507; - # STORED PROCEDURE CALL testp_bug11763507(); CALL TESTP_bug11763507(); @@ -223,20 +217,6 @@ SHOW PROCEDURE STATUS WHERE NAME='TESTP_bug11763507'; SHOW CREATE PROCEDURE testp_bug11763507; SHOW CREATE PROCEDURE TESTP_bug11763507; -SHOW PROCEDURE CODE testp_bug11763507; -SHOW PROCEDURE CODE TESTP_bug11763507; - -# EVENTS ---replace_column 6 # 7 # 8 # 9 # -SHOW EVENTS LIKE 'teste_bug11763507'; ---replace_column 6 # 7 # 8 # 9 # -SHOW EVENTS LIKE 'TESTE_bug11763507'; - ---replace_column 4 # -SHOW CREATE EVENT teste_bug11763507; ---replace_column 4 # -SHOW CREATE EVENT TESTE_bug11763507; - # INFORMATION SCHEMA SELECT specific_name FROM INFORMATION_SCHEMA.ROUTINES WHERE specific_name LIKE 'testf_bug11763507'; SELECT specific_name FROM INFORMATION_SCHEMA.ROUTINES WHERE specific_name LIKE 'TESTF_bug11763507'; @@ -244,7 +224,6 @@ SELECT specific_name FROM INFORMATION_SCHEMA.ROUTINES WHERE specific_name LIKE ' SELECT specific_name FROM INFORMATION_SCHEMA.ROUTINES WHERE specific_name='testf_bug11763507'; SELECT specific_name FROM INFORMATION_SCHEMA.ROUTINES WHERE specific_name='TESTF_bug11763507'; -DROP EVENT teste_bug11763507; DROP PROCEDURE testp_bug11763507; DROP FUNCTION testf_bug11763507; |