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

Add support for ALTER TABLE ... CONVERT TO CHARACTER SET

    XMLWordPrintable

    Details

    • Type: Task
    • Status: Confirmed (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 1.1.6
    • Fix Version/s: Icebox
    • Component/s: DDLProc
    • Labels:
      None

      Description

      If you try to execute the following:

      CREATE TABLE tab (
      `id` int(11) DEFAULT NULL,
      `str` varchar(50) DEFAULT NULL
      ) ENGINE=Columnstore DEFAULT CHARSET=latin1;
      ALTER TABLE tab CONVERT TO CHARACTER SET 'utf8' COLLATE 'utf8_general_ci';
      

      You'll get an error:

      MariaDB [db1]> CREATE TABLE tab (
          -> `id` int(11) DEFAULT NULL,
          -> `str` varchar(50) DEFAULT NULL
          -> ) ENGINE=Columnstore DEFAULT CHARSET=latin1;
      Query OK, 0 rows affected (0.19 sec)
       
      MariaDB [db1]> ALTER TABLE tab CONVERT TO CHARACTER SET 'utf8' COLLATE 'utf8_general_ci';
      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.
      

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned Unassigned
              Reporter:
              GeoffMontee Geoff Montee
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

                Created:
                Updated:

                  Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.