Bug #47730 Accented UTF8 chars fools routine parser
Submitted: 29 Sep 2009 22:03 Modified: 25 Nov 2009 17:38
Reporter: Gabriele Tozzi Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench Severity:S3 (Non-critical)
Version:5.1.18/5.2.3 OS:Linux
Assigned to: Sergei Tkachenko CPU Architecture:Any

[29 Sep 2009 22:03] Gabriele Tozzi
Description:
Hello,

inserting accented chars inside a stored procedure makes the parser raise a syntax error and then refuse to save procedure.

How to repeat:
1. Create a new schema
2. Add a new routine

3. Put this code in the routine DDL

CREATE DEFINER = 'mydefiner'@'localhost'
PROCEDURE `testroutine` (
)
SQL SECURITY DEFINER
COMMENT 'woops'
BEGIN

  -- This routine will not work àèìòù

END//

4. A red dot appears near the "CREATE DEFINER..." line as it would be a syntax error
[29 Sep 2009 22:32] MySQL Verification Team
Thank you for the bug report. Verified as described.
[18 Nov 2009 17:33] Sergei Tkachenko
fixed in both branches: 5.1 and 5.2
[24 Nov 2009 9:57] Johannes Taxacher
fix confirmed. will be included in 5.2.9
[25 Nov 2009 17:38] Tony Bedford
An entry has been added to the 5.2.9 changelog:

Using UTF-8 accented characters in the Stored Routine DDL editor caused the DDL parser to raise a syntax error and refuse to save the routine.