This does not answer your problem, but 'timestamp' is a reserved word.
Jan Legenhausen wrote:
>
> Hi,
>
> i just upgraded from 3.23.33 to 3.23.35 and found that a little script of
> mine which simply modifys a table went mad completly.
> I figured out a testcase which shows at least one of the strange things
> which happen:
>
> Table definition and data:
>
> CREATE TABLE t_webmaster (
> lfdnr int(10) unsigned NOT NULL default '0',
> ticket int(10) unsigned NOT NULL default '0',
> client varchar(255) NOT NULL default '',
> replyto varchar(255) NOT NULL default '',
> subject varchar(100) NOT NULL default '',
> timestamp int(10) unsigned NOT NULL default '0',
> tstamp timestamp(14) NOT NULL,
> status int(3) NOT NULL default '0',
> type varchar(15) NOT NULL default '',
> assignment int(10) unsigned NOT NULL default '0',
> fupcount int(4) unsigned NOT NULL default '0',
> parent int(10) unsigned NOT NULL default '0',
> activity int(10) unsigned NOT NULL default '0',
> priority tinyint(1) unsigned NOT NULL default '1',
> cc varchar(255) NOT NULL default '',
> bcc varchar(255) NOT NULL default '',
> body text NOT NULL,
> comment text,
> header text,
> PRIMARY KEY (lfdnr),
> KEY k1 (timestamp),
> KEY k2 (type),
> KEY k3 (parent),
> KEY k4 (assignment),
> KEY ticket (ticket)
> ) TYPE=MyISAM;
>
> INSERT INTO t_webmaster VALUES
> (773,773,'','','',980257344,20010318180652,0,'Open',10,0,0,0,1,'','','','','
> ');
>
> Actions:
> - modify "lfdnr":
> mysql> alter table t_webmaster change lfdnr lfdnr int(10) unsigned default 0
> not null auto_increment;
> Query OK, 1 row affected (0.01 sec)
>
> - modify data:
> mysql> update t_webmaster set status=1 where type='Open';
> Query OK, 0 rows affected (0.01 sec)
> (Wrong result!)
>
> - modify data 2nd time:
> mysql> update t_webmaster set status=1 where type='Open';
> Query OK, 1 row affected (0.00 sec)
> (Now it's done...)
>
> Looks like i've to downgrade... :-/
>
> regards, Jan Legenhausen
>
> (some system info below)
>
> >Release: mysql-3.23.35 (Source distribution)
> >Server: /usr/local/bin/mysqladmin Ver 8.18 Distrib 3.23.35, for
> pc-linux-gnu on i586
> 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.35
> Protocol version 10
> Connection Localhost via UNIX socket
> UNIX socket /tmp/mysql.sock
> Uptime: 4 hours 15 min 18 sec
>
> Threads: 1 Questions: 9265 Slow queries: 0 Opens: 267 Flush tables: 1
> Open tables: 8 Queries per second avg: 0.605
> >Environment:
> <machine, os, target, libraries (multiple lines)>
> System: Linux balin 2.2.18 #1 Fri Jan 19 22:10:35 GMT 2001 i586 unknown
> Architecture: i586
>
> Configure command:
> ./configure --with-innobase --without-debug --without-docs
>
> ---------------------------------------------------------------------
> 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