Debian Codegraph @

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

raw
1 set global innodb_compression_level = 0;
2 CREATE TABLE t(j1 JSON) row_format=compressed;
3 set @data_1 = repeat('abcdefghijklmnopqrstuvwxyz1234', 6006);
4 set @json_doc_1 = concat('["Sven", "', @data_1, '"]');
5 set @json_doc_2 = concat('["Glen", "', @data_1, '"]');
6 show create table t;
7 Table Create Table
8 t CREATE TABLE `t` (
9 `j1` json DEFAULT NULL
10 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=COMPRESSED
11 start transaction;
12 # Insert data
13 INSERT INTO t VALUES (@json_doc_1);
14 SET SESSION DEBUG='+d,crash_end_of_lob_rollback_0';
15 rollback;
16 ERROR HY000: Lost connection to MySQL server during query
17 # restart
18 set @data_1 = repeat('abcdefghijklmnopqrstuvwxyz1234', 6006);
19 set @json_doc_1 = concat('["Sven", "', @data_1, '"]');
20 set @json_doc_2 = concat('["Glen", "', @data_1, '"]');
21 select count(*) from t;
22 count(*)
23 0
24 INSERT INTO t VALUES (@json_doc_1);
25 start transaction;
26 # Insert data
27 INSERT INTO t VALUES (@json_doc_2);
28 SET SESSION DEBUG='+d,crash_end_of_lob_rollback_0';
29 rollback;
30 ERROR HY000: Lost connection to MySQL server during query
31 # restart
32 select count(*) from t;
33 count(*)
34 1
35 drop table t;
36 set global innodb_compression_level = default;