Debian Codegraph @

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

raw
1 SET @orig_log_error_verbosity= @@GLOBAL.log_error_verbosity;
2 SET GLOBAL log_error_verbosity=3;
3 set global innodb_compression_level = 0;
4 set debug = '+d,lob_print_partial_update_hit';
5 CREATE TABLE t(j1 JSON);
6 set @data_1 = repeat('abcdefghijklmnopqrstuvwxyz1234', 6006);
7 set @json_doc_1 = concat('["Sven", "', @data_1, '"]');
8 INSERT INTO t VALUES (@json_doc_1);
9 start transaction;
10 # Sven
11 select json_extract(j1, '$[0]') from t;
12 json_extract(j1, '$[0]')
13 "Sven"
14 UPDATE t SET j1 = JSON_SET(j1, '$[0]', 'Knut');
15 # Knut
16 select json_extract(j1, '$[0]') from t;
17 json_extract(j1, '$[0]')
18 "Knut"
19 savepoint a;
20 UPDATE t SET j1 = JSON_SET(j1, '$[0]', 'Anna');
21 # Anna
22 select json_extract(j1, '$[0]') from t;
23 json_extract(j1, '$[0]')
24 "Anna"
25 rollback to a;
26 # Knut
27 select json_extract(j1, '$[0]') from t;
28 json_extract(j1, '$[0]')
29 "Knut"
30 commit;
31 # Knut
32 select json_extract(j1, '$[0]') from t;
33 json_extract(j1, '$[0]')
34 "Knut"
35 Pattern "LOB partial update of field=\(j1\) on index=\(\`GEN_CLUST_INDEX\`\) in table=\(test/t\)" found
36 drop table t;
37 set debug = '-d,lob_print_partial_update_hit';
38 set debug = '+d,zlob_print_partial_update_hit';
39 CREATE TABLE t2(j1 JSON) row_format=compressed;
40 INSERT INTO t2 VALUES (@json_doc_1);
41 start transaction;
42 # Sven
43 select json_extract(j1, '$[0]') from t2;
44 json_extract(j1, '$[0]')
45 "Sven"
46 UPDATE t2 SET j1 = JSON_SET(j1, '$[0]', 'Knut');
47 # Knut
48 select json_extract(j1, '$[0]') from t2;
49 json_extract(j1, '$[0]')
50 "Knut"
51 savepoint a;
52 UPDATE t2 SET j1 = JSON_SET(j1, '$[0]', 'Anna');
53 # Anna
54 select json_extract(j1, '$[0]') from t2;
55 json_extract(j1, '$[0]')
56 "Anna"
57 rollback to a;
58 # Knut
59 select json_extract(j1, '$[0]') from t2;
60 json_extract(j1, '$[0]')
61 "Knut"
62 commit;
63 # Knut
64 select json_extract(j1, '$[0]') from t2;
65 json_extract(j1, '$[0]')
66 "Knut"
67 Pattern "ZLOB partial update of field=\(j1\) on index=\(\`GEN_CLUST_INDEX\`\) in table=\(test/t2\)" found
68 drop table t2;
69 set debug = '-d,zlob_print_partial_update_hit';
70 set global innodb_compression_level = default;
71 SET GLOBAL log_error_verbosity= @orig_log_error_verbosity;