--source include/have_innodb.inc

create table if not exists tbl1 (col1 int) engine=innodb;       
create table if not exists tbl2 (col2 int) engine=innodb;
insert into tbl1 (col1) VALUES (0),(1),(3),(5),(7),(8),(10);
insert into tbl2 (col2) VALUES (0),(1),(2),(4),(6),(8),(10);

begin;

SELECT col2 FROM tbl1 a JOIN tbl2 b ON a.col1=b.col2;

connect (addconroot, localhost, root,,);
connection addconroot;

begin;

update tbl2 SET col2=5 WHERE col2=1;

connection default;

rollback;

begin;

SELECT col1 FROM tbl1 WHERE (col1 IN (SELECT col2 FROM tbl2));

connect (addconroot1, localhost, root,,);
connection addconroot1;

begin;

update tbl2 SET col2=5 WHERE col2=1;