On Saturday 21 December 2002 15:14, Paul P Komkoff Jr wrote:
> I tracked down the bug
>
> I have one table with BLOB field in it
> Then I execute queries like
>
> SELECT * FROM _search WHERE (LOWER(keywords) LIKE LOWER('% blabla %'))
>
> here, keywords is a blob fields
>
> when (LOWER(keywords) LIKE LOWER('% blabla %')) is true, mysql dies
>
> hope this helps
Sorry, but I couldn't repeat it on 4.0.5. It works perfectly well for me:
mysql> select count(*) from mytable where lower(body) like
lower('%victoria%');
+----------+
| count(*) |
+----------+
| 1452 |
+----------+
1 row in set (9.29 sec)
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Victoria Reznichenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
