Happens with joins between storage engines too:
mysql> select * from t1_c;
------

------

------
1 row in set (0.01 sec)

mysql> select * from t2_m;
------

------

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

mysql> select t1_c.* from t1_c join t2_m;
ERROR 1815 (HY000): Internal error: IDB-1000: 't1_c' and 't2_m' are not joined.

works if both tables are MyISAM:
mysql> select t1_m.* from t1_m join t2_m;
------

------

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

further test case in MCOL-1030. At the same time we should re-enable OPT_LINK_EQUAL_FIELDS when this is implemented too.

another Testcase:

CREATE TABLE `table_1` (

`id_unique` bigint(11) NOT NULL DEFAULT 0

) ENGINE=Columnstore DEFAULT CHARSET=utf8;

insert into table_1 VALUES (1),(2),(3),(4),(5),(6),(7),(8),(9),(10),(11),(12),(13),(14);

# different Type

CREATE TABLE `table_2` (

`id_unique` varchar(255) NOT NULL

) ENGINE=CSV DEFAULT CHARSET=utf8;

INSERT INTO table_2 SELECT * FROM table_1;

SELECT DISTINCT(table_1.id_unique) FROM table_1 WHERE ( (table_1.id_unique IN (SELECT id_unique FROM table_2 WHERE id_unique IS NOT NULL)));

=> ERROR 1815 (HY000): Internal error: IDB-1000: 'table_1' and 'sub-query' are not joined.

With same datatype it works.

# same Type as table_1

CREATE TABLE `table_3` (

`id_unique` bigint(11) NOT NULL

) ENGINE=CSV DEFAULT CHARSET=utf8;

INSERT INTO table_3 SELECT * FROM table_1;

.SELECT DISTINCT(table_1.id_unique) FROM table_1 WHERE ( (table_1.id_unique IN (SELECT id_unique FROM table_3 WHERE id_unique IS NOT NULL)));

Also with
set infinidb_vtable_mode = 0;

We have another customer pushing for this fix. Its causing them issue without out and looking to moe back into using InnoDB tables more over columnstore.

One of the customers, reported that their LEFT JOIN query using "LIKE" throwing error: IDB-1000: 't1' and 't2' are not joined

select * from t1 left join t2 on t1.v like concat("%", t2.i);

Here is the test case:
======
mysql> create table test.t1 (i varchar(3), v varchar(10)) engine columnstore;
mysql> create table test.t2 (i varchar(3), v varchar(10)) engine columnstore;
mysql> insert into test.t1 values ("1", "test1") ,("2", "test2") ,("3", "test3") ,("4", "test4"), ("5", "test5");
mysql> insert into test.t2 values ("3", "test1") ,("3", "test2") ,("2", "test3") ,("4", "test4"), ("5", "test5");

mysql> select * from t1 left join t2 on t1.v like concat("%", t2.i);
ERROR 1815 (HY000): Internal error: IDB-1000: 't1' and 't2' are not joined.
====

I could reproduce the same at CS 1.2.5 locally, so changing the infinidb_vtable_mode to 0 or 2 making the JOIN query to work, but that doesn't look to be the solution.

Automated message:
----------------------------
Since this issue has not been updated since 6 weeks, it's time to move it back to Stalled.