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

ALTER TABLE doesn't allow altering CHARSET or COLLATE

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Won't Fix
    • 5.5.1
    • Icebox
    • DDLProc
    • 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

              gdorman Gregory Dorman (Inactive)
              David.Hall David Hall (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.