Have I found a serious error in mysql's handling of transactions and
threads? I am using mysql5 and with the v3 mysql connector (the
recommended one from mysql's homepage) NONE of the mysql transaction
isolations levels seems to work! with the v5 connector the below code
works. However, the environment in which I am to be using this code is
mysql 4 and the connector v3...
the code spawns two threads which each reads a column, decrements it by
1 and writes it back... unfortunately both threads reads e.g. 10 and
writes 9... clearly the end result should ...