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

default is required for charset clause on columnstore tables

    XMLWordPrintable

Details

    Description

      According to standard mariadb syntax: https://mariadb.com/kb/en/mariadb/create-table/#default-character-setcharset 'default' is optional with charset, however it is required if the table is columnstore. This was reported here: https://mariadb.com/kb/en/mariadb/create-table-charset/

      The test below shows this and it working for InnodB:

      MariaDB [test]> create table t1(c char(10)) engine=columnstore charset=latin1;
      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.
      MariaDB [test]> create table t1(c char(10)) engine=columnstore default charset=latin1;
      Query OK, 0 rows affected (0.47 sec)
      MariaDB [test]> create table t2(c char(10)) engine=InnoDB charset=latin1;
      Query OK, 0 rows affected (0.02 sec)
      

      Attachments

        Activity

          People

            Unassigned Unassigned
            dthompson David Thompson (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.