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