create table t1 (a int);
insert into t1 values(1);
grant CREATE, SELECT, DROP on *.* to test@localhost;
set global read_only=1;
create table t3 (a int);
drop table t3;
create temporary table t3 (a int);
create temporary table t4 (a int) select * from t3;
insert into t3 values(1);
insert into t4 select * from t3;
update t1,t3 set t1.a=t3.a+1 where t1.a=t3.a;
ERROR HY000: The MySQL server is running with the --read-only option so it cannot execute this statement
update t1,t3 set t3.a=t1.a+1 where t1.a=t3.a;