drop table if exists CS1;

create table CS1

( 

ID int,

someText varchar(100),

FK int

) 

ENGINE=Columnstore;

drop table if exists CS2;

create table CS2

( 

ID int,

someText varchar(100)

) 

ENGINE=Columnstore;

drop table if exists InnoDB2;

create table InnoDB2

( 

ID int,

someText varchar(100)

) 

ENGINE=InnoDB;

select CS1.ID, CS2.someText

from CS1

join CS2 on CS1.FK = CS2.ID;

select CS1.ID, InnoDB2.someText

from CS1

join InnoDB2 on CS1.FK = InnoDB2.ID;

-- works!!!

drop view if exists view_on_CS_tables;

create view view_on_CS_tables as 

select CS1.ID, CS2.someText

from CS1

left outer join CS2 on CS1.FK = CS2.ID;

select count(*) from view_on_CS_tables;

drop view if exists view_on_CS_and_InnoDB_tables;

create view view_on_CS_tables_and_InnoDB_tables as 

select CS1.ID, InnoDB2.someText

from CS1

left outer join InnoDB2 on CS1.FK = InnoDB2.ID;

select count(*) from view_on_CS_tables; -- works

select count(*) from view_on_CS_tables_and_InnoDB_tables;

-- Error Code: 1815. Internal error: IDB-1000: 'view_on_cs_tables_and_innodb_tables' and 'innodb2' are not joined.