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

Dynamic columns can be stored in ColumnStore table, but cannot be extracted

    XMLWordPrintable

Details

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

    Description

      drop table if exists t2;
      create table t2 (b blob) engine=Columnstore;
      insert into t2 values (column_create('foo','bar'));
      select column_json(b) from t2;
      

      MariaDB f93bfb9288d020b190f5c73a31223fff6439687d

      MariaDB [db]> insert into t2 values (column_create('foo','bar'));
      Query OK, 1 row affected (0.148 sec)
       
      MariaDB [db]> select column_json(b) from t2;
      ERROR 1178 (42000): The storage engine for the table doesn't support IDB-1001: Function 'column_json' can only be used in the outermost select or order by clause and cannot be used in conjunction with an aggregate function.
      

      It's not very surprising that functionality is not supported, but the error is strange, and also probably INSERT should be rejected.

      Attachments

        Activity

          People

            toddstoffel Todd Stoffel (Inactive)
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            4 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.