MySQL Bugs: #27: SELECT on blob with LIKE kills nmysqld

Bug #27	SELECT on blob with LIKE kills nmysqld
Submitted:	9 Jan 2003 23:37	Modified:	10 Jan 2003 0:47
Reporter:	Michael Widenius	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server	Severity:	S3 (Non-critical)
Version:	4.0.8	OS:	Linux (Linux)
Assigned to:	Michael Widenius	CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
First bug causes mysql either to crash or return nothing when doing
select something from table where blob like '%something%';

How to repeat:
Load testcase from secret directory: ensita-egor-bug1.tar
Install test tables and run:

select something from table where blob like '%something%';

several times in a mysql client.

Thank you for your bug report. This issue has already been fixed
in the latest released version of that product, which you can download at 
http://www.mysql.com/downloads/

Bug in turbo-BM like optimization with characters > 128.

Fixed in 4.0.10