Debian Codegraph @

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

raw
1 set global innodb_compression_level = 0;
2 CREATE TABLE t(j1 JSON) row_format = compressed;
3 SET DEBUG_SYNC = 'innodb_inplace_alter_table_enter SIGNAL start_dml WAIT_FOR alter_continue';
4 ALTER TABLE t row_format = compact;;
5 SET DEBUG_SYNC = 'now WAIT_FOR start_dml';
6 start transaction;
7 # Sven
8 select json_extract(j1, '$[0]') from t;
9 json_extract(j1, '$[0]')
10 "Sven"
11 UPDATE t SET j1 = JSON_SET(j1, '$[0]', 'Knut');
12 # Knut
13 select json_extract(j1, '$[0]') from t;
14 json_extract(j1, '$[0]')
15 "Knut"
16 UPDATE t SET j1 = JSON_SET(j1, '$[0]', 'Anna');
17 # Anna
18 select json_extract(j1, '$[0]') from t;
19 json_extract(j1, '$[0]')
20 "Anna"
21 rollback;
22 SET DEBUG_SYNC = 'now SIGNAL alter_continue';
23 select json_extract(j1, '$[0]') from t;
24 json_extract(j1, '$[0]')
25 "Sven"
26 drop table t;
27 set global innodb_compression_level = default;