>Description:
When a field contains multiple lines (delimited by \n)
SELECT ... WHERE xxx like "%xxx%" is no longer case
insensitive.
>How-To-Repeat:
create table test (
text blob
);
insert into test values ("Hello\nWorld\nTest");
# This returns nothing
select * from test where text like "%world%";
# This returns something
select * from test where text like "%World%";
>Fix:
>Submitter-Id: <submitter ID>
>Originator: Matthias Cramer
>Organization:
>MySQL support: none
>Synopsis: LIKE is not case insensitive when a \n is in the string
>Severity: serious
>Priority: medium
>Category: mysql
>Class: sw-bug
>Release: mysql-3.23.41 (Source distribution)
>Server: /usr/local/bin/mysqladmin Ver 8.21 Distrib 3.23.41, for pc-linux-gnu on i686
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license
Server version 3.23.41
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /tmp/mysql.sock
Uptime: 4 min 24 sec
Threads: 6 Questions: 24 Slow queries: 0 Opens: 7 Flush tables: 1 Open tables: 1
Queries per second avg: 0.091
>Environment:
System: Linux mintaka.astroinfo.ch 2.2.5-15 #1 Mon Apr 19 23:00:46 EDT 1999 i686
unknown
Architecture: i686
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-redhat-linux/egcs-2.91.66/specs
gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release)
Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS=''
LIBC:
lrwxrwxrwx 1 root root 13 Jan 23 2001 /lib/libc.so.6 -> libc-2.1.3.so
-rwxr-xr-x 1 root root 4101324 Feb 29 2000 /lib/libc-2.1.3.so
-rw-r--r-- 1 root root 20272704 Feb 29 2000 /usr/lib/libc.a
-rw-r--r-- 1 root root 178 Feb 29 2000 /usr/lib/libc.so
Configure command: ./configure
Perl: This is perl, version 5.005_03 built for i386-linux
---------------------------------------------------------------------
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
