>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

Reply via email to