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

[MCOL-3601] OUTER JOIN doesn't work 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   

These are a list of tests from the regression to test this issue: working_tpch1/misc/bug3759.sql
working_tpch1_compareLogOnly/fnJoin/bug5289.sql
working_tpch1_compareLogOnly/fnJoin/tpch05b.mod.sql
working_tpch1_compareLogOnly/fnJoin/tpch16b.sql
working_tpch1_compareLogOnly/fnJoin/tpch16.sql
working_tpch1_compareLogOnly/fnJoin/tpch18.sql
working_tpch1_compareLogOnly/fnJoin/tpch20b.sql
working_tpch1_compareLogOnly/misc/simple_outer.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:56 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.