MySQL Bugs: #22786: query: multi command query gives an error

Bug #22786	query: multi command query gives an error
Submitted:	28 Sep 2006 16:09	Modified:	12 Feb 2009 16:50
Reporter:	Maciej Pilichowski	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Query Browser	Severity:	S4 (Feature request)
Version:	5.0.24a	OS:	Linux (opensuse 10.0)
Assigned to:		CPU Architecture:	Any

Description:
It's puzzling me since I can't work with this limitation. 
select * from T;
select * from T;

does not work, this too

use test;
select * from T;

I can just guess that this is related to displaying the results of the query. But please, if there are two queries display the last result. AFAIR MSSQL query browser can handle it without problem.

How to repeat:
See above.

Suggested fix:
Remove the limitation, display the result of the last query.
And at least, remove the error message -- it is misleading since it has nothing to do with syntax.

Thank you for the bug report.

I've observed this same problem on both the latest Query Browser v1.2.5beta (GUI Tools v5.0r5) & with the Query Browser version from GUI Tools v5.0r2, both for SuSE 10.x (x86).

Clarification of Problem:
  If one attempts to execute a query and at least one other query is still in the query text area, error #1064 results ("You have an error in your SQL syntax..."). This error does not occur when only 1 query is entered in this text area, and is independent of the type of query entered.
  I have NOT observed this problem on Windows XP, with the Query Browser from the GUI Tools v5.0r2 Windows (x86) release.

Example Entry:
  SHOW TABLES;
  SELECT * FROM foo;

Client System Details:
  CPU: AMD Sempron 2500+
  OS: SuSE 10.0 (x86)
  kernel: 2.6.13-15.11-default
  glibc: 2.3.5-40
  MySQL Query Browser v1.2.5beta (GUI Tools v5.0r5)

MySQL Server System Details:
  CPU: Intel Pentium 4 521 (EM64T & HT)
  OS: SuSE 10.0 (x86_64)
  kernel: 2.6.13-15-smp
  glibc: 2.3.5-40
  MySQL Community Server: 5.0.24 (x86_64)
    (mysql-standard-5.0.24-linux-x86_64-icc-glibc23.tar.gz)

Thank you for your bug report. This issue has already been fixed in the latest released version of that product, which you can download at

  http://www.mysql.com/downloads/