Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. 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

    XMLWordPrintable

Details

    • 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

          Activity

            People

              denis0x0D Denis Khalikov
              niljoshi Nilnandan Joshi
              Daniel Lee Daniel Lee (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.