Bug #92515 Allow \SQL in capital in the shell to change to SQL mode

• Submitted: 20 Sep 2018 22:58
• Modified: 25 Sep 2018 8:59
• Reporter: Frederic Descamps
• Status: Verified
• Category: Shell General / Core Client
• Severity: S4 (Feature request)
• Version: 8.0.12
• OS: Any
• CPU Architecture: Any

[20 Sep 2018 22:58] Frederic Descamps

Description:
Currently to change MODE in the shell we can use \py, \js and \sql

For SQL it would be so convenient to allow to use SQL in capital.

For old DBAs (like me), SQL statements are often written in capital. Also SQL is itself often written in capital. And finally, when in SQL mode, the prompt shows a nice SQL in capital... the brain makes a pic of it and once you need to change back to SQL mode... error as you type \SQL instead of \sql

How to repeat:
just start the shell and change to SQL mode in capital: 
 MySQL  JS  \SQL
SyntaxError: Unexpected token ILLEGAL

 MySQL  JS  \sql
Switching to SQL mode... Commands end with ;

Suggested fix:
It would be great that at least \SQL works... not sure about \PY and \JS

[25 Sep 2018 8:59] MySQL Verification Team

Hello Frederic,

Thank you for the report and feature request!

regards,
Umesh