Bug #49368 SQL Snippets aren't numbers under the "#" column
Submitted: 2 Dec 2009 20:58 Modified: 2 Apr 2010 9:31
Reporter: Todd Farmer (OCA) Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench: SQL Editor Severity:S3 (Non-critical)
Version:5.2.10 r4680 OS:Windows (XP)
Assigned to: Mike Lischke CPU Architecture:Any

[2 Dec 2009 20:58] Todd Farmer
Description:
The SQL Snippets palette has two columns, one labeled "#", the other labeled "SQL".  Contrary to the header, the "#" does not contain numbers, but letters, starting with A, and apparently ending in "Y" (?!?).  Everything beyond that has nothing in the "#" column.

The "SQL" column has both the SQL statement *and* the user-supplied snippet name (if provided).  It would be handy if the name was in a separate column.

How to repeat:
Add 27 SQL Snippets.

Suggested fix:
Change "#" column to numbers.
Add column for SQL Snippet Name.
[3 Dec 2009 22:26] Alfredo Kojima
Removed the # from the column header to eliminate "confusion"
[24 Feb 2010 18:02] Alfredo Kojima
Removed the # from linux too.
[2 Apr 2010 9:31] Michael G. Zinner
The labeling with A-Z will later on be used for keyboard shortcuts. Only A-Z are used, other snippets do not have a shortcut and therefore there is no need for a label.