Hi,
I tried to update a column of a record more than once within a
transaction. But it seemed that only the first update took effect.
For example, for a table "CREATE TABLE people (id TINYINT PRIMARY KEY,
name VARCHAR(128) NOT NULL)",
sql>select * from people;
+------+-----------------------------+
| id | name |
+======+=============+
| 0 | Phil Ivey |
| 1 | Michael Jordan |
| 2 | Lionel Messi |
+------+-----------------------------+
sql>start transaction;
auto commit mode: off
sql>update people set id = -1 where name='Phil Ivey';
1 affected row
sql>select * from people;
+------+-----------------------------+
| id | name |
+======+=============+
| 1 | Michael Jordan |
| 2 | Lionel Messi |
| -1 | Phil Ivey |
+------+-----------------------------+
sql>update people set id = -2 where name='Phil Ivey';
1 affected row
sql>select * from people;
+------+-----------------------------+
| id | name |
+======+=============+
| 1 | Michael Jordan |
| 2 | Lionel Messi |
| -1 | Phil Ivey |
+------+-----------------------------+
sql>commit;
auto commit mode: on
sql>select * from people;
+------+-----------------------------+
| id | name |
+======+=============+
| -1 | Phil Ivey |
| 1 | Michael Jordan |
| 2 | Lionel Messi |
+------+-----------------------------+
It is not what we would expect, isn't it? My MonetDB version is v5.18.3
Min
