Debian Codegraph @

mysql-test/suite/binlog/r/binlog_multi_valued_index.result

raw
1 include/save_binlog_position.inc
2 CREATE TABLE t1 (id INT, c INT, j JSON NOT NULL,
3 UNIQUE INDEX i1((CAST(CAST(j AS JSON) AS UNSIGNED ARRAY))));
4 SET @@session.binlog_row_image = MINIMAL;
5 INSERT INTO t1 VALUES (1, 1, '[1,2,3,4]'), (2, 2, '[5,6,7,8]');
6 UPDATE t1 SET j = '[9,0]' WHERE JSON_CONTAINS(CAST(j AS JSON),'2');
7 SET @@session.binlog_row_image = FULL;
8 INSERT INTO t1 VALUES (10, 10, '[10,20,30,40]'), (20, 20, '[50,60,70,80]');
9 UPDATE t1 SET j = '[11,12,13,14]' WHERE JSON_CONTAINS(CAST(j AS JSON),'10');
10 SET @@session.binlog_row_image = NOBLOB;
11 INSERT INTO t1 VALUES (100, 100, '[100,200,300,400]'),
12 (200, 200, '[500,600,700,800]');
13 UPDATE t1 SET j = '[101,201,301,401]' WHERE JSON_CONTAINS(CAST(j AS JSON),'200');
14 DROP TABLE t1;
15 FLUSH LOGS;
16 include/mysqlbinlog.inc
17 ### INSERT INTO `test`.`t1`
18 ### SET
19 ### @1=1
20 ### @2=1
21 ### @3='[1, 2, 3, 4]'
22 ### INSERT INTO `test`.`t1`
23 ### SET
24 ### @1=2
25 ### @2=2
26 ### @3='[5, 6, 7, 8]'
27 ### UPDATE `test`.`t1`
28 ### WHERE
29 ### @1=1
30 ### @2=1
31 ### @3='[1, 2, 3, 4]'
32 ### SET
33 ### @3='[9, 0]'
34 ### INSERT INTO `test`.`t1`
35 ### SET
36 ### @1=10
37 ### @2=10
38 ### @3='[10, 20, 30, 40]'
39 ### INSERT INTO `test`.`t1`
40 ### SET
41 ### @1=20
42 ### @2=20
43 ### @3='[50, 60, 70, 80]'
44 ### UPDATE `test`.`t1`
45 ### WHERE
46 ### @1=10
47 ### @2=10
48 ### @3='[10, 20, 30, 40]'
49 ### SET
50 ### @1=10
51 ### @2=10
52 ### @3='[11, 12, 13, 14]'
53 ### INSERT INTO `test`.`t1`
54 ### SET
55 ### @1=100
56 ### @2=100
57 ### @3='[100, 200, 300, 400]'
58 ### INSERT INTO `test`.`t1`
59 ### SET
60 ### @1=200
61 ### @2=200
62 ### @3='[500, 600, 700, 800]'
63 ### UPDATE `test`.`t1`
64 ### WHERE
65 ### @1=100
66 ### @2=100
67 ### @3='[100, 200, 300, 400]'
68 ### SET
69 ### @1=100
70 ### @2=100
71 ### @3='[101, 201, 301, 401]'
72 include/save_binlog_position.inc
73 # Check that when the only unique NOT NULL index is a functional index,
74 # the binary log contains a full before-image regardless of
75 # binlog_row_image.
76 CREATE TABLE t1 (id INT, c INT, j JSON NOT NULL,
77 UNIQUE INDEX i1((CAST(CAST(j AS JSON) AS UNSIGNED ARRAY))));
78 INSERT INTO t1 VALUES (1, 1, '[1,2,3,4]'), (2, 2, '[5,6,7,8]');
79 SET binlog_row_image = MINIMAL;
80 UPDATE t1 SET j = '[2,9,10]' WHERE JSON_CONTAINS(CAST(j AS JSON),'2');
81 SET binlog_row_image = FULL;
82 UPDATE t1 SET j = '[2,11,12]' WHERE JSON_CONTAINS(CAST(j AS JSON),'2');
83 SET binlog_row_image = NOBLOB;
84 UPDATE t1 SET j = '[2,13,14]' WHERE JSON_CONTAINS(CAST(j AS JSON),'2');
85 DROP TABLE t1;
86 FLUSH LOGS;
87 include/mysqlbinlog.inc
88 ### INSERT INTO `test`.`t1`
89 ### SET
90 ### @1=1
91 ### @2=1
92 ### @3='[1, 2, 3, 4]'
93 ### INSERT INTO `test`.`t1`
94 ### SET
95 ### @1=2
96 ### @2=2
97 ### @3='[5, 6, 7, 8]'
98 ### UPDATE `test`.`t1`
99 ### WHERE
100 ### @1=1
101 ### @2=1
102 ### @3='[1, 2, 3, 4]'
103 ### SET
104 ### @3='[2, 9, 10]'
105 ### UPDATE `test`.`t1`
106 ### WHERE
107 ### @1=1
108 ### @2=1
109 ### @3='[2, 9, 10]'
110 ### SET
111 ### @1=1
112 ### @2=1
113 ### @3='[2, 11, 12]'
114 ### UPDATE `test`.`t1`
115 ### WHERE
116 ### @1=1
117 ### @2=1
118 ### @3='[2, 11, 12]'
119 ### SET
120 ### @1=1
121 ### @2=1
122 ### @3='[2, 13, 14]'