This post originated from an RSS feed registered with PHP Buzz
by Andrew Johnstone.
Original Post: MySQL 5.0.51a-24+lenny2: Broken updates
Feed Title: Development, Analysis And Research
Feed URL: http://www.ajohnstone.com/feed/atom/
Feed Description: by Andrew Johnstone
I have seen a problem with MySQL failing to update tables several times and despite having a valid UPDATE statement and data that should be modified after an update, there were no modifications made (not having any triggers enabled). As a quick example:
mysql> SELECT price_ask, price_bid, price_mid FROM instruments WHERE symbol = 'A.N'\G
*************************** 1. row [...]