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