[MDEV-16176] ER_INVALID_CHARACTER_STRING and Incorrect information in frm file upon ALTERs on a table with virtual column - Jira

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.

is part of

MDEV-16110 ALTER with ALGORITHM=INPLACE breaks temporary table with virtual columns

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

MariaDB Server