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

alter table renaming column failed when utf8 is used

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Won't Fix
    • None
    • None
    • DDLProc
    • None

    Description

      Build tested: develop branch

      MariaDB [mytest]> CREATE TABLE `t1` ( `c1` char(3) DEFAULT NULL ) ENGINE=Columnstore;
      Query OK, 0 rows affected (0.214 sec)

      MariaDB [mytest]> insert into t1 values ('a');
      Query OK, 1 row affected (0.113 sec)

      MariaDB [mytest]> alter table t1 change c1 c2 char(3);
      ERROR 1815 (HY000): Internal error: CAL0001: Alter table Failed: Changing the datatype of a column is not supported
      MariaDB [mytest]> alter table t1 change c1 c2;
      ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1

      The same works for innodb table
      The same statements also work for ColumnStore table when latin1 is used.

      Attachments

        Activity

          People

            leonid.fedorov Leonid Fedorov
            dleeyh Daniel Lee (Inactive)
            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.