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

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

Thank you for the bug report. Verified as described.

fixed in both branches: 5.1 and 5.2

fix confirmed. will be included in 5.2.9

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.

Page generated in 0.041 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.