MySQL Bugs: #41757: Cannot run cmds via text as first N actions. (use database show processlist etc

Bug #41757	Cannot run cmds via text as first N actions. (use database show processlist etc
Submitted:	26 Dec 2008 17:57	Modified:	17 Feb 2009 11:55
Reporter:	Daniel Katz	Email Updates:
Status:	Unsupported	Impact on me:	None
Category:	MySQL Query Browser	Severity:	S2 (Serious)
Version:	1.2.12 (5.0-r12?)	OS:	MacOS (10.5.6)
Assigned to:		CPU Architecture:	Any

Description:
When starting up the browser, all text input commands throw an error, including "use _database_".

Browser connects fine however won't accept any commands without selecting a schema via mouse / gui interface.

Screenshot at http://insidecase.com/mysql_mac_au.png

How to repeat:
Connects fine and try to issue any command such as 'show processlist' or 'use _database_'

Common scenarios:

Input:
use au;

Output:
selected schema ''. (where no schema is actually selected)

Then any subsequent command results in a "error in sql syntax".

Note: All commands seem to work fine after selecting a database by selecting default schema from the interface.

Thank you for the report.

Verified as described: any 2 queries (like SELECT 1; SELECT * FROM t1) one of which requires default database fail when no default database is used.

> Updated by:           Geert Vanderkelen
> The behaviour is repeatable (using 1.2.12 on Mac), but I don't think
> this is really serious. Just use USE before, or select the appropriated
> database in the GUI, and do the select statement then.
> 
> It's still wrong there is an error, but moving it to S3.

Geert, I was able to reproduce the errors even when trying to do a 
'use databasename'.

_all_ text based input commands for me would not work when starting from the gui browser until I selected a database from the graphical section.

Also same problem but different symptom, server commands (not db specific) such as 'show processlist' or 'grant' or 'flush' statements shouldn't require a database to apply to.

Many thanks for writing a bug report. Unfortunately you are using an unsupported
platform.

For more informations about supported platforms please look here:
http://www.mysql.com/support/supportedplatforms/tools.html

We are on the way to implement full functionality of MySQL Query Browser into MySQL
Workbench. More informations about MySQL Workbench you will find here:
http://dev.mysql.com/workbench/