Table join not working in 1.4, previous worked in 1.2

Customer reporting at a query that previously worked on 1.2 doesn't work on 1.4.

Here is the error and info, Ill add the query in a following comment that is protected.

The returned error is: Internal error: IDB-1000: 'dominio_periodo, sub-query' and 'visita' are not joined.

We are on mariadb 10.4.12-6-MariaDB-enterprise-log MariaDB Enterprise Server;
on our previous version (10.3.16-MariaDB-log Columnstore 1.2.5-1) it worked perfectly ;
is.dominio_periodo is INNODB, while all other tables are Columnstore