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