MySQL Bugs: #12239: Unknown column in 'field list' (1054)

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:	None
Category:	MySQL Query Browser	Severity:	S3 (Non-critical)
Version:	1.1.13	OS:	Windows (XP Pro (SP2))
Assigned to:	Vladimir Kolesnikov	CPU Architecture:	Any

Description:
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?!

Hi!

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 ?

Thanks!

Here is the information as per Jorge's request:

[SUCCESSFUL]
SELECT component_id FROM component

SELECT component_id 
FROM component

NOTE: there IS a space after component_id

[UNSUCCESSFUL]
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?

I have also experienced this anomaly in version 1.1.13, along with another aberration in the select statement.

The table that I used:

CREATE TABLE bugTest (
    ID INTEGER NOT NULL AUTO_INCREMENT,
    Column1 VARCHAR(40) NOT NULL,
    Column2 VARCHAR(40) NOT NULL,
    Column_3 VARCHAR(40),
    PRIMARY KEY (ID)
)
Engine=InnoDB;

with

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: 
SELECT ID
FROM bugtest
results in unknown column "I" in fieldlist

Thoughts:
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!!

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
    http://www.mysql.com/doc/en/Installing_source_tree.html