>Description:
when doing a select replace(fieldname, 'lookforstring', 'replacestring'), the
replace never occurs. It works fine if searching on a static string. The behaviour is
correct on my Red Hat machine.
>How-To-Repeat:
- easy to repeat (bug was in 3.22.23 as well) - just try a replace in any
table (myisam or just isam) - seems to be os-specific
>Fix:
>Submitter-Id: <submitter ID>
>Originator: Julian Wood "[EMAIL PROTECTED]"
>Organization: University of Calgary
>MySQL support: none
>Synopsis: select replace not working with fields on OS X Server
>Severity: non-critical
>Priority: medium
>Category: mysql
>Class: sw-bug
>Release: mysql-3.23.36 (Official MySQL binary)
>Environment:
System: Rhapsody movies 5.5 Kernel Release 5.5: Fri Jul 2 13:10:26 PDT 1999;
root(rcbuilder):Objects/kernel-154.14.obj~10/RELEASE_PPC Copyright (c)
1988-1995,1997-1999 Apple Computer, Inc. All Rights Reserved. Power Macintosh
Some paths: /usr/bin/perl /bin/make /usr/bin/cc
Compilation info: CC='gcc' CFLAGS='-O2 -fno-omit-frame-pointer' CXX='gcc'
CXXFLAGS='-O2 -fno-omit-frame-pointer' LDFLAGS=''
LIBC:
Configure command: ./configure --prefix=/usr/local/mysql '--with-comment=Official
MySQL binary' --with-extra-charsets=complex --disable-shared
Perl: This is perl, version 5.005_02 built for rhapsody
---------------------------------------------------------------------
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
