Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.6
-
None
Description
The following test case succeeds only with copy algorithm
--source include/have_innodb.inc
|
CREATE TABLE t1 (c1 INT PRIMARY KEY, c2 INT,
|
c3 TEXT CHARACTER SET utf8 COLLATE utf8_bin not null,
|
index(c3))ENGINE=InnoDB STATS_PERSISTENT=0;
|
SHOW CREATE TABLE t1;
|
ALTER TABLE t1 CHANGE c3 c3 TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci, algorithm=inplace;
|
DROP TABLE t1;
|
10.6 40aa94df356cfa000fc43c92ff0061212d1b161d |
mysqltest: At line 6: query 'ALTER TABLE t1 CHANGE c3 c3 TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci, algorithm=inplace' failed: ER_ALTER_OPERATION_NOT_SUPPORTED_REASON (1846): ALGORITHM=INPLACE is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
|
Attachments
Issue Links
- relates to
-
MDEV-17301 Change of COLLATE unnecessarily requires ALGORITHM=COPY
- Closed
-
MDEV-29425 Buffer overflow in dict_index_t::col_info::add()
- Closed