I thought single UPDATE statements were atomic - Mark Rages - com.mysql.lists.mysql

11 messages in com.mysql.lists.mysqlI thought single UPDATE statements we...

Subject:	I thought single UPDATE statements were atomic
From:	Mark Rages (mark...@mlug.missouri.edu)
Date:	06/05/2003 04:52:21 PM
List:	com.mysql.lists.mysql

According to the docs, single update statements are atomic.

So why doesn't this work?

mysql> create table t (num INT, UNIQUE (num)); Query OK, 0 rows affected (0.00 sec)

mysql> insert into t values ('1'); Query OK, 1 row affected (0.00 sec)

mysql> insert into t values ('2'); Query OK, 1 row affected (0.00 sec)

mysql> select * from t; +------+ | num | +------+ | 1 | | 2 | +------+ 2 rows in set (0.00 sec)

mysql> update t set num=num+1; ERROR 1062: Duplicate entry '2' for key 1 mysql>

Help!