-- create a columnstore and an innodb table

drop table if exists mcs; drop table if exists idb; 

create table mcs(a int, b int) engine=columnstore;

create table idb(a int, b int) engine=innodb;

-- insert some rows

insert into mcs(a,b) values(1,2),(2,3),(4,5);

insert into idb(a,b) values(1,2),(2,3),(4,5);

-- columnstore can be update with innodb

update mcs dest join idb src on dest.a=src.a set dest.b=src.b;

--- ERROR: innodb cannot be update with columnstore

update idb dest join mcs src on dest.a=src.a set dest.b=src.b;

=> Error Code: 1815. Internal error: IDB-2006: 'my_db.idb' does not exist in Columnstore.