In several cases we need to carry out a join between tables, one or more of which is a Derived Table. For example,
create table t1(c char(1)) engine=infinidb;
create table t2(c char(1)) engine=infinidb;
select * from t1,(select c from t2)t where t1.c=t.c;
With InfiniDB this gives:
ERROR 138 (HY000): IDB-1002: 't1' has incompatible column type specified for join condition.
whereas with InnoDB (for example) it is fine.
Is this a known limitation? If so, are there any plans to fix?