Bug #7568 Error when viewing contents of table without default schema
Submitted: 29 Dec 2004 9:34 Modified: 15 Apr 2005 1:48
Reporter: [ name withheld ] Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Query Browser Severity:S3 (Non-critical)
Version:1.1.4 OS:Microsoft Windows (Windows XP Pro)
Assigned to: Alfredo Kojima CPU Architecture:Any

[29 Dec 2004 9:34] [ name withheld ]
Description:
When opening a connection to a multiple DB system without a default schema selected will cause MySQL Query Browser to not automatically insert a DATABASENAME. in front of the table name of the MySQL query. For example, if server has a table named "tbl" in a database named "db", expected statement should be "SELECT * FROM db.tbl n", instead get "SELECT * FROM tbl n"

How to repeat:
Open up a connection to a server containing multiple databases without specifying a default schema. Expand a database by using the arrows (not double clicking, which sets a default schema). Then double click a table under the database you just expanded and hit Execute.

Suggested fix:
Have MySQL Query Browser insert the DATABASENAME. in front of table name when no default schema is set.
[15 Apr 2005 1:48] Alfredo Kojima
Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.

If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html