On Saturday, March 05, 2005 1:46 PM [GMT+1=CET],
Gleb Paharenko <[EMAIL PROTECTED]> wrote:
Hello.
The problem I think is in indexes. After dropping the unique key
the query gives the correct result. I've reported a bug:
http://bugs.mysql.com/bug.php?id=8976
You may add your comments there.
I have
Hello.
The problem I think is in indexes. After dropping the unique key
the query gives the correct result. I've reported a bug:
http://bugs.mysql.com/bug.php?id=8976
You may add your comments there.
"Artem Kuchin" <[EMAIL PROTECTED]> wrote:
> MySQL: 4.1.8a
> OS: FreeBSD 5.3
MySQL: 4.1.8a
OS: FreeBSD 5.3
The problem is that BINARY LIKE '..' returns no rows no
matter what specified in '..' however BINARY field_name LIKE '..'
work, but I cannot use it because this does not use index (EXPLAINs are
bellow). According to documentation BINARY LIKE shoud work. But it
does no