Formatting of View definitions

[expired user #8927]'s profile image [expired user #8927] posted 9 years ago in General Permalink
Hello everyone,
when composing a view, I take care to format the SQL with indentations and many lines so I can understand it later. Now I have two systems:
1.) Win 7 with locally installed mySQL 5.1.63 - when I open a formerly saved view definition, it looks fine.
2.) Win 7 with remotely installes mySQL 5.1.?? on Linux - when I open a formerly saved view definition, it is shown in one line only with "`" around every table and column name.

It looks like on system 2.) the View definition is parsed somehow before saving oder retrieving ...

How can I prevent that? (I am not referring to the Ctrl-F8 feature, I would rather keep my own Layout)

Thank you, regards, Wolfgang
[expired user #9009]'s profile image [expired user #9009] posted 9 years ago Permalink
I have the same problem. Views are nearly unusable with that behaviour.
johnb's profile image johnb posted 3 years ago Permalink

I confirm that this problem still exists in 15/4/2021 in HeidiSQL 11.2.0.6213 for Windows, when you connect to MySQL 8.0.23 in Linux.

The formatting of MySQL functions though is showing correctly (lines feeds are showing correctly and the code inside the MySQL function is preserved between saves).

Is there any solution for this problem?

Please login to leave a reply, or register at first.