[MCOL-4699] support queries with circular OUTER joins Created: 2021-04-28  Updated: 2023-11-17  Resolved: 2022-07-28

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

Type: New Feature Priority: Major
Reporter: Gregory Dorman (Inactive) Assignee: Denis Khalikov
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Duplicate
is duplicated by MCOL-5121 An argument to support Circular Joins... Closed
Issue split
split from MCOL-1205 support queries with circular INNER j... Closed
Relates
relates to MCOL-4902 Views disable certain outer join opti... Closed
Epic Link: Tech debt
Sprint: 2021-7, 2021-8, 2021-9, 2021-10, 2021-11, 2021-12, 2021-13, 2021-14, 2021-15, 2021-16, 2021-17
Assigned for Testing: Daniel Lee Daniel Lee (Inactive)

 Description   

This is a continuation of MCOL-1205. The description in that ticket is the same as here - the only difference is that MCOL-1205 is now limited to dealing with INNER joins only.

 Comments   
Comment by Kyle Joiner (Inactive) [ 2022-03-31 ]

I have requested the queries and sample data from Appian.

Comment by alexey vorovich (Inactive) [ 2022-04-27 ]

kjoiner do we have an example from Appian

Comment by Denis Khalikov [ 2022-07-15 ]

https://github.com/mariadb-corporation/mariadb-columnstore-engine/pull/2444

Comment by Roman [ 2022-07-20 ]

4QA I would suggest to take a look at MTR tests to get some "inspiration" on how to test this feature. In short MCS now can handle multiple cycles in a JOIN graph.

Comment by Daniel Lee (Inactive) [ 2022-07-28 ]

Build verified: 22.08-1 (#5108)
Reproduced the issue in 6.4.2-1 and verified that it works in 22.08-1. Also verified query result matched the same test using innodb tables.

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