Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

Bug when exporting view if last line is comment.

rob's profile image rob posted 4 years ago in Import/Export Permalink

Hello

When exporting a view that has a comment as its last line, the semicolon to finish the view is put behind the comment rendering it useless.

I attached a minimal example export using 9.3.0.5055 (64 Bit). The semicolon behind the comment "here's a comment" in line 43 should be on a new line.

Cheers

1 attachment(s):
rob's profile image rob posted 4 years ago Permalink

It also happens when the last statement is followed by a comment like:

order by 1 -- id

ansgar's profile image ansgar posted 4 years ago Permalink

Confirmed. I will need to add a linebreak after the view code.

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