I found a bug about "Run current query"

User, date Message
Written by ffychina
1 year ago
Category: General
2 posts since Tue, 06 Mar 12 		the function of "Run current query" has a wrong that can't actually run the current line query, it will run whole sql in editor. just like that:
// two sql seperate by \r\n
select * from table_a
select * from table_b

when I put cursor at the line "select * from table_b" and right click "run current query", but the sql is not I expect, it's wrong: "select * from table_a select * from table_b", therefore, the error: "/* SQL Error (1064): You have an error in your SQL syntax" will be appear in log window.

however, I think this is a low level bug and it's easy to fix, I am hoping fix it sooner.

By the way, heidisql version is 7.0.0.4053 and 7.0.0.4078 exist this bug.
Written by kalvaro
1 year ago
440 posts since Thu, 29 Nov 07 		It's "Run current query", not line. A line is delimited by carriage returns, a query is delimited by semi-colon.

select * from table_a;
select * from table_b;
Written by ffychina
1 year ago
2 posts since Tue, 06 Mar 12 		thanks, it's different behavior with version 5. I will adapt this way. But if have a choice tetween semi-colon and carriage returns will be better, any way it's no important and is not a bug.
Written by ansgar
1 year ago
3949 posts since Fri, 07 Apr 06 		HeidiSQL 5 did not have the "Run current query" action. Instead there was a "Run current line", which you likely used.

Now, there was quite some discussion on this "Run current line" action, so I finally turned it into a "Run current query", which now includes carriage returns, and is much more what most users need, while MySQL itself always supports multiple lines in a query.
 

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