>Description:
There is a _severe_ problem when dealing with "timestamp" column: if I update
a column, also other columns are affected! I enclose a sample script to
show the problem
>How-To-Repeat:
create table a(t1 timestamp, t2 timestamp);
insert into a values("2001-01-20","1999-03-04");
select * from a;
update a set t2="1998-05-06";
select * from a;
drop table a;
-- The second "select" shows that column t1 changed too!
>Fix:
I don't know. I used datetime type instead of timestamp and it _seems_ working.
>Submitter-Id: <submitter ID>
>Originator: Alex Dusty
>Organization: JapoTek
>MySQL support: none
>Synopsis: Error in handling timestamp columns
>Severity: critical
>Priority: high
>Category: mysql
>Class: sw-bug
>Release: mysql-3.23.32 (Official MySQL RPM)
>Server: /usr/bin/mysqladmin Ver 8.14 Distrib 3.23.32, 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.32
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/lib/mysql/mysql.sock
Uptime: 15 hours 23 min 8 sec
Threads: 2 Questions: 8036 Slow queries: 0 Opens: 927 Flush tables: 1 Open
tables: 12 Queries per second avg: 0.145
>Environment: (tested also in other environments, always versione 3.23.32)
System: Linux japot.dyndns.org 2.2.19pre7 #8 Tue Jan 30 16:33:29 GMT+1 2001 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/2.96/specs
gcc version 2.96 20000731 (Red Hat Linux 7.0)
Compilation info: CC='egcs' CFLAGS='-O6 -fomit-frame-pointer -mpentium' CXX='egcs'
CXXFLAGS='-O6 -fomit-frame-pointer -felide-constructors
-fno-exceptions -fno-rtti -mpentium' LDFLAGS=''
LIBC:
lrwxrwxrwx 1 root root 11 Nov 23 01:05 /lib/libc.so.6 -> libc-2.2.so
-rwxr-xr-x 1 root root 4761074 Dec 15 12:39 /lib/libc-2.2.so
-rw-r--r-- 1 root root 22855536 Dec 15 12:37 /usr/lib/libc.a
-rw-r--r-- 1 root root 178 Dec 15 12:37 /usr/lib/libc.so
Configure command: ./configure --disable-shared --with-mysqld-ldflags=-all-static
--with-client-ldflags=-all-static --enable-assembler --with-mysqld-user=mysql
--with-unix-socket-path=/var/lib/mysql/mysql.sock --prefix=/
--with-extra-charsets=complex --exec-prefix=/usr --libexecdir=/usr/sbin
--sysconfdir=/etc --datadir=/usr/share --localstatedir=/var/lib/mysql
--infodir=/usr/info --includedir=/usr/include --mandir=/usr/man --without-berkeley-db
'--with-comment=Official MySQL RPM'
---------------------------------------------------------------------
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
