MySQL always updates the first timestamp column on update, regardless.
> -----Original Message-----
> From: Alex Dusty [mailto:[EMAIL PROTECTED]]
> Sent: February 1, 2001 7:28 PM
> To: [EMAIL PROTECTED]
> Subject: Severe problem in handling timestamp column type
>
>
> >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
>
>
---------------------------------------------------------------------
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
