[Oliver Jones]

'Khushboo' wrote on '16:

Hi Oliver,

We have released SQLyog 8.54 with this fix, which is available publicly!

“Query Formatter was not handling queries of size greater than 2 KB. Now the size is increased to 8 KB.”

This now works fine; thank you. But you might want to increase your limit even more.

[Oliver Jones]

Hello Kushboo. Thanks for the quick turnaround. The situation is much improved.

'Khushboo' wrote on '06:

Please try this special build in your environment and let us know the status.

However, with your version 8.54 n 1 and the nasty query I gave as an example, I still have a problem when sqlyog attempts to format the list of columns.

The first line of the formatted query begins with SELECT, and then contains a long list of column names and other expressions that stretches from Chicago to New York (or, Mumbai to Delhi) 🙂

The subsequent lines, beginning with WHERE, are formatted correctly.

By the way, precisely the same issue shows up when I sql-dump or use your alter-view command on a big view definition;

I look forward to the release where formatting works really well; it will help a lot in my work.

[Author]

Posts