Debian Codegraph @

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

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