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

ER_INVALID_CHARACTER_STRING and Incorrect information in frm file upon ALTERs on a table with virtual column

    XMLWordPrintable

    Details

      Description

      CREATE TABLE t1 (a INT, b INT, v INT AS (b));
      --error ER_DUP_FIELDNAME
      ALTER TABLE t1 CHANGE COLUMN IF EXISTS b a INT;
      ALTER TABLE t1 FORCE;
       
      # Cleanup
      DROP TABLE t1;
      

      10.2 6c0f3dd3414a97266

      mysqltest: At line 4: query 'ALTER TABLE t1 FORCE' failed: 1300: Invalid utf8mb4 character string: '\xA5\xA5\xA5\xA5\xA5\xA5\xA5\xA5\xA5\xA5\xA5\xA5\xA5\xA5\xA5\xA5'
      

      In the error log:

      2018-05-15 16:02:56 139984398599936 [ERROR] mysqld: Incorrect information in file: './test/#sql-735a_4.frm'
      

      Not reproducible on 10.1.

      Please note that Incorrect information in file is suppressed in MTR, so it doesn't show up itself as a failure.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              serg Sergei Golubchik
              Reporter:
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: