Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.2(EOL), 10.3(EOL)
-
None
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
- is part of
-
MDEV-16110 ALTER with ALGORITHM=INPLACE breaks temporary table with virtual columns
- Closed