Bug #65277 Incorrect detection of changes in stored procedures

• Submitted: 10 May 2012 15:07
• Modified: 8 Nov 2012 20:16
• Reporter: Bartłomiej Święcki
• Status: Closed
• Category: MySQL Workbench: SQL Editor
• Severity: S2 (Serious)
• Version: 5.2.39
• OS: Linux (Linux 3.2.0-24-generic)
• CPU Architecture: Any
• Tags: WBBugReporter

[10 May 2012 15:07] Bartłomiej Święcki

Description:
When using alter routine option in Workbench, not all changes made to the routine are threated as actually altering it.
It applies to switching between lower and upper case letters and changing white spaces.

How to repeat:
1) Create new stored procedure on empty schema, use following SQL code:

DELIMITER $$
CREATE PROCEDURE `test` ()
BEGIN
    SELECT TRUE AS 'result';
END

2) Apply changes

3) Change the line:
  SELECT TRUE AS 'result';
into:
  SELECT TRUE AS 'RESULT';

4) Apply changes again - the workbench will issue a warning that no changes has been detected and won't let apply the change

[10 May 2012 15:16] MySQL Verification Team

Thank you for the bug report. Verified on Centos 6.2.

[8 Nov 2012 20:16] Philip Olson

Fixed as of the upcoming MySQL Workbench 5.2.45, and here's the changelog entry:

 The "ALTER ROUTINE" functionality would not
 detect stored procedure changes when only the case changed. This
 check was case-insensitive.

Thank you for the bug report.