| 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 |