SQL being altered upon 'view' being saved.

[expired user #9744]'s profile image [expired user #9744] posted 8 years ago in General Permalink

My SQL codes are being altered every-time I save a 'view' -- It converts my formatted syntax into a one-liner string. This only seems to occur on views.

It also strips out my -- comments and adds considerable edits including a million backticks to my syntax.

How do I disable this effect. It wasn't occurring in my 9.1 version circa 2014, but the 9.3 version I installed after Dec started doing this.

ansgar's profile image ansgar posted 8 years ago Permalink

Well, it's MySQL (or MariaDB) converting the view code. This is a very old issue. You should comment there: https://bugs.mysql.com/bug.php?id=5159

In the meantime, you can use Ctrl+F8 (or click the button with the white sheet and the pencil) to reformat the SQL code in HeidiSQL. This works in any SQL editor.

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