Bug #93148 Can't change the function name from lowercase to uppercase
Submitted: 10 Nov 2018 6:32 Modified: 11 Nov 2018 9:49
Reporter: Dawid Nawrot Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Workbench Severity:S2 (Serious)
Version:8.0.13 OS:Windows (10 Home)
Assigned to: CPU Architecture:x86

[10 Nov 2018 6:32] Dawid Nawrot 
Description:
I created a function called 

target_progress

but then I added few more with uppercase name as I wanted them to stand out more in the queries. 

I wanted to change the previous function to TARGET_PROGRESS but when I click APPLY I get an error:

Selected name conflicts with existing function 'TARGET_PROGRESS'

is it because function names are not case sensitive in MySQL. Even if it's just display we should be able to change it right? Just so that on the list they show up in the same way and to enforce a standard?

How to repeat:
Create function 'test'. Save.

Alter function. Change name to 'TEST'
[10 Nov 2018 9:51] Peter Laursen 
Suggestion/workaround: do 2 ALTERs: lowercase_name >> dummy_name >> UPPERCASE_name.

Since routine names are case-insensitive (on all platforms) a single ALTER lowercase >> UPPERCASE is not recognized by the server as a name change at all and has no effect.

-- Peter
-- not a MySQL/Oracle person
[11 Nov 2018 9:49] MySQL Verification Team 
Thank you for the bug report. Please follow Peter's workaround.