MySQL Bugs: #23038: Wrong display on select

Bug #23038	Wrong display on select
Submitted:	6 Oct 2006 3:24	Modified:	6 Nov 2006 6:29
Reporter:	Robert Gebis	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Query Browser	Severity:	S3 (Non-critical)
Version:	1.2.4Beta	OS:	MacOS (Mac OSX 10.4.8)
Assigned to:	Assigned Account	CPU Architecture:	Any

Description:
When I exec simple sub query of type

select * from mcConfTbl where id = (SELECT id from svrConfTbl where svrName = 'default');

I get this is Query Browser.

*id, interface, port, mcgroup, msgFilter

If I replace the * (All) in original query with 

select  interface, port, mcgroup, msgFilter from mcConfTbl where id = (SELECT id from cmedConfTbl where svrName = 'default');

I get this

 interface, port, mcgroup, msgFilter, *id

My question is why do I see the *id on the last query?

when I do the last query on command line I do not see the *id being printed

How to repeat:
Run the query

Thank you for the report.

Please, explain where "id" is printed? As header of columns? If so, please, provide output of SHOW CREATE TABLE mcConfTbl; and SHOW CREATE TABLE svrConfTbl; statements.

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".