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

Columnstore errors while setting CHARSET

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Cannot Reproduce
    • 1.5.2
    • N/A
    • N/A
    • None

    Description

      Build:
      1.5.2-1

      The following syntaxes throws an error with engine=Columnstore-
      table level:
      CREATE TABLE t1 (id INT, name VARCHAR(40)) CHARACTER SET utf8 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. Please check the Columnstore syntax guide for supported syntax or data types.

      CREATE TABLE t1 (id INT, name VARCHAR(40)) CHARSET 'utf8' 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. Please check the Columnstore syntax guide for supported syntax or data types.

      CREATE TABLE t1 (id INT, name VARCHAR(40)) CHAR SET utf8 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. Please check the Columnstore syntax guide for supported syntax or data types.

      column level:
      CREATE TABLE t1 (id INT, name VARCHAR(40) CHARSET 'utf8')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. Please check the Columnstore syntax guide for supported syntax or data types.

      The same syntaxes work fine with engine=Innodb.

      These are the syntaxes that work with engine=Columnstore-
      table level:
      CREATE TABLE t1 (id INT, name VARCHAR(40)) CHARSET utf8 ENGINE=Columnstore;
      column level
      CREATE TABLE t2 (id INT, name VARCHAR(40)CHARACTER SET utf8) ENGINE=Columnstore;
      CREATE TABLE t2 (id INT, name VARCHAR(40)CHARACTER SET 'utf8') ENGINE=Columnstore;
      CREATE TABLE t2 (id INT, name VARCHAR(40)CHAR SET utf8) ENGINE=Columnstore;

      Attachments

        Activity

          People

            Unassigned Unassigned
            bharath.bokka Bharath Bokka (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.