On Wed, Jul 18, 2001 at 12:09:23PM +0200, Stephan wrote:
> Hello all!
>
> How can this happen:
>
> - Table with 537 rows - value of column q02 is 10 in all rows
> - UPDATE table SET q02=q02+20 ;
>
> -> Query OK, 1074 rows affected (0.19 sec)
> Rows matched: 1074 Changed: 1074 Warnings: 0
>
> ??? Why 1074 Rows?
>
> -> Result: all 537 show value 50 in column q02 (!! not 30 as expected 10+20=30).
> It seems that every row was touched twice by the update statement.
>
>
> Why? What went wrong with the system? What can I do to repair and
> prevent this?
>
> P.S.
> - q02 is not a key
> - isamchk -e doesn't report any errors
> - MySQL 3.22.32 on FreeBSD
Any chance you can try it on an up-to-date version of MySQL? If you
can reproduce it on 3.23.39, there's certainly a problem to be fixed.
Jeremy
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 <-- NEW
MySQL 3.23.29: up 33 days, processed 263,782,661 queries (89/sec. avg)
---------------------------------------------------------------------
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