Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-5171

MariaDB Columnstore: subquery cannot be used with NVL

    XMLWordPrintable

Details

    • New Feature
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 5.6.3
    • Icebox
    • None
    • None
    • mariadb 10.5.13
      Red Hat Enterprise Linux release 8.5
      RAM 128GB
      8 cpus
      single server setup

    Description

      Over a sub-query for the selected columns only an NVL can be done if both affected tables are InnoDB. If one of them is Columnstore, the error:

      Error Code: 1178. The storage engine for the table doesn't support IDB-3016: Function or Operator with sub query on the SELECT clause is currently not supported.
      occurs.

      Error occurs on EBI03 with MariaDB 10.5, Columnstore 5.6.3.

      How to reproduce:

      comment out the lines with "detailNameWorks"
      delete the comments on the lines with "detailNameError"

      Attachments

        Issue Links

          Activity

            People

              maxmether Max Mether
              aeae81 andreas eschbacher
              Votes:
              1 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

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