An explicit cast can be used to work around this in the mean time, for example:

select * from i1 join t1 on i1.i = cast(t1.c as int);

assuming i1.i is an int column and t1.c is a char/varchar containing number strings that might match.

dleeyh Please retest in 5.4.1

Build tested: 5.4.3-1

It is still an issue

[ubuntu18:root~]# /data/qa/autopilot/databases/dbt3/sh/buildDatabase.sh tpch1 columnstore 1g
[ubuntu18:root~]# mysql tpch1
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 44
Server version: 10.5.6-4.5.4.3-MariaDB-enterprise MariaDB Enterprise Server

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [tpch1]> select ps_partkey, sum(ps_supplycost * ps_availqty) as value
-> from partsupp, supplier, nation
-> where replace(concat(ps_suppkey, 'A'), 'A', '') = s_suppkey
-> and 0-s_nationkey = 0-n_nationkey
-> and n_name = 'GERMANY'
-> group by ps_partkey
-> having sum(ps_supplycost * ps_availqty) > ( select sum(ps_supplycost * ps_availqty) * 0.0001 from partsupp, supplier, nation where ps_suppkey = s_suppkey and s_nationkey = n_nationkey and n_name = 'GERMANY' )
-> order by value desc;
ERROR 1815 (HY000): Internal error: IDB-1002: 'partsupp' and 'supplier' have incompatible column type specified for join condition.
MariaDB [tpch1]>

The "create date" on this ticket is pre-convergence with MariaDB server. If the issue still exists in a modern version of the engine/plugin please submit a new ticket.