>Description:
REGEXP and LIKE operators in SELECT statements will NOT
do case-insensitive queries in VARCHAR() and BLOB text
columns.
E.g.
SELECT * FROM article_database WHERE article_preview LIKE '%a%';
'%a%' LIKE 'What is a CPU?' -> 0
or
SELECT * FROM article_database WHERE article_preview REGEXP 'the';
'the' REGEXP 'The main purpose of today's...' -> 0
>How-To-Repeat:
Up there
>Fix:
N/A
>Submitter-Id: none
>Originator: Nadeem Douba
>Organization: none
>MySQL support: none
>Synopsis: Problem with case-insensitive queries
>Severity: critical
>Priority: high
>Category: mysql
>Class: sw-bug
>Release: mysql-3.23.49 (Source distribution)
>Environment:
System: OpenBSD bs-dee.org 3.0 GENERIC#94 i386
Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc
GCC: Reading specs from /usr/lib/gcc-lib/i386-unknown-openbsd3.0/2.95.3/specs
gcc version 2.95.3 20010125 (prerelease)
Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS=''
LIBC:
-r--r--r-- 1 root bin 729068 Oct 18 15:25 /usr/lib/libc.a
-r--r--r-- 1 root bin 594173 Oct 18 15:25 /usr/lib/libc.so.28.0
Configure command: ./configure --prefix=/home/daemons/mysql
--exec-prefix=/home/daemons/mysql --libdir=/usr/lib --mandir=/usr/man
--includedir=/usr/man --with-berkeley-db
---------------------------------------------------------------------
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
