Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
5.5.37, 10.0.10
-
None
-
None
Description
These items may be related to MDEV-5981 or MDEV-6139:
|
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
|