List:General Discussion« Previous MessageNext Message »
From:Michael Widenius Date:August 22 1999 5:46pm
Subject:Rematch of modified record in update
View as plain text  
>>>>> "hugo" == hugo  <hugo@stripped> writes:

>> Description:
hugo> An update that should match one row updated the same row many times.
hugo> Here is the sequence of events:

<cut>

mysql> update MailConfiguration set FileName=concat(Filename,".old") where UserID =
> 34600;
hugo> Query OK, 19 rows affected (0.12 sec)
hugo> Rows matched: 20  Changed: 19  Warnings: 2

mysql> select * from MailConfiguration where UserID = 34600
hugo>
> +---------------------+----------------+--------+----------------------------------------------------------------------------------+----------+------------+
hugo> | Created             | LastUpdated    | UserID | FileName                       
>                                                  | Contents | Executable |
hugo>
> +---------------------+----------------+--------+----------------------------------------------------------------------------------+----------+------------+
hugo> | 1999-08-17 15:44:25 | 19990818132132 |  34600 |
> .qmail.old.old.old.old.old.old.old.old.old.old.old.old.old.old.old.old.old.old.o | ./Mail/
>  | N          |
hugo>
> +---------------------+----------------+--------+----------------------------------------------------------------------------------+----------+------------+

Hi!

Try to repeat this;  If you can create a test of this, please ftp it
to:

ftp://www.mysql.com/pub/mysql/secret

and I will take a look at this!

Regards,
Monty
Thread
Rematch of modified record in updatehugo18 Aug
  • Rematch of modified record in updatesinisa18 Aug
    • Re: Rematch of modified record in updateHugo van der Sanden18 Aug
      • Re: Rematch of modified record in updateMichael Widenius23 Aug
        • Re: Rematch of modified record in updateHugo van der Sanden23 Aug
        • Re: Rematch of modified record in updateHugo van der Sanden2 Sep
          • Re: Rematch of modified record in updateMichael Widenius2 Sep
            • Re: Rematch of modified record in updateHugo van der Sanden3 Sep
              • Re: Rematch of modified record in updateMichael Widenius7 Sep
  • Rematch of modified record in updateMichael Widenius23 Aug