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

Support non-scalar data types enum, set, json

    XMLWordPrintable

    Details

    • Type: New Feature
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Duplicate
    • Affects Version/s: None
    • Fix Version/s: N/A
    • Component/s: N/A
    • Labels:
      None
    • Environment:
      Server version: 10.5.5-MariaDB MariaDB Server
      Columnstore: 1.5.4-1

      Description

      At present Columnstore doesn't support non-scalar data types like enum, set, json.

      CREATE TABLE t_enum(col ENUM('min','max','avg'))ENGINE=Columnstore;
      ERROR 1178 (42000): The storage engine for the table doesn't support The syntax or the data type(s) is not supported by Columnstore.

      CREATE TABLE t_set(col SET('x','y','z'))ENGINE=Columnstore;
      ERROR 1178 (42000): The storage engine for the table doesn't support The syntax or the data type(s) is not supported by Columnstore.

      CREATE TABLE t_json(col JSON)ENGINE=Columnstore;
      ERROR 1178 (42000): The storage engine for the table doesn't support The syntax or the data type(s) is not supported by Columnstore.

      Like Innodb we should support the above data types.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              toddstoffel Todd Stoffel
              Reporter:
              susil.behera susil.behera
              Votes:
              0 Vote for this issue
              Watchers:
              1 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.