Bug #23998 CASE is not highlighted in Stored Procedure editor
Submitted: 6 Nov 2006 5:05 Modified: 7 Nov 2006 1:51
Reporter: Siu Ching Pong (Asuka Kenji) (Basic Quality Contributor) Email Updates:
Status: Duplicate Impact on me:
Category:MySQL Administrator Severity:S3 (Non-critical)
Version:1.2.5 rc OS:Windows (Windows XP Professional)
Assigned to: Mike Lischke CPU Architecture:Any
Tags: case, CASE Function, stored procedure, Stored Procedure Editor

[6 Nov 2006 5:05] Siu Ching Pong (Asuka Kenji)
The "CASE" function is not highlighted in stored procedure editor.

How to repeat:
1. Click "Catalogs" in the top left list.
2. Click "test" in the bottom left list (schema list).
3. Select the "Stored procedures" tab on right hand side.
4. Click the "Create Stored Proc" button at the bottom.
5. Enter a valid name of the stored procedure.
6. In the text area, enter "CASE" between "BEGIN" and "END".
7. Notice that "CASE" is not highlighted.

Suggested fix:
Add "CASE" to the highlight list / reserved word list.
[6 Nov 2006 12:57] MySQL Verification Team
Thank you for the bug report.
[6 Nov 2006 13:30] Mike Lischke
Please do not submit the same bug more than once. An existing bug report already describes this very problem. Even if you feel that your issue is somewhat different, the resolution is likely
to be the same. Because of this, we hope you add your comments to the original bug instead.

Thank you for your interest in MySQL.

PS: This is a duplicate of bug #18835.
[7 Nov 2006 1:51] Siu Ching Pong (Asuka Kenji)
Sorry, I couldn't find that bug before submitting mine. Perhaps because the "Category" we used are different: "MySQL Administrator" and "MySQL Query Browser".