~maria-captains/maria/5.1

Viewing all changes in revision 2502.1137.166.

  • Committer: Praveenkumar Hulakund
  • Date: 2012-03-28 06:35:31 UTC
  • mto: (2502.1194.1 mysql-5.1.64-release)
  • mto: This revision was merged to the branch mainline in revision 3149.
  • Revision ID: praveenkumar.hulakund@oracle.com-20120328063531-fu47p20ongt8j3mz
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.

expand all expand all

Show diffs side-by-side

added added

removed removed

Lines of Context: