Bug #105529 Beautify button does not UPPERCASE some keywords (insert into, commit, etc)
Submitted: 11 Nov 2021 12:21 Modified: 11 Nov 2021 12:29
Reporter: G G Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Workbench: SQL Editor Severity:S3 (Non-critical)
Version:8.0.27 OS:MacOS (macOS 11.2.x Big Sur x86_64)
Assigned to: CPU Architecture:Any
Tags: WBBugReporter

[11 Nov 2021 12:21] G G
Description:
----[For better reports, please attach the log file after submitting. You can find it in /Users/gal/Library/Application Support/MySQL/Workbench/log/wb.log]

When clicking on Beautify botton, the below keywords were not uppercased and the line indentation didn't work:
- insert into
- commit
- use
- rollback

How to repeat:
try to click on Beautify button on any of the below queries. 

use employees;

commit;

rollback;

insert into departments_dup (dept_no, dept_name) select * from departments;

Suggested fix:
Make the Beautify take into account all the keywords for uppercasing and indentation.
[11 Nov 2021 12:29] MySQL Verification Team
Hello!

Thank you for the report and feedback.

regards,
Umesh