Debian Codegraph @

mysql-test/suite/innodb/r/blob_cmp_empty.result

raw
1 connect prevent_purge,localhost,root,,;
2 start transaction with consistent snapshot;
3 connection default;
4 SET @fill_amount = (@@innodb_page_size / 2 ) + 1;
5 CREATE TABLE t1 (col_text TEXT NOT NULL, KEY (col_text(9))) ENGINE=InnoDB;
6 INSERT INTO t1 (col_text) VALUES (REPEAT('x', @fill_amount));
7 UPDATE t1 SET col_text='';
8 UPDATE t1 SET col_text=REPEAT('y', @fill_amount);
9 connect con1,localhost,root,,;
10 SET @fill_amount = (@@innodb_page_size / 2 ) + 1;
11 BEGIN;
12 INSERT INTO t1 (col_text) VALUES (REPEAT('z', @fill_amount));
13 connection default;
14 CHECK TABLE t1;
15 Table Op Msg_type Msg_text
16 test.t1 check status OK
17 disconnect con1;
18 disconnect prevent_purge;
19 DROP TABLE t1;