>Description:
Ok, I know I submitted an earlier bug report about this, but I've actually
had it happen from the mysql monitor. Essentially, UPDATE queries are
executing, but not actually updating, unless I SELECT data from the table
first.
>How-To-Repeat:
Simple as that. I have yet to notice any particular pattern. It happens
for some queries, on some tables, some of the time.
>Fix:
Select data from the table first.
>Submitter-Id: <submitter ID>
>Originator: nick edward purvis
>Organization:
CarSpot.com
>MySQL support: none
>Synopsis: UPDATE queries executing, but failing to actually update
>Severity: non-critical
>Priority: low
>Category: mysql
>Class: sw-bug
>Release: mysql-3.23.34a (Source distribution)
>Environment:
System: FreeBSD xtabi.carspot.com 4.2-RELEASE FreeBSD 4.2-RELEASE #4: Sat Jun 2
22:42:12 CDT 2001 [EMAIL PROTECTED]:/usr/src/sys/compile/XTABI i386
Some paths: /usr/bin/perl /usr/bin/make /usr/local/bin/gmake /usr/bin/gcc /usr/bin/cc
GCC: Using builtin specs.
gcc version 2.95.2 19991024 (release)
Compilation info: CC='cc' CFLAGS='-O -pipe' CXX='c++' CXXFLAGS='-O -pipe
-felide-constructors -fno-rtti -fno-exceptions' LDFLAGS=''
LIBC:
-r--r--r-- 1 root wheel 1169076 Nov 20 2000 /usr/lib/libc.a
lrwxrwxrwx 1 root wheel 9 Mar 13 12:02 /usr/lib/libc.so -> libc.so.4
-r--r--r-- 1 root wheel 559196 Nov 20 2000 /usr/lib/libc.so.4
Configure command: ./configure --localstatedir=/var/db/mysql --without-perl
--without-debug --without-readline --without-bench --with-mit-threads=no
--with-libwrap --with-low-memory --enable-assembler --with-berkeley-db
--prefix=/usr/local i386--freebsd4.2
Perl: This is perl, version 5.005_03 built for i386-freebsd
---------------------------------------------------------------------
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