>Description:
when i have more fields with a timestamp variable in a table and
i make a update in one off the timestamp field all field with the
timestamp variable will updated.
>How-To-Repeat:
make a table with tow or more fields with a timestamp variable.
then put different timestampvalues in the field, then make a
update of one off the field and you see the result
>Fix:
in my table i have changed all timestamp field to bigint
>Submitter-Id: <submitter ID>
>Originator: Jan
>Organization:
______________________________________
Aperto AG - Cell Network Germany
Jan Idzikowski, PM/Technik
Email mailto:[EMAIL PROTECTED]
Chausseestraße 5, D-10115 Berlin-Mitte
Phone +49 (0)30 28 39 21-600 oder O
Fax +49 (0)30 28 39 21-29
Web http://www.aperto.de
>
>MySQL support: none
>Synopsis: timestamp bug
>Severity: critical
>Priority: high
>Category: mysql
>Class: sw-bug
>Release: mysql-3.22.32 (Source distribution)
>Server: /usr/bin/mysqladmin Ver 8.0 Distrib 3.22.32, for pc-linux-gnu on i686
TCX Datakonsult AB, by Monty
Server version 3.22.32
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/lib/mysql/mysql.sock
Uptime: 8 days 22 hours 15 min 15 sec
Threads: 1 Questions: 68847 Slow queries: 0 Opens: 125 Flush tables: 1 Open
tables: 20
>Environment:
System: Linux xjan.aperto.de 2.2.15-4mdk #1 Wed May 10 15:31:30 CEST 2000 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/i586-mandrake-linux/2.95.3/specs
gcc version 2.95.3 19991030 (prerelease)
Compilation info: CC='gcc' CFLAGS='-O3 -fomit-frame-pointer -fno-exceptions -fno-rtti
-pipe -s -mpentium -mcpu=pentium -march=pentium -ffast-math -fexpensive-optimizations'
CXX='g++' CXXFLAGS='' LDFLAGS=''
Configure command: ./configure --with-mysqld-user=mysql
--with-unix-socket-path=/var/lib/mysql/mysql.sock --prefix=/ --exec-prefix=/usr
--libexecdir=/usr/sbin --sysconfdir=/etc --datadir=/usr/share
--localstatedir=/var/lib/mysql --infodir=/usr/info --includedir=/usr/include
--mandir=/usr/man
---------------------------------------------------------------------
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