drop table if exists t1, t2, t2_0; 

CREATE TABLE `t1` ( 

  `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 

  `a` int(11) DEFAULT NULL, 

  PRIMARY KEY (`id`) 

) ENGINE=MyISAM; 

CREATE TABLE `t2_0` ( 

  `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 

  `b` int(11) DEFAULT NULL, 

  PRIMARY KEY (`id`) 

) ENGINE=MyISAM; 

CREATE TABLE `t2` ( 

  `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 

  `b` int(11) DEFAULT NULL, 

  PRIMARY KEY (`id`) 

) ENGINE=MRG_MyISAM UNION=(`t2_0`); 

FLUSH TABLES; 

myisampack -f ./data/test/t2_0 

myisamchk -rq ./data/test/t2_0 

mysql 5.5.37-MariaDB (root) [test]> create view v2 as select * from t2;

Query OK, 0 rows affected (0.01 sec)

mysql 5.5.37-MariaDB (root) [test]> update t1 join v2 using (id) set t1.a=0;

ERROR 1036 (HY000): Table 't2_0' is read only

mysql 5.5.37-MariaDB (root) [test]> create view v2_0 as select * from t2_0;

Query OK, 0 rows affected (0.01 sec)

mysql 5.5.37-MariaDB (root) [test]> update t1 join v2_0 using (id) set t1.a=0;

ERROR 1036 (HY000): Table 't2_0' is read only