How can I have MySQL Workbench autocomplete with uppercase?

In MySQL WOrkbench, go to EDIT > PREFERENCES > SQL EDITOR > QUERY EDITOR and in productivity section click on the checkbox with "Use UPPERCASE keywords on completion".


I submitted bug report:

Description: The autocompletion uses lowercase instead of uppercase, which is inconsistent with the SQL generated e.g. when altering a table, as well as with the ANSI standard http://www.contrib.andrew.cmu.edu/~shadow/sql/sql1992.txt Demo: http://youtu.be/oRcjJcaej-M

How to repeat: In the SQL Editor, type "AL" then hit Ctrl+Space to trigger the auto completion. Demo: http://youtu.be/oRcjJcaej-M

Suggested fix: Use uppercase.

The issue is now solved:

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

A new preference was added to toggle casing for the generated keywords in the auto completion list. "Edit", "Preferences", "SQL Editor TAB", "Use uppercase keyboards on completion".

enter image description here


Replace the contents of your %PROGRAM_FILES%\MySQL\MySQL Workbench 5.2 CE\data\code_editor.xml with the contents from http://pastebin.com/FHVPLAP4