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

ALTER TABLE .. DEFAULT CHARSET does not work

    XMLWordPrintable

Details

    Description

      According to documentation, ALTER TABLE is supposed to allow the same table options as CREATE TABLE. However, it does not seem so:

      drop table if exists t1;
      create table t1 (a timestamp) engine=Columnstore default charset=utf8;
      alter table t1 default charset=utf8;
      

      MariaDB f93bfb9288d020b190f5c73a31223fff6439687d

      MariaDB [db]> create table t1 (a timestamp) engine=Columnstore default charset=utf8;
      Query OK, 0 rows affected (0.574 sec)
       
      MariaDB [db]> alter table t1 default charset=utf8;
      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.
      

      Please also note that something is missing in the error message after "doesn't support".

      Attachments

        Issue Links

          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.