Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-19236

Improve error message for ER_ALTER_OPERATION_NOT_SUPPORTED_REASON_COLUMN_TYPE

    XMLWordPrintable

    Details

      Description

      The fix is to remove word INPLACE from patch. Because it might be incorrect in case if user actually specified ALGORITHM=INSTANT.

      create table t (a varchar(100)) engine=innodb;
      alter table t modify a varchar(300), algorithm=instant;
       
      mysqltest: At line 11: query 'alter table t modify a varchar(300), algorithm=instant' failed: 1846: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type INPLACE. Try ALGORITHM=COPY
      

        Attachments

          Activity

            People

            Assignee:
            marko Marko Mäkelä
            Reporter:
            kevg Eugene Kosov
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: