Bug #12107 Where clause with more than one condition
Submitted: 22 Jul 2005 9:01 Modified: 22 Jul 2005 20:07
Reporter: Anshuman Singh Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:4.1.8-standard-log OS:Linux (Linux)
Assigned to: CPU Architecture:Any

[22 Jul 2005 9:01] Anshuman Singh 
Description:
If i use the where clause with more than one condition without braces using 'and' then it gives the error :
ERROR 2000: Unknown MySQL error

How to repeat:
I am having table:

CREATE TABLE `currencies` (
  `cur1` varchar(5) NOT NULL default '',
  `cur2` varchar(5) NOT NULL default '',
  `rate` decimal(20,5) NOT NULL default '0.00000',
  `last_update` date default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1

the select statement showing error:

 select rate from currencies where cur1='EUR' and cur2='GBP';
[22 Jul 2005 9:06] Aleksey Kishkin 
was not able to reproduce it on slackware linux. What client do you use (I use console mysql client)?
[22 Jul 2005 20:07] Jorge del Conde 
I was unable to reproduce this bug with the latest tree of 4.1 and 5.0