d row is reported and the value is indeed only updated once.
Filed as http://bugs.mysql.com/8942
Regards, Jigal.
- Original Message -
From: "Jigal van Hemert" <[EMAIL PROTECTED]>
To:
Sent: Thursday, March 03, 2005 11:18 AM
Subject: Strange internal loop causing multiple updates
Tested on MySQL version 4.0.23, 4.1.8 and 4.1.10
OS: RedHat Fedora Core 2 / RedHat 8
Table type: InnoDB or MyISAM
Table structure:
CREATE TABLE `param_str` (
`id` int(11) NOT NULL default '0',
`name` varchar(32) NOT NULL default '',
`value` varchar(255) default NULL,
`match` varchar(255)