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:
Category:MySQLCC Severity:S3 (Non-critical)
Version:0.9.4-beta OS:Windows (Windows, FreeBSD)
Assigned to: Bugs System CPU Architecture:Any

[3 Feb 2004 14:26] Timothy Smith
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

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

[1 Jun 2004 0:38] Jorge del Conde

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.