[MCOL-1420] Loos spanning tree check when ON clause contains references to 2 of 3 joined tables. Created: 2018-05-16  Updated: 2020-08-25  Resolved: 2018-05-16

Status: Closed
Project: MariaDB ColumnStore
Component/s: ExeMgr
Affects Version/s: 1.1.4
Fix Version/s: Icebox

Type: New Feature Priority: Major
Reporter: Roman Assignee: Andrew Hutchings (Inactive)
Resolution: Duplicate Votes: 0
Labels: None

Attachments: File ddl_proj.sql    
Issue Links:
Duplicate
duplicates MCOL-1205 support queries with circular INNER j... Closed

 Description   

jlf_tuplejoblist.cpp::spanningTreeCheck() has a loose check that fails when ON clause contains references to 2 of 3 joined tables. One could reproduce the problem using the SQL statements from the attached file.
For this particular situation nodeSet.size() = 3 and pathSet.size() = 6 in the end of the spanningTreeCheck(), that fails the spanning tree check.



 Comments   
Comment by Andrew Hutchings (Inactive) [ 2018-05-16 ]

This is a circular join so it a duplicate of MCOL-1205.

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