[MCOL-5061] Selecting VIEW throws 1815. Internal error when the VIEW definition contains nested and non nested LEFT JOINS and On clause filter on the nested JOIN Created: 2022-04-22  Updated: 2023-11-17  Resolved: 2022-07-28

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

Type: Bug Priority: Major
Reporter: Nilnandan Joshi Assignee: Denis Khalikov
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Relates
relates to MCOL-5167 JOIN: support on clause filter for ta... Closed
Sprint: 2021-17
Assigned for Testing: Daniel Lee Daniel Lee (Inactive)

 Description   

MariaDB [test]> SELECT * FROM view;
ERROR 1815 (HY000): Internal error: On clause filter involving a table not directly involved in the outer join is currently not supported.
MariaDB [test]> 

MariaDB [test]> select calgetversion();
+-----------------+
| calgetversion() |
+-----------------+
| 6.2.3           |
+-----------------+
1 row in set (0.000 sec)

Server version: 10.6.7-3-MariaDB-enterprise MariaDB Enterprise Server

This looks like same bug as https://jira.mariadb.org/browse/MCOL-1349.
Table definition and view definition are attached with the ticket and I was able to reproduce this case locally by simply creating tables, view and run select * from view.



 Comments   
Comment by alexey vorovich (Inactive) [ 2022-06-16 ]

allen.herrera please copy full select into notes (restricted)

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:55:03 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.