[#MDEV-26671] Inconsistent SELECT View when modify a record added by another transaction

If a transaction modifies an inserted record by a concurrent transaction,
the visibility of this new record for the current transaction depends on the value of the inserted record.

/* init */ drop table if exists t;

/* init */ create table t(a int, b int);

/* init */ insert into t values (0, 0), (1, 1);

/* s1 */ begin;

/* s1 */ select * from t; -- [(0, 0), (1, 1)]

/* s2 */ begin;

/* s2 */ insert into t values (10, 2);

/* s2 */ commit;

/* s1 */ select * from t; -- [(0, 0), (1, 1)]

/* s1 */ update t set a = 10 where true;

/* s1 */ select * from t;  -- [(10, 0), (10, 1)]

/* s1 */ commit;

-------------------------------------------------------------

/* init */ drop table if exists t;

/* init */ create table t(a int, b int);

/* init */ insert into t values (0, 0), (1, 1);

/* s1 */ begin;

/* s1 */ select * from t; -- [(0, 0), (1, 1)]

/* s2 */ begin;

/* s2 */ insert into t values (11, 2);

/* s2 */ commit;

/* s1 */ select * from t; -- [(0, 0), (1, 1)]

/* s1 */ update t set a = 10 where true;

/* s1 */ select * from t;  -- [(10, 0), (10, 1), (10, 2)]

/* s1 */ commit;

[MDEV-26671] Inconsistent SELECT View when modify a record added by another transaction Created: 2021-09-24 Updated: 2021-11-01
Status:	Open
Project:	MariaDB Server
Component/s:	Storage Engine - InnoDB
Affects Version/s:	10.5.12
Fix Version/s:	10.5, 10.6

[MDEV-26671] Inconsistent SELECT View when modify a record added by another transaction Created: 2021-09-24 Updated: 2021-11-01