Debian Codegraph @

mysql-test/suite/innodb/r/zlob_partial_update_concurrent.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 CREATE TABLE tab82 (col28 JSON) row_format=compressed;
5 set @json_doc_1 = concat('["OpenSource", "', repeat('Linux+Ubuntu+', 16000), '"]');
6 set @json_doc_2 = concat('["OpenSource", "', repeat('MySQL+Oracle+', 16000), '"]');
7 set @data_1 = repeat('Linux+Ubuntu+', 16000);
8 set @data_2 = repeat('MySQL+Oracle+', 16000);
9 INSERT INTO tab82 VALUES (@json_doc_1);
10 # Connection default:
11 # Linux+Ubuntu
12 start transaction with consistent snapshot;
13 select strcmp(col28, @json_doc_1) = 0 from tab82;
14 strcmp(col28, @json_doc_1) = 0
15 1
16 select cast(col28 as char) = @json_doc_1 from tab82;
17 cast(col28 as char) = @json_doc_1
18 1
19 select length(col28) from tab82;
20 length(col28)
21 208018
22 select json_extract(col28, '$[1]') = @data_1 from tab82;
23 json_extract(col28, '$[1]') = @data_1
24 1
25 # Connection con1:
26 set @json_doc_1 = concat('["OpenSource", "', repeat('Linux+Ubuntu+', 16000), '"]');
27 set @json_doc_2 = concat('["OpenSource", "', repeat('MySQL+Oracle+', 16000), '"]');
28 set @data_1 = repeat('Linux+Ubuntu+', 16000);
29 set @data_2 = repeat('MySQL+Oracle+', 16000);
30 set debug = '+d,zlob_print_partial_update_hit';
31 start transaction;
32 UPDATE tab82 SET col28 = JSON_SET(col28, '$[1]', @data_2);
33 # MySQL+Oracle
34 select strcmp(col28, @json_doc_2) = 0 from tab82;
35 strcmp(col28, @json_doc_2) = 0
36 1
37 select cast(col28 as char) = @json_doc_2 from tab82;
38 cast(col28 as char) = @json_doc_2
39 1
40 select length(col28) from tab82;
41 length(col28)
42 208018
43 select json_extract(col28, '$[1]') = @data_2 from tab82;
44 json_extract(col28, '$[1]') = @data_2
45 1
46 # Connection default:
47 # Linux+Ubuntu
48 select strcmp(col28, @json_doc_1) = 0 from tab82;
49 strcmp(col28, @json_doc_1) = 0
50 1
51 select cast(col28 as char) = @json_doc_1 from tab82;
52 cast(col28 as char) = @json_doc_1
53 1
54 select length(col28) from tab82;
55 length(col28)
56 208018
57 select json_extract(col28, '$[1]') = @data_1 from tab82;
58 json_extract(col28, '$[1]') = @data_1
59 1
60 # Connection con1:
61 # MySQL+Oracle
62 select strcmp(col28, @json_doc_2) = 0 from tab82;
63 strcmp(col28, @json_doc_2) = 0
64 1
65 select cast(col28 as char) = @json_doc_2 from tab82;
66 cast(col28 as char) = @json_doc_2
67 1
68 select length(col28) from tab82;
69 length(col28)
70 208018
71 select json_extract(col28, '$[1]') = @data_2 from tab82;
72 json_extract(col28, '$[1]') = @data_2
73 1
74 commit;
75 # Connection default:
76 # Linux+Ubuntu
77 select strcmp(col28, @json_doc_1) = 0 from tab82;
78 strcmp(col28, @json_doc_1) = 0
79 1
80 select cast(col28 as char) = @json_doc_1 from tab82;
81 cast(col28 as char) = @json_doc_1
82 1
83 select length(col28) from tab82;
84 length(col28)
85 208018
86 select json_extract(col28, '$[1]') = @data_1 from tab82;
87 json_extract(col28, '$[1]') = @data_1
88 1
89 commit;
90 # MySQL+Oracle
91 select strcmp(col28, @json_doc_2) = 0 from tab82;
92 strcmp(col28, @json_doc_2) = 0
93 1
94 select cast(col28 as char) = @json_doc_2 from tab82;
95 cast(col28 as char) = @json_doc_2
96 1
97 select length(col28) from tab82;
98 length(col28)
99 208018
100 select json_extract(col28, '$[1]') = @data_2 from tab82;
101 json_extract(col28, '$[1]') = @data_2
102 1
103 Pattern "ZLOB partial update of field=\(col28\) on index=\(\`GEN_CLUST_INDEX\`\) in table=\(test/tab82\)" found
104 drop table tab82;
105 set debug = '-d,zlob_print_partial_update_hit';
106 set global innodb_compression_level = default;
107 SET GLOBAL log_error_verbosity= @orig_log_error_verbosity;