Debian Codegraph @

mysql-test/suite/innodb/r/instant_alter_charset,redundant.rdiff

raw
1 @@ -279,7 +279,6 @@
2 alter table boundary_255
3 modify a varchar(70) charset utf8mb4,
4 algorithm=instant;
5 -ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
6 drop table boundary_255;
7 create table t (
8 a char(10) collate utf8mb3_general_ci,
9 @@ -297,32 +296,21 @@
10 repeat('a', 10), repeat('a', 10)
11 );
12 alter table t modify a char(10) collate utf8mb4_general_ci, algorithm=instant;
13 -check table t;
14 -Table Op Msg_type Msg_text
15 -test.t check status OK
16 +ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
17 alter table t modify b char(70) collate utf8mb4_general_ci, algorithm=instant;
18 -check table t;
19 -Table Op Msg_type Msg_text
20 -test.t check status OK
21 +ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
22 alter table t modify c char(100) collate utf8mb4_general_ci, algorithm=instant;
23 -check table t;
24 -Table Op Msg_type Msg_text
25 -test.t check status OK
26 +ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
27 alter table t modify aa char(10) collate utf8mb4_general_ci, algorithm=instant;
28 -check table t;
29 -Table Op Msg_type Msg_text
30 -test.t check status OK
31 +ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
32 alter table t modify bb char(70) collate utf8mb4_general_ci, algorithm=instant;
33 -check table t;
34 -Table Op Msg_type Msg_text
35 -test.t check status OK
36 +ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
37 alter table t modify cc char(100) collate utf8mb4_general_ci, algorithm=instant;
38 -check table t;
39 -Table Op Msg_type Msg_text
40 -test.t check status OK
41 +ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
42 alter table t modify d char(10) collate utf8mb4_spanish_ci, algorithm=instant;
43 +ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
44 alter table t modify dd char(10) collate utf8mb4_spanish_ci, algorithm=instant;
45 -ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: ADD INDEX. Try ALGORITHM=NOCOPY
46 +ERROR 0A000: ALGORITHM=INSTANT is not supported. Reason: Cannot change column type. Try ALGORITHM=COPY
47 select * from t;
48 a b c aa bb cc d dd
49 aaaaaaaaaa aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa aaaaaaaaaa aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa aaaaaaaaaa aaaaaaaaaa
50 @@ -2066,7 +2054,7 @@
51 ALTER TABLE t1
52 CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci,
53 ADD UNIQUE INDEX test_key (a);
54 -ERROR 23000: Duplicate entry 'NULL' for key 'test_key'
55 +ERROR 23000: Duplicate entry 'a1' for key 'test_key'
56 ALTER TABLE t1 CONVERT TO CHARACTER SET UTF8MB4 COLLATE UTF8MB4_UNICODE_520_CI;
57 CHECK TABLE t1;
58 Table Op Msg_type Msg_text