Debian Codegraph @

mysql-test/suite/innodb/t/undo-order.test

raw
1 --source include/count_sessions.inc
2 --source include/have_debug.inc
3
4 SET GLOBAL innodb_fast_shutdown=0;
5 let $restart_parameters = restart: --debug=d,innodb_purge_sleep_12;
6 --source include/restart_mysqld.inc
7
8 CREATE TABLE t1 (f1 INT PRIMARY KEY, f2 JSON);
9 SET @data_1 = REPEAT('Ax', 16384);
10 SET @data_2 = REPEAT('By', 16384);
11 SET @data_3 = REPEAT('Cz', 16384);
12 SET @data_4 = REPEAT('Pn', 16384);
13 SET @json_doc_1 = CONCAT('["', @data_1, '", "', @data_2, '", "', @data_3, '", "', @data_4, '"]');
14 INSERT INTO t1 (f1, f2) VALUES (1, @json_doc_1);
15
16 connect (con1,localhost,root,,);
17 connection con1;
18 start transaction;
19 SELECT f1 FROM t1;
20
21 connection default;
22 SET @e1 = REPEAT('Do', 16384);
23 SET @e2 = REPEAT('Em', 16384);
24 SET @e3 = REPEAT('Fi', 16384);
25 SET @e4 = REPEAT('Gj', 16384);
26 SET @json_doc_2 = CONCAT('["', @e1, '", "', @e2, '", "', @e3, '", "', @e4, '"]');
27 UPDATE t1 SET f2 = @json_doc2;
28
29 SET @e4 = REPEAT('Hu', 16384);
30 SET @elem4 = CONCAT('"', @e4, '"');
31 UPDATE t1 SET f2 = JSON_SET(f2, '$[3]', @elem4) WHERE f1 = 1;
32 DELETE FROM t1;
33
34 connection con1;
35 commit;
36 connection default;
37 disconnect con1;
38 --source include/wait_innodb_all_purged.inc
39 --source include/wait_until_count_sessions.inc
40
41 DROP TABLE t1;
42 let $restart_parameters = restart:;
43 --source include/restart_mysqld.inc