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
