mirror of
https://github.com/MariaDB/server.git
synced 2025-04-22 23:25:37 +02:00
9a0cbd31ce
ha_innobase::check_if_supported_inplace_alter(): Refuse to change the collation of a column that would become or remain indexed as part of the ALTER TABLE operation. In MariaDB Server 10.6, we will allow this type of operation; that fix depends on MDEV-15250.
54 lines
3.1 KiB
Text
54 lines
3.1 KiB
Text
@@ -288,7 +288,6 @@
|
|
alter table boundary_255
|
|
modify a varchar(70) charset utf8mb4,
|
|
algorithm=instant;
|
|
-ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
|
|
drop table boundary_255;
|
|
create table t (
|
|
a char(10) collate utf8mb3_general_ci,
|
|
@@ -306,35 +305,21 @@
|
|
repeat('a', 10), repeat('a', 10)
|
|
);
|
|
alter table t modify a char(10) collate utf8mb4_general_ci, algorithm=instant;
|
|
-check table t;
|
|
-Table Op Msg_type Msg_text
|
|
-test.t check status OK
|
|
+ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
|
|
alter table t modify b char(70) collate utf8mb4_general_ci, algorithm=instant;
|
|
-check table t;
|
|
-Table Op Msg_type Msg_text
|
|
-test.t check status OK
|
|
+ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
|
|
alter table t modify c char(100) collate utf8mb4_general_ci, algorithm=instant;
|
|
-check table t;
|
|
-Table Op Msg_type Msg_text
|
|
-test.t check status OK
|
|
+ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
|
|
alter table t modify aa char(10) collate utf8mb4_general_ci, algorithm=instant;
|
|
-ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Collation change on an indexed column. Try ALGORITHM=COPY
|
|
-check table t;
|
|
-Table Op Msg_type Msg_text
|
|
-test.t check status OK
|
|
+ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
|
|
alter table t modify bb char(70) collate utf8mb4_general_ci, algorithm=instant;
|
|
-ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Collation change on an indexed column. Try ALGORITHM=COPY
|
|
-check table t;
|
|
-Table Op Msg_type Msg_text
|
|
-test.t check status OK
|
|
+ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
|
|
alter table t modify cc char(100) collate utf8mb4_general_ci, algorithm=instant;
|
|
-ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Collation change on an indexed column. Try ALGORITHM=COPY
|
|
-check table t;
|
|
-Table Op Msg_type Msg_text
|
|
-test.t check status OK
|
|
+ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
|
|
alter table t modify d char(10) collate utf8mb4_spanish_ci, algorithm=instant;
|
|
+ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
|
|
alter table t modify dd char(10) collate utf8mb4_spanish_ci, algorithm=instant;
|
|
-ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Collation change on an indexed column. Try ALGORITHM=COPY
|
|
+ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
|
|
select * from t;
|
|
a b c aa bb cc d dd
|
|
aaaaaaaaaa aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa aaaaaaaaaa aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa aaaaaaaaaa aaaaaaaaaa
|
|
|
|
mysqltest: Result length mismatch
|