ERROR 1020 should be avoided when parent row receives unrelated update

-- Setup

create table referenced_table (id int primary key, unrelated_column varchar(100));

create table insert_issue (id int primary key, ref_id int references referenced_table (id));

insert into referenced_table (id, unrelated_column) values (1, 'original value');

commit;

-- Transaction 1

start transaction;

select id from referenced_table where id = 1;

-- continued later

-- Transaction 2

start transaction;

update referenced_table set unrelated_column = 'updated value' where id = 1;

commit;

-- Transaction 1 (continued)

insert into insert_issue (id, ref_id) values (1, 1);

-- ERROR 1020 (HY000): Record has changed since last read in table 'insert_issue'

-- (The error message references the wrong table, see MDEV-37825.)

--source include/have_innodb.inc

create table referenced_table (id int primary key, unrelated_column varchar(100)) engine=innodb;

create table insert_issue (id int primary key, ref_id int references referenced_table (id)) engine=innodb;

insert into referenced_table (id, unrelated_column) values (1, 'original value');

start transaction with consistent snapshot;

--connect con1,localhost,root

update referenced_table set unrelated_column = 'updated value' where id = 1;

--disconnect con1

--connection default

insert into insert_issue (id, ref_id) values (1, 1);

drop table insert_issue,referenced_table;