MySQL Bugs: #2632: field selection for Columns window uses wrong SQL

Bug #2632	field selection for Columns window uses wrong SQL
Submitted:	3 Feb 2004 14:26	Modified:	1 Jun 2004 0:38
Reporter:	Timothy Smith	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQLCC	Severity:	S3 (Non-critical)
Version:	0.9.4-beta	OS:	Windows (Windows, FreeBSD)
Assigned to:	Bugs System	CPU Architecture:	Any

Description:
When MySQLCC queries the fields in a table after a "SELECT * FROM table" query, it does not use the correct table name.  When connected to a MySQL 5.0 server, it uses the name `1`.  When connected to a 4.1 server, it uses the name `table`, instead of `database`.`table` which is needed when the user's query was "SELECT * FROM database.table".

How to repeat:
Connect to a database, then:

USE test;
SELECT * FROM mysql.host;

Look at the SQL Debug tab in the Console Manager to see that MySQLCC is issuing these queries:

select * from mysql.host
EXPLAIN select * from mysql.host
SHOW FIELDS FROM `1`

Or, when connected to a MySQL 4.1 server, the third query is:

SHOW FIELDS FROM `host`

Hi!

MySQLCC has been discontinued and will not be developed nor maintained anymore with the exception of Critical bugs.

In the near future we will release the substitute of MySQLCC called MySQL Query Browser.