[MCOL-5167] JOIN: support on clause filter for table which is not involved in a join Created: 2022-07-25  Updated: 2022-10-25  Resolved: 2022-08-15

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

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

Issue Links:
Relates
relates to MCOL-5061 Selecting VIEW throws 1815. Internal ... Closed
Sprint: 2021-17
Assigned for Review: Roman Roman
Assigned for Testing: Daniel Lee Daniel Lee (Inactive)

 Comments   
Comment by Daniel Lee (Inactive) [ 2022-08-15 ]

Build verified: 22.08-1 (#5290)

Reproduced the issue in 6.4.2-1
Verified the fix in 22.08-1

MariaDB [mytest]> select * from t1 left join t2 on (t1.a = t2.a) left join t3 on (t1.b = t3.b and t2.a > 1);
 
+------+------+------+------+------+------+
 
| a    | b    | a    | b    | a    | b    |
 
+------+------+------+------+------+------+
 
|    1 |    3 |    1 |    2 | NULL | NULL |
 
|    2 |    3 |    2 |    4 |    2 |    3 |
 
|    3 |    4 | NULL | NULL | NULL | NULL |
 
+------+------+------+------+------+------+
 
3 rows in set (0.086 sec)

Also executed MTR test suites and verified results against MariaDB server

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