Issue with "IDB-1002 incompatible column type specified for join condition" error

Build tested: 1.1.0-1

Columnstore returns an error while MariaDB returned results.

How to reproduce:

In InnoDB (InnoDB engine in 1.1.0-1):

create table t1 (cidx int, cchar8 char(8), cint int) engine innodb;
create table t2 (cidx int, cchar8 char(8), cint int) engine innodb;
insert into t1 values (1,'1',1);
insert into t1 values (2,'2',2);
insert into t2 values (1,'1',1);
insert into t2 values (2,'2',2);

MariaDB [d2]> select * from t1, t2 where t1.cidx = t2.cidx and t1.cchar8 = t2.cint;
------------------------------+

------------------------------+

------------------------------+
2 rows in set (0.00 sec)

insert two more rows with characters for the cchar8 column:

insert into t1 values (3,'hello',3);
insert into t1 values (4,'world',4);
insert into t2 values (3,'hello',3);
insert into t2 values (4,'world',4);

MariaDB [d2]> select * from t1, t2 where t1.cidx = t2.cidx and t1.cchar8 = t2.cint;
------------------------------+

------------------------------+

------------------------------+
2 rows in set, 2 warnings (0.00 sec)

MariaDB [d2]> show warnings;
---------------------------------------------------------

---------------------------------------------------------

---------------------------------------------------------
3 rows in set (0.00 sec)

• Not sure what the first warning is. InnoDB should not use vtable

The same test in columnstore

MariaDB [d1]> select * from t1, t2 where t1.cidx = t2.cidx and t1.cchar8 = t2.cint;
ERROR 1815 (HY000): Internal error: IDB-1002: 't1' and 't2' have incompatible column type specified for join condition.