Bug #8437 The query browser is confused by table names ending in '...use'.

• Submitted: 11 Feb 2005 5:49
• Modified: 11 Feb 2005 8:12
• Reporter: Chris Healy
• Status: Closed
• Category: MySQL Query Browser
• Severity: S3 (Non-critical)
• Version: 1.08
• OS: Windows (XP SP2)
• CPU Architecture: Any

[11 Feb 2005 5:49] Chris Healy

Description:
An SQL query that has a table name ending  '..use', that is followed by a character string and not a comma or enclosed by back ticks, results in a Query Browser Error
 
"The default schema cannot be changed to #####"
"mySQL Error 1044 Access denied fro user ______ to database #####"

The Query Browser appears to be trying to change the database to use.  

mySQL version 4.1.9

How to repeat:
For a simple database with the two tables, one having a table name ending in '..use', execute the following queries.

SELECT s.standard, c.clause FROM standard s, clause c
Results in an attempt to change the database to  "FROM"
and
SELECT c.clause, s.standard  FROM standard s, clause c
Results in an attempt to change the database to   "c"
But
SELECT clause.clause, s.standard  FROM standard s, clause
OR
SELECT  s.standard, c.`clause` FROM standard s, `clause` c
Are both successful

[11 Feb 2005 6:11] Chris Healy

This is an error. 
I updated to 1.1.5 but by accident ran 1.08 when checking this bug. 
It is fixed in 1.1.5
apologies.