Bug #30052 mistaken "Unknown table 'TBL_USER' in field list"

• Submitted: 25 Jul 2007 18:41
• Modified: 25 Aug 2007 19:38
• Reporter: Ralf Hauser
• Status: No Feedback
• Category: MySQL Query Browser
• Severity: S1 (Critical)
• Version: 1.2.12
• OS: Any
• CPU Architecture: Any

[25 Jul 2007 18:41] Ralf Hauser

Description:
in the command-line client the following query works nicely, in the gui browser, I get the above error message.

SELECT  u.user_id,
 TBL_USER.delete_id AS usr_delete_id FROM TBL_USER u INNER JOIN TBL_USER_PROFILE p ON u.user_id = p.user_id

if I do 

SELECT user_id,
 TBL_USER.delete_id AS usr_delete_id FROM TBL_USER u INNER JOIN TBL_USER_PROFILE p ON u.user_id = p.user_id

correctly, I get  "Column 'user_id' in field list is ambiguous"

if I do 
SELECT  u.user_id,
 u.delete_id AS usr_delete_id FROM TBL_USER u INNER JOIN TBL_USER_PROFILE p ON u.user_id = p.user_id

How to repeat:
.

Suggested fix:
allow to mix "u" and TBL_USER also in the query browser

[25 Jul 2007 19:38] MySQL Verification Team

Thank you for the bug report. Could you please provide the create table
statements for the tables involved. Thanks in advance.

[25 Aug 2007 23:00] Bugs System

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".