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

ALTER TABLE doesn't allow altering CHARSET or COLLATE

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 5.5.1
    • Fix Version/s: Icebox
    • Component/s: DDLProc
    • Labels:
      None

      Description

      ALTER TABLE region MODIFY COLUMN r_comment varchar(152) CHARACTER SET utf8;
      ERROR 1815 (HY000): Internal error: CAL0001: Alter table Failed: Altertable: Error in the action type

      ALTER TABLE region MODIFY COLUMN r_comment varchar(152) COLLATE latin1_bin;
      ERROR 1815 (HY000): Internal error: CAL0001: Alter table Failed: Altertable: Error in the action type

      Realize that changing character set my change the max length of the column, since various character sets use different byte counts.

      This should be done after or in conjunction with MCOL-130 ALTER TABLE does not support changing data type

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              gdorman Gregory Dorman
              Reporter:
              David.Hall David Hall
              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.