>Description:
Update of one timestamp field in a table can lead to other timestamp fields
being updated in error.
Run the script below. On my 3.23.48 system the output is
gavin@chip : ./show_bug
mysqladmin Ver 8.23 Distrib 3.23.48, for -freebsd4.5 on i386
FreeBSD chip.gav.itworks.com.au 4.5-STABLE FreeBSD 4.5-STABLE #7: Tue Feb 5 22:44:32
EST 2002 [EMAIL PROTECTED]:/home2/src/FreeBSD/src/sys/compile/CHIP
i386
val1 val2
00000000000000 00000000000000
val1 val2
20020212220642 00000000000000
val1 val2
20020212220647 20020212220647
The last line should read
20020212220642 20020212220647
>How-To-Repeat:
Create a new database called test1
Run this script:
--== Script starts ==--
#!/bin/sh
username=root
password=
database=test1
mysqladmin -V
uname -a
mysql -u $username $database << EOF
drop table if exists tab1;
create table tab1 (
val1 timestamp,
val2 timestamp
);
insert into tab1 values (0,0);
select * from tab1;
EOF
mysql -u $username $database << EOF
update tab1 set val1=now();
select * from tab1;
EOF
sleep 5
mysql -u $username $database << EOF
update tab1 set val2=now();
select * from tab1;
EOF
--== Script end ==--
>Fix:
>Submitter-Id: <submitter ID>
>Originator: Gavin Cameron
>Organization:
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis:
>Severity:
>Priority:
>Category: mysql
>Class:
>Release: mysql-3.23.48 (FreeBSD port: mysql-server-3.23.48)
>Environment:
System: FreeBSD chip.gav.itworks.com.au 4.5-STABLE FreeBSD 4.5-STABLE #7: Tue Feb 5
22:44:32 EST 2002
[EMAIL PROTECTED]:/home2/src/FreeBSD/src/sys/compile/CHIP 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.3 20010315 (release) [FreeBSD]
Compilation info: CC='cc' CFLAGS='-O -pipe ' CXX='cc' CXXFLAGS='-O -pipe
-felide-constructors -fno-rtti -fno-exceptions' LDFLAGS=''
LIBC:
-r--r--r-- 1 root wheel 1208106 Feb 3 20:29 /usr/lib/libc.a
lrwxr-xr-x 1 root wheel 9 Feb 3 20:29 /usr/lib/libc.so -> libc.so.4
-r--r--r-- 1 root wheel 573792 Feb 3 20:29 /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 '--with-comment=FreeBSD port: mysql-server-3.23.48'
--enable-assembler --with-berkeley-db --with-innodb --prefix=/usr/local
i386--freebsd4.5
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
