| 1 |
CREATE TABLE `t` ( |
| 2 |
`a` VARCHAR(100), |
| 3 |
`b` VARCHAR(100), |
| 4 |
`c` VARCHAR(200) GENERATED ALWAYS AS (CONCAT(a,b)) VIRTUAL, |
| 5 |
`h` VARCHAR(10) DEFAULT NULL, |
| 6 |
`i` int |
| 7 |
) ENGINE=InnoDB; |
| 8 |
INSERT INTO t VALUES (REPEAT('g', 100), REPEAT('x', 10), DEFAULT, "kk", 1); |
| 9 |
INSERT INTO t VALUES (REPEAT('a', 100), REPEAT('b', 100), DEFAULT, "mm", 2); |
| 10 |
CREATE INDEX idx ON t(c(100)); |
| 11 |
SET session debug="+d,ib_alter_add_virtual_fail"; |
| 12 |
ALTER TABLE t ADD COLUMN x VARCHAR(200) GENERATED ALWAYS AS (a) VIRTUAL, ADD INDEX(h), |
| 13 |
ALGORITHM = INPLACE; |
| 14 |
ERROR 42000: The used storage engine can't index column 'x' |
| 15 |
ALTER TABLE t DROP COLUMN c, ADD INDEX(h), ALGORITHM = INPLACE; |
| 16 |
ERROR 42000: The used storage engine can't index column 'c' |
| 17 |
SET session debug="-d,ib_alter_add_virtual_fail"; |
| 18 |
DROP TABLE t; |
| 19 |
CREATE TABLE t (a INT, b INT, c INT GENERATED ALWAYS AS(a+b), h VARCHAR(10)); |
| 20 |
INSERT INTO t VALUES (11, 3, DEFAULT, 'mm'); |
| 21 |
INSERT INTO t VALUES (18, 1, DEFAULT, 'mm'); |
| 22 |
INSERT INTO t VALUES (28, 1, DEFAULT, 'mm'); |
| 23 |
INSERT INTO t VALUES (null, null, DEFAULT, "mx"); |
| 24 |
SET DEBUG_SYNC = 'innodb_inplace_alter_table_enter SIGNAL start_create WAIT_FOR go_ahead'; |
| 25 |
CREATE INDEX idx ON t(c);; |
| 26 |
SET DEBUG_SYNC = 'now WAIT_FOR start_create'; |
| 27 |
update t set a=0 where a = 11; |
| 28 |
SET DEBUG_SYNC = 'now SIGNAL go_ahead'; |
| 29 |
SELECT c FROM t; |
| 30 |
c |
| 31 |
19 |
| 32 |
29 |
| 33 |
3 |
| 34 |
NULL |
| 35 |
SHOW CREATE TABLE t; |
| 36 |
Table Create Table |
| 37 |
t CREATE TABLE `t` ( |
| 38 |
`a` int DEFAULT NULL, |
| 39 |
`b` int DEFAULT NULL, |
| 40 |
`c` int GENERATED ALWAYS AS ((`a` + `b`)) VIRTUAL, |
| 41 |
`h` varchar(10) DEFAULT NULL, |
| 42 |
KEY `idx` (`c`) |
| 43 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci |
| 44 |
SELECT * FROM t; |
| 45 |
a b c h |
| 46 |
0 3 3 mm |
| 47 |
18 1 19 mm |
| 48 |
28 1 29 mm |
| 49 |
NULL NULL NULL mx |
| 50 |
SET DEBUG_SYNC = 'innodb_inplace_alter_table_enter SIGNAL start_create WAIT_FOR go_ahead'; |
| 51 |
ALTER TABLE t ADD COLUMN x INT;; |
| 52 |
SET DEBUG_SYNC = 'now WAIT_FOR start_create'; |
| 53 |
start transaction; |
| 54 |
update t set a=1 where a = 0; |
| 55 |
ROLLBACK; |
| 56 |
SET DEBUG_SYNC = 'now SIGNAL go_ahead'; |
| 57 |
SELECT c FROM t; |
| 58 |
c |
| 59 |
19 |
| 60 |
29 |
| 61 |
3 |
| 62 |
NULL |
| 63 |
SET DEBUG_SYNC = 'innodb_inplace_alter_table_enter SIGNAL start_create WAIT_FOR go_ahead'; |
| 64 |
ALTER TABLE t ADD COLUMN x2 INT;; |
| 65 |
SET DEBUG_SYNC = 'now WAIT_FOR start_create'; |
| 66 |
start transaction; |
| 67 |
DELETE FROM t WHERE a = 0; |
| 68 |
ROLLBACK; |
| 69 |
DELETE FROM t WHERE a = 0; |
| 70 |
SET DEBUG_SYNC = 'now SIGNAL go_ahead'; |
| 71 |
SELECT c FROM t; |
| 72 |
c |
| 73 |
19 |
| 74 |
29 |
| 75 |
NULL |
| 76 |
DROP TABLE t; |
| 77 |
SET DEBUG_SYNC = 'RESET'; |
| 78 |
CREATE TABLE t (a INT, b INT, c INT GENERATED ALWAYS AS(a+b), h VARCHAR(10)); |
| 79 |
INSERT INTO t VALUES (11, 3, DEFAULT, 'mm'); |
| 80 |
INSERT INTO t VALUES (18, 1, DEFAULT, 'mm'); |
| 81 |
INSERT INTO t VALUES (28, 1, DEFAULT, 'mm'); |
| 82 |
INSERT INTO t VALUES (null, null, DEFAULT, 'mm'); |
| 83 |
CREATE INDEX idx_1 on t(c); |
| 84 |
SET SESSION debug="+d,create_index_fail"; |
| 85 |
ALTER TABLE t ADD COLUMN x INT GENERATED ALWAYS AS(a+b), ADD INDEX idx (x); |
| 86 |
ERROR 23000: Duplicate entry '' for key '*UNKNOWN*' |
| 87 |
SET SESSION debug="-d,create_index_fail"; |
| 88 |
affected rows: 0 |
| 89 |
SHOW CREATE TABLE t; |
| 90 |
Table Create Table |
| 91 |
t CREATE TABLE `t` ( |
| 92 |
`a` int DEFAULT NULL, |
| 93 |
`b` int DEFAULT NULL, |
| 94 |
`c` int GENERATED ALWAYS AS ((`a` + `b`)) VIRTUAL, |
| 95 |
`h` varchar(10) DEFAULT NULL, |
| 96 |
KEY `idx_1` (`c`) |
| 97 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci |
| 98 |
SELECT c FROM t; |
| 99 |
c |
| 100 |
14 |
| 101 |
19 |
| 102 |
29 |
| 103 |
NULL |
| 104 |
DROP TABLE t; |
| 105 |
# |
| 106 |
# Bug#22018532 ASSERTION WHEN ONLINE REAPPLY REBUILD LOG ON |
| 107 |
# MULTIPLE INDEXED VIRTUAL COLUMNS |
| 108 |
# |
| 109 |
create table t ( |
| 110 |
a int as (1) virtual, |
| 111 |
b int, |
| 112 |
c int as (1) virtual, |
| 113 |
unique(b), |
| 114 |
unique(c), |
| 115 |
key(a) |
| 116 |
) engine=innodb; |
| 117 |
insert ignore into t values(); |
| 118 |
SET DEBUG_SYNC = 'innodb_inplace_alter_table_enter SIGNAL start_create WAIT_FOR go_ahead'; |
| 119 |
optimize table t; |
| 120 |
SET DEBUG_SYNC = 'now WAIT_FOR start_create'; |
| 121 |
insert ignore into t values(); |
| 122 |
Warnings: |
| 123 |
Warning 1062 Duplicate entry '1' for key 't.c' |
| 124 |
SET DEBUG_SYNC = 'now SIGNAL go_ahead'; |
| 125 |
/* connection default */ optimize table t; |
| 126 |
Table Op Msg_type Msg_text |
| 127 |
test.t optimize note Table does not support optimize, doing recreate + analyze instead |
| 128 |
test.t optimize error Duplicate entry 'NULL' for key 't.c' |
| 129 |
test.t optimize status Operation failed |
| 130 |
Warnings: |
| 131 |
Error 1062 Duplicate entry 'NULL' for key 't.c' |
| 132 |
SELECT c FROM t; |
| 133 |
c |
| 134 |
1 |
| 135 |
SHOW CREATE TABLE t; |
| 136 |
Table Create Table |
| 137 |
t CREATE TABLE `t` ( |
| 138 |
`a` int GENERATED ALWAYS AS (1) VIRTUAL, |
| 139 |
`b` int DEFAULT NULL, |
| 140 |
`c` int GENERATED ALWAYS AS (1) VIRTUAL, |
| 141 |
UNIQUE KEY `b` (`b`), |
| 142 |
UNIQUE KEY `c` (`c`), |
| 143 |
KEY `a` (`a`) |
| 144 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci |
| 145 |
SELECT * FROM t; |
| 146 |
a b c |
| 147 |
1 NULL 1 |
| 148 |
DROP TABLE t; |
| 149 |
CREATE TABLE t (a INT, b INT, c INT GENERATED ALWAYS AS(a+b), h VARCHAR(10)); |
| 150 |
INSERT INTO t VALUES (11, 3, DEFAULT, 'mm'); |
| 151 |
INSERT INTO t VALUES (18, 1, DEFAULT, 'mm'); |
| 152 |
INSERT INTO t VALUES (28, 1, DEFAULT, 'mm'); |
| 153 |
INSERT INTO t VALUES (null, null, DEFAULT, 'mm'); |
| 154 |
CREATE INDEX idx ON t(c); |
| 155 |
SET DEBUG_SYNC = 'innodb_inplace_alter_table_enter SIGNAL start_rebuild WAIT_FOR go_ahead'; |
| 156 |
optimize table t; |
| 157 |
SET DEBUG_SYNC = 'now WAIT_FOR start_rebuild'; |
| 158 |
INSERT INTO t VALUES (48, 2, DEFAULT, 'xx'); |
| 159 |
INSERT INTO t VALUES (68, 3, DEFAULT, 'sx'); |
| 160 |
SET DEBUG_SYNC = 'now SIGNAL go_ahead'; |
| 161 |
/* connection default */ optimize table t; |
| 162 |
Table Op Msg_type Msg_text |
| 163 |
test.t optimize note Table does not support optimize, doing recreate + analyze instead |
| 164 |
test.t optimize status OK |
| 165 |
SELECT c FROM t; |
| 166 |
c |
| 167 |
14 |
| 168 |
19 |
| 169 |
29 |
| 170 |
50 |
| 171 |
71 |
| 172 |
NULL |
| 173 |
DROP TABLE t; |
| 174 |
# |
| 175 |
# Bug#22140944 WL#8149: ADD TEST FOR THE ROW0LOG.CC FIX THAT |
| 176 |
# WAS UNRELATED TO Bug#21894654 |
| 177 |
# |
| 178 |
CREATE TABLE t1 ( id INT ,a VARCHAR(20), b VARCHAR(20) ,c VARCHAR(40) |
| 179 |
GENERATED ALWAYS AS (CONCAT(a,b)),key(c)); |
| 180 |
INSERT INTO t1 (id,a,b) VALUES (10,'aditya','hello'); |
| 181 |
SET DEBUG_SYNC= 'ddl_after_scan SIGNAL opened WAIT_FOR go_ddl'; |
| 182 |
ALTER TABLE t1 ADD CONSTRAINT pk1 PRIMARY KEY (id); |
| 183 |
SET DEBUG_SYNC= 'now WAIT_FOR opened'; |
| 184 |
UPDATE t1 SET a = 'fg', id = 20 WHERE id = 10; |
| 185 |
SET DEBUG_SYNC= 'now SIGNAL go_ddl'; |
| 186 |
SELECT * from t1; |
| 187 |
id a b c |
| 188 |
20 fg hello fghello |
| 189 |
DROP TABLE t1; |
| 190 |
# |
| 191 |
# Bug#22951879 - ASSERTS RELATED TO ONLINE DDL AND GCOL |
| 192 |
# |
| 193 |
create table ibstd_14 (a int not null, d int not null, b varchar(198) not null, c char(181), vadcol int as (a+length(d)) stored, vbcol char(2) as (substr(b,2,2)) virtual, vbidxcol char(3) as (substr(b,1,3)) virtual , index(d), index(a), index(vbidxcol), index(a,vbidxcol), index(vbidxcol,d), unique key (b(10), a, d), index(c(99), b(31)), index(b(5), c(10), a) , index(a,d)) engine=InnoDB stats_persistent=1 row_format=dynamic charset latin1; |
| 194 |
SET DEBUG_SYNC = 'innodb_inplace_alter_table_enter SIGNAL start_create WAIT_FOR go_ahead'; |
| 195 |
alter table ibstd_14 row_format=compressed key_block_size=4,add key kn3 (d,c,vbcol,b);; |
| 196 |
SET DEBUG_SYNC = 'now WAIT_FOR start_create'; |
| 197 |
insert into ibstd_14 (a,d,b,c, vbidxcol, vbcol) values ('118','6',repeat('oacolaarlruoacuroauurloraarucoooarcooauoolacalllaulrruarrrucruuooclacuoouccarrcoocloccorrrrarourcooalloocooccouruolaorlcaocualolc','1'),repeat('lolrrlalcocroraaulauclaaucolcorcuooaolruaooooluooooouaoorlarucorullalcrrloccououaooaorluorraclrcooouuolocoaolcocaaculruoocucoocoooauuolarcoraraocaoolulolarru','1'),default,default); |
| 198 |
insert into ibstd_14 (a,d,b,c, vbidxcol, vbcol) values ('118','6', 'aaaa', 'lll', default, default); |
| 199 |
update ibstd_14 set b='11111' where b='aaaa'; |
| 200 |
SET DEBUG_SYNC = 'now SIGNAL go_ahead'; |
| 201 |
select * from ibstd_14; |
| 202 |
a d b c vadcol vbcol vbidxcol |
| 203 |
118 6 oacolaarlruoacuroauurloraarucoooarcooauoolacalllaulrruarrrucruuooclacuoouccarrcoocloccorrrrarourcooalloocooccouruolaorlcaocualolc lolrrlalcocroraaulauclaaucolcorcuooaolruaooooluooooouaoorlarucorullalcrrloccououaooaorluorraclrcooouuolocoaolcocaaculruoocucoocoooauuolarcoraraocaoolulolarru 119 ac oac |
| 204 |
118 6 11111 lll 119 11 111 |
| 205 |
select d,c,vbcol,b from ibstd_14; |
| 206 |
d c vbcol b |
| 207 |
6 lll 11 11111 |
| 208 |
6 lolrrlalcocroraaulauclaaucolcorcuooaolruaooooluooooouaoorlarucorullalcrrloccououaooaorluorraclrcooouuolocoaolcocaaculruoocucoocoooauuolarcoraraocaoolulolarru ac oacolaarlruoacuroauurloraarucoooarcooauoolacalllaulrruarrrucruuooclacuoouccarrcoocloccorrrrarourcooalloocooccouruolaorlcaocualolc |
| 209 |
select vbcol from ibstd_14; |
| 210 |
vbcol |
| 211 |
11 |
| 212 |
ac |
| 213 |
drop table ibstd_14; |
| 214 |
# |
| 215 |
# Bug#26375771 INNODB: ASSERTION FAILURE: MACH0DATA.IC:308:VAL > 0X7F |
| 216 |
# |
| 217 |
create table ibstd_07 (a int not null, d int not null, b blob not null, c text, vadcol int as (a+length(d)) stored, vbcol char(2) as (substr(b,2,2)) virtual, vbidxcol char(3) as (substr(b,1,3)) virtual , index(d desc), index(a desc), index(vbidxcol desc), index(vbidxcol desc,d asc), unique key (b(101) desc, a asc, d ), index(c(255) desc, b(255) asc), index(b(5) desc, c(10) asc, a ) ) engine=InnoDB default charset=latin1 row_format=redundant; |
| 218 |
insert into ibstd_07 values (2, 2, repeat('rocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaooc','281'),repeat('ouolrculuouocououooalcoraooaulouuacrolrocooraoaooooolaccralacalooolalocoaacoorarorcurccarocucla','317'), default, default, default); |
| 219 |
SET DEBUG_SYNC = 'innodb_inplace_alter_table_enter SIGNAL start_create WAIT_FOR go_ahead'; |
| 220 |
alter table ibstd_07 add primary key (b(11) desc,a asc, d );; |
| 221 |
SET DEBUG_SYNC = 'now WAIT_FOR start_create'; |
| 222 |
update ibstd_07 set c=repeat('0.366710324443464crllooolarlollorlulololucrluacoorrrluroluroocouauacacruloulcurlraorcrclrolcocrrcoccolourrooclrcocruruauallo','70'); |
| 223 |
SET DEBUG_SYNC = 'now SIGNAL go_ahead'; |
| 224 |
SELECT * FROM ibstd_07; |
| 225 |
a d b c vadcol vbcol vbidxcol |
| 226 |
2 2 rocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaoocrocalrulcrcaurcuccoolrouuocacaooaucauualcucuoucucclolcllloocuarcoorlaccarocouuaoorcolloucraoaaooc 0.366710324443464crllooolarlollorlulololucrluacoorrrluroluroocouauacacruloulcurlraorcrclrolcocrrcoccolourrooclrcocruruauallo0.366710324443464crllooolarlollorlulololucrluacoorrrluroluroocouauacacruloulcurlraorcrclrolcocrrcoccolourrooclrcocruruauallo0.366710324443464crllooolarlollorlulololucrluacoorrrluroluroocouauacacruloulcurlraorcrclrolcocrrcoccolourrooclrcocruruauallo0.366710324443464crllooolarlollorlulololucrluacoorrrluroluroocouauacacruloulcurlraorcrclrolcocrrcoccolourrooclrcocruruauallo0.366710324443464crllooolarlollorlulololucrluacoorrrluroluroocouauacacruloulcurlraorcrclrolcocrrcoccolourrooclrcocruruauallo0.366710324443464crllooolarlollorlulololucrluacoorrrluroluroocouauacacruloulcurlraorcrclrolcocrrcoccolourrooclrcocruruauallo0.366710324443464crllooolarlollorlulololucrluacoorrrluroluroocouauacacruloulcurlraorcrclrolcocrrcoccolourrooclrcocruruauallo0.366710324443464crllooolarlollorlulololucrluacoorrrluroluroocouauacacruloulcurlraorcrclrolcocrrcoccolourrooclrcocruruauallo0.366710324443464crllooolarlollorlulololucrluacoorrrluroluroocouauacacruloulcurlraorcrclrolcocrrcoccolourrooclrcocruruauallo0.366710324443464crllooolarlollorlulololucrluacoorrrluroluroocouauacacruloulcurlraorcrclrolcocrrcoccolourrooclrcocruruauallo0.366710324443464crllooolarlollorlulololucrluacoorrrluroluroocouauacacruloulcurlraorcrclrolcocrrcoccolourrooclrcocruruauallo0.366710324443464crllooolarlollorlulololucrluacoorrrluroluroocouauacacruloulcurlraorcrclrolcocrrcoccolourrooclrcocruruauallo0.366710324443464crllooolarlollorlulololucrluacoorrrluroluroocouauacacruloulcurlraorcrclrolcocrrcoccolourrooclrcocruruauallo0.366710324443464crllooolarlollorlulololucrluacoorrrluroluroocouauacacruloulcurlraorcrclrolcocrrcoccolourrooclrcocruruauallo0.366710324443464crllooolarlollorlulololucrluacoorrrluroluroocouauacacruloulcurlraorcrclrolcocrrcoccolourrooclrcocruruauallo0.366710324443464crllooolarlollorlulololucrluacoorrrluroluroocouauacacruloulcurlraorcrclrolcocrrcoccolourrooclrcocruruauallo0.366710324443464crllooolarlollorlulololucrluacoorrrluroluroocouauacacruloulcurlraorcrclrolcocrrcoccolourrooclrcocruruauallo0.366710324443464crllooolarlollorlulololucrluacoorrrluroluroocouauacacruloulcurlraorcrclrolcocrrcoccolourrooclrcocruruauallo0.366710324443464crllooolarlollorlulololucrluacoorrrluroluroocouauacacruloulcurlraorcrclrolcocrrcoccolourrooclrcocruruauallo0.366710324443464crllooolarlollorlulololucrluacoorrrluroluroocouauacacruloulcurlraorcrclrolcocrrcoccolourrooclrcocruruauallo0.366710324443464crllooolarlollorlulololucrluacoorrrluroluroocouauacacruloulcurlraorcrclrolcocrrcoccolourrooclrcocruruauallo0.366710324443464crllooolarlollorlulololucrluacoorrrluroluroocouauacacruloulcurlraorcrclrolcocrrcoccolourrooclrcocruruauallo0.366710324443464crllooolarlollorlulololucrluacoorrrluroluroocouauacacruloulcurlraorcrclrolcocrrcoccolourrooclrcocruruauallo0.366710324443464crllooolarlollorlulololucrluacoorrrluroluroocouauacacruloulcurlraorcrclrolcocrrcoccolourrooclrcocruruauallo0.366710324443464crllooolarlollorlulololucrluacoorrrluroluroocouauacacruloulcurlraorcrclrolcocrrcoccolourrooclrcocruruauallo0.366710324443464crllooolarlollorlulololucrluacoorrrluroluroocouauacacruloulcurlraorcrclrolcocrrcoccolourrooclrcocruruauallo0.366710324443464crllooolarlollorlulololucrluacoorrrluroluroocouauacacruloulcurlraorcrclrolcocrrcoccolourrooclrcocruruauallo0.366710324443464crllooolarlollorlulololucrluacoorrrluroluroocouauacacruloulcurlraorcrclrolcocrrcoccolourrooclrcocruruauallo0.366710324443464crllooolarlollorlulololucrluacoorrrluroluroocouauacacruloulcurlraorcrclrolcocrrcoccolourrooclrcocruruauallo0.366710324443464crllooolarlollorlulololucrluacoorrrluroluroocouauacacruloulcurlraorcrclrolcocrrcoccolourrooclrcocruruauallo0.366710324443464crllooolarlollorlulololucrluacoorrrluroluroocouauacacruloulcurlraorcrclrolcocrrcoccolourrooclrcocruruauallo0.366710324443464crllooolarlollorlulololucrluacoorrrluroluroocouauacacruloulcurlraorcrclrolcocrrcoccolourrooclrcocruruauallo0.366710324443464crllooolarlollorlulololucrluacoorrrluroluroocouauacacruloulcurlraorcrclrolcocrrcoccolourrooclrcocruruauallo0.366710324443464crllooolarlollorlulololucrluacoorrrluroluroocouauacacruloulcurlraorcrclrolcocrrcoccolourrooclrcocruruauallo0.366710324443464crllooolarlollorlulololucrluacoorrrluroluroocouauacacruloulcurlraorcrclrolcocrrcoccolourrooclrcocruruauallo0.366710324443464crllooolarlollorlulololucrluacoorrrluroluroocouauacacruloulcurlraorcrclrolcocrrcoccolourrooclrcocruruauallo0.366710324443464crllooolarlollorlulololucrluacoorrrluroluroocouauacacruloulcurlraorcrclrolcocrrcoccolourrooclrcocruruauallo0.366710324443464crllooolarlollorlulololucrluacoorrrluroluroocouauacacruloulcurlraorcrclrolcocrrcoccolourrooclrcocruruauallo0.366710324443464crllooolarlollorlulololucrluacoorrrluroluroocouauacacruloulcurlraorcrclrolcocrrcoccolourrooclrcocruruauallo0.366710324443464crllooolarlollorlulololucrluacoorrrluroluroocouauacacruloulcurlraorcrclrolcocrrcoccolourrooclrcocruruauallo0.366710324443464crllooolarlollorlulololucrluacoorrrluroluroocouauacacruloulcurlraorcrclrolcocrrcoccolourrooclrcocruruauallo0.366710324443464crllooolarlollorlulololucrluacoorrrluroluroocouauacacruloulcurlraorcrclrolcocrrcoccolourrooclrcocruruauallo0.366710324443464crllooolarlollorlulololucrluacoorrrluroluroocouauacacruloulcurlraorcrclrolcocrrcoccolourrooclrcocruruauallo0.366710324443464crllooolarlollorlulololucrluacoorrrluroluroocouauacacruloulcurlraorcrclrolcocrrcoccolourrooclrcocruruauallo0.366710324443464crllooolarlollorlulololucrluacoorrrluroluroocouauacacruloulcurlraorcrclrolcocrrcoccolourrooclrcocruruauallo0.366710324443464crllooolarlollorlulololucrluacoorrrluroluroocouauacacruloulcurlraorcrclrolcocrrcoccolourrooclrcocruruauallo0.366710324443464crllooolarlollorlulololucrluacoorrrluroluroocouauacacruloulcurlraorcrclrolcocrrcoccolourrooclrcocruruauallo0.366710324443464crllooolarlollorlulololucrluacoorrrluroluroocouauacacruloulcurlraorcrclrolcocrrcoccolourrooclrcocruruauallo0.366710324443464crllooolarlollorlulololucrluacoorrrluroluroocouauacacruloulcurlraorcrclrolcocrrcoccolourrooclrcocruruauallo0.366710324443464crllooolarlollorlulololucrluacoorrrluroluroocouauacacruloulcurlraorcrclrolcocrrcoccolourrooclrcocruruauallo0.366710324443464crllooolarlollorlulololucrluacoorrrluroluroocouauacacruloulcurlraorcrclrolcocrrcoccolourrooclrcocruruauallo0.366710324443464crllooolarlollorlulololucrluacoorrrluroluroocouauacacruloulcurlraorcrclrolcocrrcoccolourrooclrcocruruauallo0.366710324443464crllooolarlollorlulololucrluacoorrrluroluroocouauacacruloulcurlraorcrclrolcocrrcoccolourrooclrcocruruauallo0.366710324443464crllooolarlollorlulololucrluacoorrrluroluroocouauacacruloulcurlraorcrclrolcocrrcoccolourrooclrcocruruauallo0.366710324443464crllooolarlollorlulololucrluacoorrrluroluroocouauacacruloulcurlraorcrclrolcocrrcoccolourrooclrcocruruauallo0.366710324443464crllooolarlollorlulololucrluacoorrrluroluroocouauacacruloulcurlraorcrclrolcocrrcoccolourrooclrcocruruauallo0.366710324443464crllooolarlollorlulololucrluacoorrrluroluroocouauacacruloulcurlraorcrclrolcocrrcoccolourrooclrcocruruauallo0.366710324443464crllooolarlollorlulololucrluacoorrrluroluroocouauacacruloulcurlraorcrclrolcocrrcoccolourrooclrcocruruauallo0.366710324443464crllooolarlollorlulololucrluacoorrrluroluroocouauacacruloulcurlraorcrclrolcocrrcoccolourrooclrcocruruauallo0.366710324443464crllooolarlollorlulololucrluacoorrrluroluroocouauacacruloulcurlraorcrclrolcocrrcoccolourrooclrcocruruauallo0.366710324443464crllooolarlollorlulololucrluacoorrrluroluroocouauacacruloulcurlraorcrclrolcocrrcoccolourrooclrcocruruauallo0.366710324443464crllooolarlollorlulololucrluacoorrrluroluroocouauacacruloulcurlraorcrclrolcocrrcoccolourrooclrcocruruauallo0.366710324443464crllooolarlollorlulololucrluacoorrrluroluroocouauacacruloulcurlraorcrclrolcocrrcoccolourrooclrcocruruauallo0.366710324443464crllooolarlollorlulololucrluacoorrrluroluroocouauacacruloulcurlraorcrclrolcocrrcoccolourrooclrcocruruauallo0.366710324443464crllooolarlollorlulololucrluacoorrrluroluroocouauacacruloulcurlraorcrclrolcocrrcoccolourrooclrcocruruauallo0.366710324443464crllooolarlollorlulololucrluacoorrrluroluroocouauacacruloulcurlraorcrclrolcocrrcoccolourrooclrcocruruauallo0.366710324443464crllooolarlollorlulololucrluacoorrrluroluroocouauacacruloulcurlraorcrclrolcocrrcoccolourrooclrcocruruauallo0.366710324443464crllooolarlollorlulololucrluacoorrrluroluroocouauacacruloulcurlraorcrclrolcocrrcoccolourrooclrcocruruauallo0.366710324443464crllooolarlollorlulololucrluacoorrrluroluroocouauacacruloulcurlraorcrclrolcocrrcoccolourrooclrcocruruauallo0.366710324443464crllooolarlollorlulololucrluacoorrrluroluroocouauacacruloulcurlraorcrclrolcocrrcoccolourrooclrcocruruauallo 3 oc roc |
| 227 |
DROP TABLE ibstd_07; |
| 228 |
# |
| 229 |
# Bug#22018745 CORRUPTION IN ONLINE TABLE REBUILD |
| 230 |
# (ROW_FORMAT=REDUNDANT, INDEXED VIRTUAL COLUMN) |
| 231 |
# |
| 232 |
CREATE TABLE t ( |
| 233 |
b char(5) PRIMARY KEY, |
| 234 |
v char(3) GENERATED ALWAYS AS (substr(b,1,3)) VIRTUAL, KEY(v) |
| 235 |
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=REDUNDANT; |
| 236 |
SET DEBUG_SYNC='row_log_table_apply1_before SIGNAL prepared WAIT_FOR apply'; |
| 237 |
OPTIMIZE TABLE t; |
| 238 |
SET DEBUG_SYNC='now WAIT_FOR prepared'; |
| 239 |
INSERT INTO t SET b='fubar'; |
| 240 |
BEGIN; |
| 241 |
DELETE FROM t; |
| 242 |
ROLLBACK; |
| 243 |
SET DEBUG_SYNC='now SIGNAL apply'; |
| 244 |
Table Op Msg_type Msg_text |
| 245 |
test.t optimize note Table does not support optimize, doing recreate + analyze instead |
| 246 |
test.t optimize status OK |
| 247 |
CHECK TABLE t; |
| 248 |
Table Op Msg_type Msg_text |
| 249 |
test.t check status OK |
| 250 |
SELECT * FROM t; |
| 251 |
b v |
| 252 |
fubar fub |
| 253 |
DROP TABLE t; |
| 254 |
SET DEBUG_SYNC = 'RESET'; |
| 255 |
# |
| 256 |
# Bug#24658707 ASSERT: BUF0BUF.CC:2469:BUF_BLOCK_GET_STATE(BLOCK) |
| 257 |
# == BUF_BLOCK_FILE_PAGE# |
| 258 |
# |
| 259 |
CREATE TABLE t1 ( |
| 260 |
col1 int(11) NOT NULL, |
| 261 |
col2 int(11) DEFAULT NULL |
| 262 |
) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
| 263 |
Warnings: |
| 264 |
Warning 1681 Integer display width is deprecated and will be removed in a future release. |
| 265 |
Warning 1681 Integer display width is deprecated and will be removed in a future release. |
| 266 |
SET DEBUG_SYNC='purge_wait_for_btr_search_latch WAIT_FOR go'; |
| 267 |
ALTER TABLE t1 ADD COLUMN col3 INT GENERATED ALWAYS AS (col1 % col2) VIRTUAL, algorithm=inplace;; |
| 268 |
SET DEBUG_SYNC = 'now signal go'; |
| 269 |
SET DEBUG_SYNC = 'RESET'; |
| 270 |
DROP TABLE t1; |
| 271 |
# |
| 272 |
# Bug#26330279 - ASSERT ON ROW_PURGE_REMOVE_SEC_IF_POSS_LEAF| INNOBASE/ROW/ROW0PURGE.CC |
| 273 |
# |
| 274 |
SET GLOBAL innodb_purge_stop_now=ON; |
| 275 |
CREATE TABLE t1 (col1 INT, |
| 276 |
col2 VARCHAR(100), |
| 277 |
col3 VARCHAR(80) GENERATED ALWAYS AS (SUBSTR(col2,1,70)), |
| 278 |
PRIMARY KEY (col1), UNIQUE KEY uidx(col3(10))) ENGINE = InnoDB; |
| 279 |
INSERT INTO t1(col1, col2) VALUES(1, CONCAT(1, REPEAT('z',90))); |
| 280 |
REPLACE INTO t1(col1, col2) SELECT col1, col2 FROM t1; |
| 281 |
SET GLOBAL innodb_purge_run_now=ON; |
| 282 |
DROP TABLE t1; |
| 283 |
# |
| 284 |
# BUG#27319084 - INDEX CORRUPT: INNODB: FIELD 0 LEN IS NNN, SHOULD BE NNN; RECORD |
| 285 |
# |
| 286 |
CREATE TABLE t1(a INT NOT NULL, d INT NOT NULL, b VARCHAR(198) NOT NULL, c CHAR(84), vbcol CHAR(2) AS (substr(b, 2, 2)) VIRTUAL, vbidxcol CHAR(3) AS (substr(b, 1, 3)) VIRTUAL, INDEX(vbidxcol ASC)) ROW_FORMAT = DYNAMIC; |
| 287 |
INSERT INTO t1(a, d, b, c) VALUES(200, 300, '1.3.1415926535', 'hello world'); |
| 288 |
SET DEBUG_SYNC = 'row_log_table_apply1_before SIGNAL altered WAIT_FOR dmls_done'; |
| 289 |
ALTER TABLE t1 ROW_FORMAT = REDUNDANT; |
| 290 |
SET DEBUG_SYNC = 'now WAIT_FOR altered'; |
| 291 |
INSERT INTO t1(a, d, b, c) VALUES(201, 300, '3.1415926535', 'hello world'); |
| 292 |
UPDATE t1 SET b = '6.1516179' WHERE a = 200; |
| 293 |
SET DEBUG_SYNC = 'now SIGNAL dmls_done'; |
| 294 |
SET DEBUG_SYNC = 'reset'; |
| 295 |
CHECK TABLE t1; |
| 296 |
Table Op Msg_type Msg_text |
| 297 |
test.t1 check status OK |
| 298 |
SELECT * FROM t1; |
| 299 |
a d b c vbcol vbidxcol |
| 300 |
200 300 6.1516179 hello world .1 6.1 |
| 301 |
201 300 3.1415926535 hello world .1 3.1 |
| 302 |
DROP TABLE t1; |
| 303 |
CREATE TABLE t1(a INT NOT NULL, d INT NOT NULL, b VARCHAR(198) NOT NULL, c CHAR(84), vbcol CHAR(2) AS (substr(b, 2, 2)) VIRTUAL, vbidxcol CHAR(3) AS (substr(b, 1, 3)) VIRTUAL, INDEX(vbidxcol ASC)) ROW_FORMAT = REDUNDANT; |
| 304 |
INSERT INTO t1(a, d, b, c) VALUES(200, 300, '1.3.1415926535', 'hello world'); |
| 305 |
SET DEBUG_SYNC = 'row_log_table_apply1_before SIGNAL altered WAIT_FOR dmls_done'; |
| 306 |
ALTER TABLE t1 ROW_FORMAT = DYNAMIC; |
| 307 |
SET DEBUG_SYNC = 'now WAIT_FOR altered'; |
| 308 |
INSERT INTO t1(a, d, b, c) VALUES(201, 300, '3.1415926535', 'hello world'); |
| 309 |
UPDATE t1 SET b = '6.1516179' WHERE a = 200; |
| 310 |
SET DEBUG_SYNC = 'now SIGNAL dmls_done'; |
| 311 |
SET DEBUG_SYNC = 'reset'; |
| 312 |
CHECK TABLE t1; |
| 313 |
Table Op Msg_type Msg_text |
| 314 |
test.t1 check status OK |
| 315 |
SELECT * FROM t1; |
| 316 |
a d b c vbcol vbidxcol |
| 317 |
200 300 6.1516179 hello world .1 6.1 |
| 318 |
201 300 3.1415926535 hello world .1 3.1 |
| 319 |
DROP TABLE t1; |
| 320 |
# |
| 321 |
# BUG#28448853 - ASSERTION FAILURE: ROW0LOG.CC:2153 ROW_LOG_TABLE_APPLY (THR=0X7F7C7C050030 |
| 322 |
# |
| 323 |
CREATE TABLE t1(a INT NOT NULL, d INT NOT NULL, b VARCHAR(198) NOT NULL, c CHAR(84), vbcol CHAR(2) AS (substr(b, 2, 2)) VIRTUAL); |
| 324 |
INSERT INTO t1(a, d, b, c) VALUES(200, 300, '1.3.1415926535', 'hello world'); |
| 325 |
SELECT * FROM t1; |
| 326 |
a d b c vbcol |
| 327 |
200 300 1.3.1415926535 hello world .3 |
| 328 |
SET DEBUG_SYNC = 'inplace_after_index_build SIGNAL altered WAIT_FOR dmls_done'; |
| 329 |
ALTER TABLE t1 ROW_FORMAT = COMPRESSED;; |
| 330 |
SET DEBUG_SYNC = 'now WAIT_FOR altered'; |
| 331 |
START TRANSACTION; |
| 332 |
UPDATE t1 SET b = '6.1516179' WHERE a = 200; |
| 333 |
ROLLBACK; |
| 334 |
SET DEBUG_SYNC = 'now SIGNAL dmls_done'; |
| 335 |
SET DEBUG_SYNC = 'reset'; |
| 336 |
CHECK TABLE t1; |
| 337 |
Table Op Msg_type Msg_text |
| 338 |
test.t1 check status OK |
| 339 |
SHOW CREATE TABLE t1; |
| 340 |
Table Create Table |
| 341 |
t1 CREATE TABLE `t1` ( |
| 342 |
`a` int NOT NULL, |
| 343 |
`d` int NOT NULL, |
| 344 |
`b` varchar(198) NOT NULL, |
| 345 |
`c` char(84) DEFAULT NULL, |
| 346 |
`vbcol` char(2) GENERATED ALWAYS AS (substr(`b`,2,2)) VIRTUAL |
| 347 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=COMPRESSED |
| 348 |
SELECT * FROM t1; |
| 349 |
a d b c vbcol |
| 350 |
200 300 1.3.1415926535 hello world .3 |
| 351 |
DROP TABLE t1; |
| 352 |
# |
| 353 |
# Bug#28825718 - ASSERTION FAILURE: TRX0REC.CC:NNN:N_IDX > 0 WHILE DOING REPLACE/INSERT |
| 354 |
# |
| 355 |
CREATE TABLE t1(a INT PRIMARY KEY, b INT, c INT GENERATED ALWAYS AS(b+1) VIRTUAL) ENGINE=InnoDB; |
| 356 |
INSERT INTO t1(a, b) VALUES(1, 1); |
| 357 |
SET DEBUG_SYNC = 'row_log_apply_after SIGNAL s1 WAIT_FOR s2'; |
| 358 |
SET lock_wait_timeout = 1; |
| 359 |
ALTER TABLE t1 ADD UNIQUE INDEX(c, b); |
| 360 |
SET DEBUG_SYNC = 'now WAIT_FOR s1'; |
| 361 |
SET DEBUG_SYNC = 'row_ins_sec_index_enter SIGNAL s2 WAIT_FOR s3'; |
| 362 |
INSERT INTO t1(a, b) VALUES(2, 2); |
| 363 |
/* con1 reap */ ALTER TABLE t1 ADD UNIQUE INDEX(c, b); |
| 364 |
ERROR HY000: Lock wait timeout exceeded; try restarting transaction |
| 365 |
SET DEBUG_SYNC ='now SIGNAL s3'; |
| 366 |
ALTER TABLE t1 ADD KEY(b); |
| 367 |
INSERT INTO t1(a, b) VALUES(3, 3); |
| 368 |
SELECT * FROM t1; |
| 369 |
a b c |
| 370 |
1 1 2 |
| 371 |
2 2 3 |
| 372 |
3 3 4 |
| 373 |
CHECK TABLE t1; |
| 374 |
Table Op Msg_type Msg_text |
| 375 |
test.t1 check status OK |
| 376 |
DROP TABLE t1; |
| 377 |
# |
| 378 |
# Bug#28834208 ROW_LOG_TABLE_APPLY_UPDATE*INPLACE_ALTER_TABLE |
| 379 |
# |
| 380 |
CREATE TABLE t1 ( |
| 381 |
pkey INT(11) PRIMARY KEY, |
| 382 |
a VARCHAR(100), |
| 383 |
v VARCHAR(100) GENERATED ALWAYS AS (SUBSTRING(a,2,2)) VIRTUAL, |
| 384 |
c varchar(100), |
| 385 |
UNIQUE KEY k (v) |
| 386 |
); |
| 387 |
Warnings: |
| 388 |
Warning 1681 Integer display width is deprecated and will be removed in a future release. |
| 389 |
INSERT INTO t1 ( pkey,a,c) VALUES (149,'bata','test'); |
| 390 |
SELECT pkey,a,v FROM t1; |
| 391 |
pkey a v |
| 392 |
149 bata at |
| 393 |
SET DEBUG_SYNC = 'row_log_table_apply1_before SIGNAL index_built WAIT_FOR S2'; |
| 394 |
OPTIMIZE TABLE t1; |
| 395 |
# Connect to con1 |
| 396 |
SET DEBUG_SYNC = 'now WAIT_FOR index_built'; |
| 397 |
UPDATE t1 SET a='tata' WHERE pkey=149; |
| 398 |
SET DEBUG_SYNC ='now signal S2'; |
| 399 |
SELECT pkey,a,v FROM t1; |
| 400 |
pkey a v |
| 401 |
149 tata at |
| 402 |
# Connect to Default |
| 403 |
Table Op Msg_type Msg_text |
| 404 |
test.t1 optimize note Table does not support optimize, doing recreate + analyze instead |
| 405 |
test.t1 optimize status OK |
| 406 |
SELECT * FROM t1; |
| 407 |
pkey a v c |
| 408 |
149 tata at test |
| 409 |
DROP TABLE t1; |
| 410 |
CREATE TABLE t1 ( |
| 411 |
pkey INT(11) PRIMARY KEY, |
| 412 |
a VARCHAR(100), |
| 413 |
v VARCHAR(100) GENERATED ALWAYS AS (SUBSTRING(a,2,2)) VIRTUAL, |
| 414 |
c varchar(100), |
| 415 |
v1 VARCHAR(100) GENERATED ALWAYS AS (SUBSTRING(c,2,2)) VIRTUAL, |
| 416 |
KEY k (v), |
| 417 |
KEY v (v1) |
| 418 |
); |
| 419 |
Warnings: |
| 420 |
Warning 1681 Integer display width is deprecated and will be removed in a future release. |
| 421 |
INSERT INTO t1 (pkey, a, c) VALUES (149, 'bata', 'test'); |
| 422 |
INSERT INTO t1 (pkey, a, c) VALUES (150, 'bata', 'test'); |
| 423 |
INSERT INTO t1 (pkey, a, c) VALUES (160, 'bata', 'test'); |
| 424 |
SELECT pkey, a, v, c, v1 FROM t1; |
| 425 |
pkey a v c v1 |
| 426 |
149 bata at test es |
| 427 |
150 bata at test es |
| 428 |
160 bata at test es |
| 429 |
SET DEBUG_SYNC = 'row_log_table_apply1_before SIGNAL index_built WAIT_FOR S2'; |
| 430 |
OPTIMIZE TABLE t1; |
| 431 |
# Connect to con1 |
| 432 |
SET DEBUG_SYNC = 'now WAIT_FOR index_built'; |
| 433 |
UPDATE t1 SET c = 'best' WHERE pkey = 149; |
| 434 |
UPDATE t1 SET a = 'tata' WHERE pkey = 150; |
| 435 |
UPDATE t1 SET a = 'tata', c = 'best' WHERE pkey = 160; |
| 436 |
SET DEBUG_SYNC ='now signal S2'; |
| 437 |
SELECT pkey, a, v, c, v1 FROM t1; |
| 438 |
pkey a v c v1 |
| 439 |
149 bata at best es |
| 440 |
150 tata at test es |
| 441 |
160 tata at best es |
| 442 |
# Connect to Default |
| 443 |
Table Op Msg_type Msg_text |
| 444 |
test.t1 optimize note Table does not support optimize, doing recreate + analyze instead |
| 445 |
test.t1 optimize status OK |
| 446 |
SELECT * FROM t1; |
| 447 |
pkey a v c v1 |
| 448 |
149 bata at best es |
| 449 |
150 tata at test es |
| 450 |
160 tata at best es |
| 451 |
DROP TABLE t1; |
| 452 |
CREATE TABLE t1( |
| 453 |
j SERIAL PRIMARY KEY, |
| 454 |
a VARCHAR(36), |
| 455 |
isa BOOLEAN, |
| 456 |
ab VARCHAR(36) AS (IF(`isa`,`a`,NULL )), |
| 457 |
KEY k(ab) |
| 458 |
); |
| 459 |
INSERT INTO t1 (a, isa) VALUES ('test', 1); |
| 460 |
SET DEBUG_SYNC = 'row_log_table_apply1_before SIGNAL index_built WAIT_FOR S2'; |
| 461 |
OPTIMIZE TABLE t1; |
| 462 |
# Connect to con1 |
| 463 |
SET DEBUG_SYNC = 'now WAIT_FOR index_built'; |
| 464 |
UPDATE t1 SET isa=0 ; |
| 465 |
SET DEBUG_SYNC ='now signal S2'; |
| 466 |
SELECT j,a,isa,ab FROM t1; |
| 467 |
j a isa ab |
| 468 |
1 test 0 NULL |
| 469 |
# Connect to Default |
| 470 |
Table Op Msg_type Msg_text |
| 471 |
test.t1 optimize note Table does not support optimize, doing recreate + analyze instead |
| 472 |
test.t1 optimize status OK |
| 473 |
SELECT j,a,isa,ab FROM t1; |
| 474 |
j a isa ab |
| 475 |
1 test 0 NULL |
| 476 |
UPDATE t1 SET isa = 1 WHERE a = 'test' AND isa = 0; |
| 477 |
SELECT j,a,isa,ab FROM t1; |
| 478 |
j a isa ab |
| 479 |
1 test 1 test |
| 480 |
DROP TABLE t1; |
| 481 |
CREATE TABLE t1(a INT); |
| 482 |
INSERT INTO t1 VALUES(1), (1); |
| 483 |
set session debug = '+d, force_virtual_col_build_fail'; |
| 484 |
SET DEBUG_SYNC='innodb_commit_inplace_alter_table_enter SIGNAL rolling_back WAIT_FOR drop_created'; |
| 485 |
ALTER TABLE t1 ADD COLUMN (h INT GENERATED ALWAYS AS(a+1) VIRTUAL), ADD INDEX idx(h), ALGORITHM=INPLACE;; |
| 486 |
SET DEBUG_SYNC='now WAIT_FOR rolling_back'; |
| 487 |
SET DEBUG_SYNC='row_search_for_mysql_before_return SIGNAL scanning WAIT_FOR continue_scan'; |
| 488 |
SELECT * FROM t1;; |
| 489 |
SET DEBUG_SYNC='now WAIT_FOR scanning'; |
| 490 |
SET DEBUG_SYNC='now SIGNAL drop_created'; |
| 491 |
ERROR HY000: Got error 111 - 'InnoDB error' from storage engine |
| 492 |
SET DEBUG_SYNC='now SIGNAL continue_scan'; |
| 493 |
a |
| 494 |
1 |
| 495 |
1 |
| 496 |
set session debug = '-d, force_virtual_col_build_fail'; |
| 497 |
INSERT INTO t1 VALUES(1); |
| 498 |
CHECK TABLE t1; |
| 499 |
Table Op Msg_type Msg_text |
| 500 |
test.t1 check status OK |
| 501 |
DROP TABLE t1; |
| 502 |
# |
| 503 |
# Bug 31279528 - CRASH IN MYSQL SERVER, ASSERTION FAILURE: DICT0DICT.CC |
| 504 |
# |
| 505 |
CREATE TABLE t1 (c1 INT); |
| 506 |
CREATE INDEX idx ON t1 ( ( c1 = 127 ) , ( c1 + c1 ) , c1 , ( c1 + - -1 ) , (c1 > 26 ) ) ; |
| 507 |
SHOW WARNINGS; |
| 508 |
Level Code Message |
| 509 |
SHOW CREATE TABLE t1; |
| 510 |
Table Create Table |
| 511 |
t1 CREATE TABLE `t1` ( |
| 512 |
`c1` int DEFAULT NULL, |
| 513 |
KEY `idx` (((`c1` = 127)),((`c1` + `c1`)),`c1`,((`c1` + -(-(1)))),((`c1` > 26))) |
| 514 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci |
| 515 |
SET SESSION debug= '+d,skip_dd_table_access_check'; |
| 516 |
SELECT ID INTO @tid FROM mysql.tables WHERE NAME='t1'; |
| 517 |
SELECT NAME, ORDINAL_POSITION, TYPE, HIDDEN, GENERATION_EXPRESSION_UTF8 FROM mysql.columns WHERE TABLE_ID=@tid ORDER BY ORDINAL_POSITION; |
| 518 |
NAME ORDINAL_POSITION TYPE HIDDEN GENERATION_EXPRESSION_UTF8 |
| 519 |
c1 1 MYSQL_TYPE_LONG Visible NULL |
| 520 |
!hidden!idx!0!0 2 MYSQL_TYPE_LONG SQL (`c1` = 127) |
| 521 |
!hidden!idx!1!0 3 MYSQL_TYPE_LONGLONG SQL (`c1` + `c1`) |
| 522 |
!hidden!idx!3!0 4 MYSQL_TYPE_NEWDECIMAL SQL (`c1` + -(-(1))) |
| 523 |
!hidden!idx!4!0 5 MYSQL_TYPE_LONG SQL (`c1` > 26) |
| 524 |
DB_ROW_ID 6 MYSQL_TYPE_INT24 SE NULL |
| 525 |
DB_TRX_ID 7 MYSQL_TYPE_INT24 SE NULL |
| 526 |
DB_ROLL_PTR 8 MYSQL_TYPE_LONGLONG SE NULL |
| 527 |
DROP TABLE t1; |
| 528 |
# |
| 529 |
# Bug #30556595 FAILING ASSERTION: !CURSOR->INDEX->IS_COMMITTED() |
| 530 |
# ON TABLE WITH GCOLS |
| 531 |
# |
| 532 |
# Set binlog_row_image = MINIMAL. |
| 533 |
SET @old_binlog_row_image = @@binlog_row_image; |
| 534 |
SET @@session.binlog_row_image = 'MINIMAL'; |
| 535 |
# Testcase-1 |
| 536 |
CREATE TABLE t (pid int PRIMARY KEY, |
| 537 |
uid int, |
| 538 |
vid int AS (uid) VIRTUAL); |
| 539 |
# Create index on virtual column and stop before applying row logs. |
| 540 |
SET DEBUG_SYNC = 'row_log_apply_before SIGNAL start_dml WAIT_FOR resume_ddl'; |
| 541 |
ALTER TABLE t ADD INDEX idx_vid(vid), algorithm=inplace; |
| 542 |
SET DEBUG_SYNC= 'now WAIT_FOR start_dml'; |
| 543 |
# Insert a record to generate an insert row log for the new index. |
| 544 |
# LOG-1 idx_vid : INSERT [10, 1] |
| 545 |
INSERT INTO t(pid, uid) VALUES (1,10); |
| 546 |
# Update the record changing PK. It should generate 2 row logs for the new index. |
| 547 |
# LOG-2 idx_vid : DELETE [10, 1] |
| 548 |
# LOG-3 idx_vid : INSERT [10, 2] |
| 549 |
UPDATE t SET pid = 2 WHERE pid = 1; |
| 550 |
SELECT * FROM t; |
| 551 |
pid uid vid |
| 552 |
2 10 10 |
| 553 |
SET DEBUG_SYNC= 'now SIGNAL resume_ddl'; |
| 554 |
# Insert a record to re-use the delete marked record in idx_vid [10, 1] |
| 555 |
INSERT INTO t(pid, uid) VALUES (1,10); |
| 556 |
SELECT * FROM t; |
| 557 |
pid uid vid |
| 558 |
1 10 10 |
| 559 |
2 10 10 |
| 560 |
DROP TABLE t; |
| 561 |
# Testcase-2 |
| 562 |
CREATE TABLE t (pid int PRIMARY KEY, |
| 563 |
uid int, |
| 564 |
vid int AS (uid) VIRTUAL); |
| 565 |
# Create index on virtual column and stop before applying row logs. |
| 566 |
SET DEBUG_SYNC = 'row_log_apply_before SIGNAL start_dml WAIT_FOR resume_ddl'; |
| 567 |
ALTER TABLE t ADD INDEX idx_vid(vid), algorithm=inplace; |
| 568 |
SET DEBUG_SYNC= 'now WAIT_FOR start_dml'; |
| 569 |
# Start transaction |
| 570 |
BEGIN; |
| 571 |
# Insert a record to generate an insert row log for the new index. |
| 572 |
# LOG-1 idx_vid : INSERT [10, 1] |
| 573 |
INSERT INTO t(pid, uid) VALUES (1,10); |
| 574 |
# Update the record changing PK. It should generate 2 row logs for the new index. |
| 575 |
# LOG-2 idx_vid : DELETE [10, 1] |
| 576 |
# LOG-3 idx_vid : INSERT [10, 2] |
| 577 |
UPDATE t SET pid = 2 WHERE pid = 1; |
| 578 |
SELECT * FROM t; |
| 579 |
pid uid vid |
| 580 |
2 10 10 |
| 581 |
# Rollback transaction |
| 582 |
# LOG-4 idx_vid : DELETE [10, 2] |
| 583 |
# LOG-5 idx_vid : INSERT [10, 1] |
| 584 |
# LOG-6 idx_vid : DELETE [10, 1] |
| 585 |
ROLLBACK; |
| 586 |
SET DEBUG_SYNC= 'now SIGNAL resume_ddl'; |
| 587 |
# Insert a record to check valid entry in idx_vid [NULL, 1] |
| 588 |
INSERT INTO t(pid) VALUES (1); |
| 589 |
SELECT * FROM t; |
| 590 |
pid uid vid |
| 591 |
1 NULL NULL |
| 592 |
DROP TABLE t; |
| 593 |
# Testcase-3 |
| 594 |
CREATE TABLE t (pid int PRIMARY KEY, |
| 595 |
uid int, |
| 596 |
vid int AS (uid) VIRTUAL); |
| 597 |
INSERT INTO t(pid, uid) VALUES (1,10); |
| 598 |
# Create index on virtual column and stop before applying row logs. |
| 599 |
SET DEBUG_SYNC = 'row_log_apply_before SIGNAL start_dml WAIT_FOR resume_ddl'; |
| 600 |
ALTER TABLE t ADD INDEX idx_vid(vid), algorithm=inplace; |
| 601 |
SET DEBUG_SYNC= 'now WAIT_FOR start_dml'; |
| 602 |
# Update the record changing PK. It should generate 2 row logs for the new index. |
| 603 |
# LOG-2 idx_vid : DELETE [10, 1] |
| 604 |
# LOG-3 idx_vid : INSERT [10, 2] |
| 605 |
UPDATE t SET pid = 2 WHERE pid = 1; |
| 606 |
SET DEBUG_SYNC= 'now SIGNAL resume_ddl'; |
| 607 |
# Read [2, 10, 10] row using idx_vid index key. |
| 608 |
select * from t where VID=10; |
| 609 |
pid uid vid |
| 610 |
2 10 10 |
| 611 |
DROP TABLE t; |
| 612 |
# Testcase-4 |
| 613 |
CREATE TABLE t (pid int PRIMARY KEY, |
| 614 |
uid int, |
| 615 |
vid int AS (uid) VIRTUAL); |
| 616 |
INSERT INTO t(pid, uid) VALUES (1,10); |
| 617 |
# Create index on virtual column and stop before applying row logs. |
| 618 |
SET DEBUG_SYNC = 'row_log_apply_before SIGNAL start_dml WAIT_FOR resume_ddl'; |
| 619 |
ALTER TABLE t ADD INDEX idx_vid(vid), algorithm=inplace; |
| 620 |
SET DEBUG_SYNC= 'now WAIT_FOR start_dml'; |
| 621 |
# Update the record changing PK. It should generate 2 row logs for the new index. |
| 622 |
# LOG-2 idx_vid : DELETE [10, 1] |
| 623 |
# LOG-3 idx_vid : INSERT [10, 2] |
| 624 |
UPDATE t SET pid = 2 WHERE pid = 1; |
| 625 |
SET DEBUG_SYNC= 'now SIGNAL resume_ddl'; |
| 626 |
# Delete a record. |
| 627 |
delete from t limit 1; |
| 628 |
DROP TABLE t; |
| 629 |
SET @@session.binlog_row_image = @old_binlog_row_image; |