Avoid MDB's optimizer to solve 'Circular join' and 'tables not joined' errors (MCOL-3593)

[MCOL-3603] IN + noncorrelated subquery Created: 2019-11-08  Updated: 2019-11-26  Resolved: 2019-11-26

Status: Closed
Project: MariaDB ColumnStore
Component/s: None
Affects Version/s: None
Fix Version/s: 1.4.1

Type: Sub-Task Priority: Major
Reporter: Roman Assignee: Daniel Lee (Inactive)
Resolution: Fixed Votes: 0
Labels: None

Sprint: 2019-06

 Description   

Here is the list to test:
working_tpch1/misc/bug3911.sql
working_tpch1/misc/bug3932.sql
working_tpch1/misc/bug4215.sql
working_tpch1/misc/bug4757.sql
working_tpch1/misc/fluffycat.sql

 Comments   
Comment by Daniel Lee (Inactive) [ 2019-11-26 ]

Build verified: 1.4.1-1
engine commit:
57724e5

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