Debian Codegraph @

mysql-test/suite/innodb/t/lob_insert_noindex.test

raw
1 --source include/have_debug.inc
2
3 --echo #
4 --echo # WL#8960 Partial Fetch and Update of BLOB
5 --echo #
6
7 CREATE TABLE t1 (f1 int, f2 longblob ) engine=innodb;
8 insert into t1 values (1, repeat('+', 1048576));
9 set debug = '+d,lob_insert_noindex';
10 insert into t1 values (2, repeat('~', 1048576));
11 set debug = '-d,lob_insert_noindex';
12 select f1, right(f2, 40) from t1;
13 drop table t1;
14
15 CREATE TABLE t1 (f1 int, f2 longblob ) engine=innodb;
16 insert into t1 values (1, repeat('+', 1048576));
17 set debug = '+d,lob_insert_noindex';
18 select f1, right(f2, 40) from t1;
19 start transaction;
20 insert into t1 values (2, repeat('~', 1048576));
21 select f1, right(f2, 40) from t1;
22 rollback;
23 set debug = '-d,lob_insert_noindex';
24 select f1, right(f2, 40) from t1;
25 drop table t1;