Bug #12239 Unknown column in 'field list' (1054)
Submitted: 28 Jul 2005 13:26 Modified: 9 Sep 2005 8:41
Reporter: Mr Wakazula Email Updates:
Status: Closed Impact on me:
Category:MySQL Query Browser Severity:S3 (Non-critical)
Version:1.1.13 OS:Windows (XP Pro (SP2))
Assigned to: Vladimir Kolesnikov CPU Architecture:Any

[28 Jul 2005 13:26] Mr Wakazula
When executing a query, it appears that the query browser is truncating characters.

Oddly enough, I have not experienced this problem with 1.1.13 until now.

The only change to my system has been:
- the occasional windows update
- upgrading MySql Administrator to 1.1.0rc

How to repeat:
1) re-boot PC
2) start Query Browser
3) execute:

select component_id
from component

returns the following error:
Unknown column 'component_i' in 'field list'

NOTE: adding a space after component_id resolves the problem?!
[28 Jul 2005 18:44] Jorge del Conde

I was unable to reproduce this bug.  Can you please upload a copy of your tables, and the queries that you executed to see if that makes the bug happen in my computer ?

[29 Jul 2005 13:15] Mr Wakazula
Here is the information as per Jorge's request:

SELECT component_id FROM component

SELECT component_id 
FROM component

NOTE: there IS a space after component_id

The following query fails:
SELECT component_id
FROM component

NOTE: there is no space after component_id

Please refer to file attachment 'Component.sql' (marked as private) for a copy of the table in question.

To facilitate identifying the source of the problem, I have yet to re-install v.1.1.13.  Would a copy of the program files be useful?
[4 Aug 2005 14:31] Steven Choi
I have also experienced this anomaly in version 1.1.13, along with another aberration in the select statement.

The table that I used:

    Column1 VARCHAR(40) NOT NULL,
    Column2 VARCHAR(40) NOT NULL,
    Column_3 VARCHAR(40),


insert into bugtest (Column1, Column2, Column_3)
values ("column1 text1", "column2 text1", "column3 text1"),
       ("column1 text2", "column2 text2", "column3 text2"),
       ("column1 text3", "column2 text3", "column3 text3"),
       ("column1 text4", "column2 text4", "column3 text4");

(no space after columns names in any query; adding space does get rid of the problem)
Weird behaviour #1: 
SELECT Column2
FROM bugtest
results in error in SQL statement near "Column, ID2 FROM bugtest" ?!!? I don't even have these column names!

Repeated behaviour from Mr. Wakazula: 
FROM bugtest
results in unknown column "I" in fieldlist

I originally thought that the bug had to do with underscores in column names but I was able to reproduce the problem with tables that don't contain any underscores in the column names.

By the way, why did you guys discontinue Control Center development? That was SO much more stable than the Query Browser.  Bring back CC!!
[9 Sep 2005 8:41] Vladimir Kolesnikov
Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.

If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information 
about accessing the source trees is available at