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

support virtual / computed columns in columnstore

    XMLWordPrintable

Details

    • New Feature
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Won't Do
    • 1.0.3
    • Icebox
    • N/A
    • None

    Description

      If you declare a computed column in a table then an error is returned stating that these are not supported:
      MariaDB [test]> create table test(i1 int, c1 varchar(7), d varchar(5) as (left(C1,5)) virtual) engine=columnstore;
      ERROR 1910 (HY000): Columnstore storage engine does not support computed columns
      MariaDB [test]> create table test(i1 int, c1 varchar(7), d varchar(5) as (left(C1,5)) persistent) engine=columnstore;
      ERROR 1910 (HY000): Columnstore storage engine does not support computed columns
      MariaDB [test]>

      We should consider supporting these, for more details:
      https://mariadb.com/kb/en/mariadb/virtual-computed-columns/

      Attachments

        Activity

          People

            toddstoffel Todd Stoffel (Inactive)
            dthompson David Thompson (Inactive)
            Votes:
            1 Vote for this issue
            Watchers:
            3 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.