Debian Codegraph @

mysql-test/suite/innodb/r/undo-order.result

raw
1 SET GLOBAL innodb_fast_shutdown=0;
2 # restart: --debug=d,innodb_purge_sleep_12
3 CREATE TABLE t1 (f1 INT PRIMARY KEY, f2 JSON);
4 SET @data_1 = REPEAT('Ax', 16384);
5 SET @data_2 = REPEAT('By', 16384);
6 SET @data_3 = REPEAT('Cz', 16384);
7 SET @data_4 = REPEAT('Pn', 16384);
8 SET @json_doc_1 = CONCAT('["', @data_1, '", "', @data_2, '", "', @data_3, '", "', @data_4, '"]');
9 INSERT INTO t1 (f1, f2) VALUES (1, @json_doc_1);
10 start transaction;
11 SELECT f1 FROM t1;
12 f1
13 1
14 SET @e1 = REPEAT('Do', 16384);
15 SET @e2 = REPEAT('Em', 16384);
16 SET @e3 = REPEAT('Fi', 16384);
17 SET @e4 = REPEAT('Gj', 16384);
18 SET @json_doc_2 = CONCAT('["', @e1, '", "', @e2, '", "', @e3, '", "', @e4, '"]');
19 UPDATE t1 SET f2 = @json_doc2;
20 SET @e4 = REPEAT('Hu', 16384);
21 SET @elem4 = CONCAT('"', @e4, '"');
22 UPDATE t1 SET f2 = JSON_SET(f2, '$[3]', @elem4) WHERE f1 = 1;
23 DELETE FROM t1;
24 commit;
25 DROP TABLE t1;
26 # restart: