MySQL Bugs: #7499: 1054 Unknown column 'xxxxx' in 'where clause'

Bug #7499	1054 Unknown column 'xxxxx' in 'where clause'
Submitted:	22 Dec 2004 23:55	Modified:	5 Jan 2005 23:02
Reporter:	Mike Read	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Query Browser	Severity:	S1 (Critical)
Version:	1.1.4	OS:	Linux (SuSE Linux 9.0)
Assigned to:	Alfredo Kojima	CPU Architecture:	Any

Description:
The browser is unusable at this point. 

Any literal in “where” clause causes the message “! 1054 Unknown column 'xxxxx' in 'where clause'”. 

This is true with both single or double quotes.

Select * from ProductHdr where MfrID=”XYZ”

How to repeat:
Issue any select statement with a where clause and a literal value

Thank you for the bug report i was able to repeat on Slackaware box.
The QB Windows version not presents this issue.

I  am have similar problems with a RH ver 9.  Anytime I do select like the following examples I get error 1054  or error 1064:
examples 
1064
select if(hourtype=1,1,0) as class_index, var1,var2,var3 from table1 as a,  table 2 as b where b.var=a.var;

or 
1054
select so.hourtype,so.date, pnodeid, so.price, so.hour
   from byers.lmpt as so 
   where so.PnodeID = (select distinct source from byers.paths)
;
the  querybrowser parser does not recognize the () in the function or the subquery

I am using the version 1.1.4.  I can get each of these queries to work using PHP scripts and I do not seem to have this problem using the XP version.

I put the SuSE 9.1 rpm onto a Mandrake 10.1 installation and it works generally but exhibits this bug. I agree that the product is useless with this bug in it.

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