Bug #37013 | CONDITION NOT MET IN VALID SQL STATEMENT | ||
---|---|---|---|
Submitted: | 27 May 2008 18:06 | Modified: | 8 Feb 2018 23:00 |
Reporter: | Marian Stránecký | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Server: DML | Severity: | S3 (Non-critical) |
Version: | 5.0.22,5.0.54, 5.0, 5.1, 6.0 BK | OS: | Linux (CentOS5, Gentoo2008) |
Assigned to: | CPU Architecture: | Any | |
Tags: | doc_type_id, select statement |
[27 May 2008 18:06]
Marian Stránecký
[27 May 2008 20:23]
Sveta Smirnova
Thank you for the report. Verified as described using following test: CREATE TABLE `ota_messages` ( `oma_pro` bit(1) NOT NULL, `doc_type_id` int(10) unsigned NOT NULL, `UD` varchar(200) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; insert into ota_messages(oma_pro, doc_type_id) values (0, 0), (0, 1); SELECT doc_type_id FROM ota_messages WHERE oma_pro=0 and doc_type_id=0;
[8 Feb 2018 23:00]
Roy Lyseng
Posted by developer: Fixed in 5.6.40 and up.