[MCOL-4184] Table join not working in 1.4, previous worked in 1.2 Created: 2020-07-16  Updated: 2021-01-14

Status: Open
Project: MariaDB ColumnStore
Component/s: None
Affects Version/s: 1.4.4
Fix Version/s: Icebox

Type: Bug Priority: Major
Reporter: David Hill (Inactive) Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: None

Issue Links:
Relates
relates to MCOL-3814 join on view fails with "not joined" ... Closed

 Description   

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

 Comments   
Comment by David Hill (Inactive) [ 2020-10-09 ]

Customer reported there did a work-around to reolved there issue on case 96117

Solved using "SET columnstore_select_handler=0" before query and "SET columnstore_select_handler=1" after that.

Generated at Thu Feb 08 02:48:26 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.