Details
- 
    
Bug
 - 
    Status: Closed (View Workflow)
 - 
    
Major
 - 
    Resolution: Fixed
 - 
    6.2.3
 - 
    None
 
- 
        2021-17
 
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. 
Attachments
Issue Links
- relates to
 - 
                    
MCOL-5167 JOIN: support on clause filter for table which is not involved in a join
-         
 - Closed
 
 -