Maintain Format CASE statment

Discussion of open issues, suggestions and bugs regarding database management and administration tools for MySQL
Post Reply
DevArtForumJF
Posts: 2
Joined: Wed 06 Sep 2017 17:03

Maintain Format CASE statment

Post by DevArtForumJF » Wed 06 Sep 2017 17:11

When I enter a CASE statement, I press enter at the end of each line to help with 'readability'. Example:
CASE TABLE.A
WHEN '1' THEN 'One'
WHEN '2' THEN 'Two'
ELSE 'UNKNOWN'
END AS `New A`

When I move from the text editor to the query builder, enter a filter in the query builder, when I come back to text editor the statement has been reformatted so all the text is on one line:

CASE TABLE.A WHEN '1' THEN 'One' WHEN '2' THEN 'Two' ELSE 'UNKNOWN' END AS `New A`

How can I maintain my multi-line formatting? What am I missing here?

alexa

Re: Maintain Format CASE statment

Post by alexa » Thu 07 Sep 2017 09:55

We will fix this issue in one of the next product builds and will notify you once it's available for downloading.

Post Reply