Debian Codegraph @

mysql-test/suite/rpl/r/rpl_func_bitwise_ops.result

raw
1 include/master-slave.inc
2 Warnings:
3 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
4 Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
5 [connection master]
6 call mtr.add_suppression("Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT");
7 # Create table with columns of binary data types and insert values
8 CREATE TABLE bitwise_table(id INT PRIMARY KEY NOT NULL AUTO_INCREMENT, vbin1 VARBINARY(32), vbin2 VARBINARY(32));
9 INSERT INTO bitwise_table(vbin1, vbin2) VALUES
10 (x'59', x'6a'),
11 (x'5939', x'6ac3'),
12 (x'5939a998', x'6ac35d2a'),
13 (x'5939a99861154f35', x'6ac35d2a3ab34bda'),
14 (x'5939a99861154f3587d5440618e9b28b', x'6ac35d2a3ab34bda8ac412ea0141852c'),
15 (x'5939a99861154f3587d5440618e9b28b166181c5ca514ab1b8e9c970ae5e421a', x'6ac35d2a3ab34bda8ac412ea0141852c3c8e38bb19934a7092a40bb19db13a80'),
16 (x'5939a99861154f3587d5440618e9b28b', x'8ac412ea0141852c'),
17 (x'5939a99861154f35', x'6ac35d2a3ab34bda8ac412ea0141852c');
18 INSERT INTO bitwise_table(vbin1, vbin2)
19 SELECT (vbin1 & vbin2) , (vbin1 | vbin2) FROM bitwise_table WHERE id <= 6;
20 INSERT INTO bitwise_table(vbin1, vbin2)
21 SELECT (vbin1 ^ vbin2) , ( ~ vbin1 ) FROM bitwise_table WHERE id <= 6;
22 INSERT INTO bitwise_table(vbin1, vbin2)
23 SELECT (vbin1 >> 4 ) , ( vbin2 << 3 ) FROM bitwise_table WHERE id <= 6;
24 INSERT INTO bitwise_table(vbin1, vbin2)
25 SELECT (vbin1 ^ x'6ac3'), (vbin2 & x'5939') FROM bitwise_table WHERE id = 2;
26 INSERT INTO bitwise_table(vbin1, vbin2)
27 SELECT (vbin1 & vbin2) , (vbin1 | vbin2) FROM bitwise_table WHERE id = 7;
28 ERROR HY000: Binary operands of bitwise operators must be of equal length
29 include/sync_slave_sql_with_master.inc
30 [Connection Slave]
31 # check whether table was created and values were inserted on slave
32 SELECT HEX(vbin1), BIT_COUNT(vbin1), HEX(vbin2), BIT_COUNT(vbin2) FROM bitwise_table;
33 HEX(vbin1) BIT_COUNT(vbin1) HEX(vbin2) BIT_COUNT(vbin2)
34 59 4 6A 4
35 5939 8 6AC3 8
36 5939A998 15 6AC35D2A 16
37 5939A99861154F35 30 6AC35D2A3AB34BDA 34
38 5939A99861154F3587D5440618E9B28B 58 6AC35D2A3AB34BDA8AC412EA0141852C 56
39 5939A99861154F3587D5440618E9B28B166181C5CA514AB1B8E9C970AE5E421A 115 6AC35D2A3AB34BDA8AC412EA0141852C3C8E38BB19934A7092A40BB19DB13A80 113
40 5939A99861154F3587D5440618E9B28B 58 8AC412EA0141852C 22
41 5939A99861154F35 30 6AC35D2A3AB34BDA8AC412EA0141852C 56
42 48 2 7B 6
43 4801 3 7BFB 13
44 48010908 6 7BFBFDBA 25
45 4801090820114B10 14 7BFBFDBA7BB74FFF 50
46 4801090820114B1082C4000200418008 24 7BFBFDBA7BB74FFF8FD556EE19E9B7AF 90
47 4801090820114B1082C40002004180081400008108114A3090A009308C100200 49 7BFBFDBA7BB74FFF8FD556EE19E9B7AF3EEFB9FFDBD34AF1BAEDCBF1BFFF7A9A 179
48 33 4 A6 4
49 33FA 10 A6C6 8
50 33FAF4B2 19 A6C65667 17
51 33FAF4B25BA604EF 36 A6C656679EEAB0CA 34
52 33FAF4B25BA604EF0D1156EC19A837A7 66 A6C656679EEAB0CA782ABBF9E7164D74 70
53 33FAF4B25BA604EF0D1156EC19A837A72AEFB97ED3C200C12A4DC2C133EF789A 130 A6C656679EEAB0CA782ABBF9E7164D74E99E7E3A35AEB54E4716368F51A1BDE5 141
54 05 2 50 2
55 0593 6 5618 6
56 05939A99 14 561AE950 14
57 05939A99861154F3 28 561AE951D59A5ED0 32
58 05939A99861154F3587D5440618E9B28 55 561AE951D59A5ED4562097500A0C2960 54
59 05939A99861154F3587D5440618E9B28B166181C5CA514AB1B8E9C970AE5E421 113 561AE951D59A5ED4562097500A0C2961E471C5D8CC9A538495205D8CED89D400 111
60 33FA 10 4801 3
61 SELECT (vbin1 | NULL ), (vbin2 & NULL) FROM bitwise_table;
62 (vbin1 | NULL ) (vbin2 & NULL)
63 NULL NULL
64 NULL NULL
65 NULL NULL
66 NULL NULL
67 NULL NULL
68 NULL NULL
69 NULL NULL
70 NULL NULL
71 NULL NULL
72 NULL NULL
73 NULL NULL
74 NULL NULL
75 NULL NULL
76 NULL NULL
77 NULL NULL
78 NULL NULL
79 NULL NULL
80 NULL NULL
81 NULL NULL
82 NULL NULL
83 NULL NULL
84 NULL NULL
85 NULL NULL
86 NULL NULL
87 NULL NULL
88 NULL NULL
89 NULL NULL
90 SELECT HEX(vbin1), HEX(BIT_AND(vbin1)), HEX(BIT_OR(vbin1)), HEX(BIT_XOR(vbin1)), BIT_COUNT(vbin1) FROM bitwise_table GROUP BY id;
91 HEX(vbin1) HEX(BIT_AND(vbin1)) HEX(BIT_OR(vbin1)) HEX(BIT_XOR(vbin1)) BIT_COUNT(vbin1)
92 59 59 59 59 4
93 5939 5939 5939 5939 8
94 5939A998 5939A998 5939A998 5939A998 15
95 5939A99861154F35 5939A99861154F35 5939A99861154F35 5939A99861154F35 30
96 5939A99861154F3587D5440618E9B28B 5939A99861154F3587D5440618E9B28B 5939A99861154F3587D5440618E9B28B 5939A99861154F3587D5440618E9B28B 58
97 5939A99861154F3587D5440618E9B28B166181C5CA514AB1B8E9C970AE5E421A 5939A99861154F3587D5440618E9B28B166181C5CA514AB1B8E9C970AE5E421A 5939A99861154F3587D5440618E9B28B166181C5CA514AB1B8E9C970AE5E421A 5939A99861154F3587D5440618E9B28B166181C5CA514AB1B8E9C970AE5E421A 115
98 5939A99861154F3587D5440618E9B28B 5939A99861154F3587D5440618E9B28B 5939A99861154F3587D5440618E9B28B 5939A99861154F3587D5440618E9B28B 58
99 5939A99861154F35 5939A99861154F35 5939A99861154F35 5939A99861154F35 30
100 48 48 48 48 2
101 4801 4801 4801 4801 3
102 48010908 48010908 48010908 48010908 6
103 4801090820114B10 4801090820114B10 4801090820114B10 4801090820114B10 14
104 4801090820114B1082C4000200418008 4801090820114B1082C4000200418008 4801090820114B1082C4000200418008 4801090820114B1082C4000200418008 24
105 4801090820114B1082C40002004180081400008108114A3090A009308C100200 4801090820114B1082C40002004180081400008108114A3090A009308C100200 4801090820114B1082C40002004180081400008108114A3090A009308C100200 4801090820114B1082C40002004180081400008108114A3090A009308C100200 49
106 33 33 33 33 4
107 33FA 33FA 33FA 33FA 10
108 33FAF4B2 33FAF4B2 33FAF4B2 33FAF4B2 19
109 33FAF4B25BA604EF 33FAF4B25BA604EF 33FAF4B25BA604EF 33FAF4B25BA604EF 36
110 33FAF4B25BA604EF0D1156EC19A837A7 33FAF4B25BA604EF0D1156EC19A837A7 33FAF4B25BA604EF0D1156EC19A837A7 33FAF4B25BA604EF0D1156EC19A837A7 66
111 33FAF4B25BA604EF0D1156EC19A837A72AEFB97ED3C200C12A4DC2C133EF789A 33FAF4B25BA604EF0D1156EC19A837A72AEFB97ED3C200C12A4DC2C133EF789A 33FAF4B25BA604EF0D1156EC19A837A72AEFB97ED3C200C12A4DC2C133EF789A 33FAF4B25BA604EF0D1156EC19A837A72AEFB97ED3C200C12A4DC2C133EF789A 130
112 05 05 05 05 2
113 0593 0593 0593 0593 6
114 05939A99 05939A99 05939A99 05939A99 14
115 05939A99861154F3 05939A99861154F3 05939A99861154F3 05939A99861154F3 28
116 05939A99861154F3587D5440618E9B28 05939A99861154F3587D5440618E9B28 05939A99861154F3587D5440618E9B28 05939A99861154F3587D5440618E9B28 55
117 05939A99861154F3587D5440618E9B28B166181C5CA514AB1B8E9C970AE5E421 05939A99861154F3587D5440618E9B28B166181C5CA514AB1B8E9C970AE5E421 05939A99861154F3587D5440618E9B28B166181C5CA514AB1B8E9C970AE5E421 05939A99861154F3587D5440618E9B28B166181C5CA514AB1B8E9C970AE5E421 113
118 33FA 33FA 33FA 33FA 10
119 SELECT HEX(vbin2), HEX(BIT_AND(vbin2)), HEX(BIT_OR(vbin2)), HEX(BIT_XOR(vbin2)), BIT_COUNT(vbin2) FROM bitwise_table GROUP BY id;
120 HEX(vbin2) HEX(BIT_AND(vbin2)) HEX(BIT_OR(vbin2)) HEX(BIT_XOR(vbin2)) BIT_COUNT(vbin2)
121 6A 6A 6A 6A 4
122 6AC3 6AC3 6AC3 6AC3 8
123 6AC35D2A 6AC35D2A 6AC35D2A 6AC35D2A 16
124 6AC35D2A3AB34BDA 6AC35D2A3AB34BDA 6AC35D2A3AB34BDA 6AC35D2A3AB34BDA 34
125 6AC35D2A3AB34BDA8AC412EA0141852C 6AC35D2A3AB34BDA8AC412EA0141852C 6AC35D2A3AB34BDA8AC412EA0141852C 6AC35D2A3AB34BDA8AC412EA0141852C 56
126 6AC35D2A3AB34BDA8AC412EA0141852C3C8E38BB19934A7092A40BB19DB13A80 6AC35D2A3AB34BDA8AC412EA0141852C3C8E38BB19934A7092A40BB19DB13A80 6AC35D2A3AB34BDA8AC412EA0141852C3C8E38BB19934A7092A40BB19DB13A80 6AC35D2A3AB34BDA8AC412EA0141852C3C8E38BB19934A7092A40BB19DB13A80 113
127 8AC412EA0141852C 8AC412EA0141852C 8AC412EA0141852C 8AC412EA0141852C 22
128 6AC35D2A3AB34BDA8AC412EA0141852C 6AC35D2A3AB34BDA8AC412EA0141852C 6AC35D2A3AB34BDA8AC412EA0141852C 6AC35D2A3AB34BDA8AC412EA0141852C 56
129 7B 7B 7B 7B 6
130 7BFB 7BFB 7BFB 7BFB 13
131 7BFBFDBA 7BFBFDBA 7BFBFDBA 7BFBFDBA 25
132 7BFBFDBA7BB74FFF 7BFBFDBA7BB74FFF 7BFBFDBA7BB74FFF 7BFBFDBA7BB74FFF 50
133 7BFBFDBA7BB74FFF8FD556EE19E9B7AF 7BFBFDBA7BB74FFF8FD556EE19E9B7AF 7BFBFDBA7BB74FFF8FD556EE19E9B7AF 7BFBFDBA7BB74FFF8FD556EE19E9B7AF 90
134 7BFBFDBA7BB74FFF8FD556EE19E9B7AF3EEFB9FFDBD34AF1BAEDCBF1BFFF7A9A 7BFBFDBA7BB74FFF8FD556EE19E9B7AF3EEFB9FFDBD34AF1BAEDCBF1BFFF7A9A 7BFBFDBA7BB74FFF8FD556EE19E9B7AF3EEFB9FFDBD34AF1BAEDCBF1BFFF7A9A 7BFBFDBA7BB74FFF8FD556EE19E9B7AF3EEFB9FFDBD34AF1BAEDCBF1BFFF7A9A 179
135 A6 A6 A6 A6 4
136 A6C6 A6C6 A6C6 A6C6 8
137 A6C65667 A6C65667 A6C65667 A6C65667 17
138 A6C656679EEAB0CA A6C656679EEAB0CA A6C656679EEAB0CA A6C656679EEAB0CA 34
139 A6C656679EEAB0CA782ABBF9E7164D74 A6C656679EEAB0CA782ABBF9E7164D74 A6C656679EEAB0CA782ABBF9E7164D74 A6C656679EEAB0CA782ABBF9E7164D74 70
140 A6C656679EEAB0CA782ABBF9E7164D74E99E7E3A35AEB54E4716368F51A1BDE5 A6C656679EEAB0CA782ABBF9E7164D74E99E7E3A35AEB54E4716368F51A1BDE5 A6C656679EEAB0CA782ABBF9E7164D74E99E7E3A35AEB54E4716368F51A1BDE5 A6C656679EEAB0CA782ABBF9E7164D74E99E7E3A35AEB54E4716368F51A1BDE5 141
141 50 50 50 50 2
142 5618 5618 5618 5618 6
143 561AE950 561AE950 561AE950 561AE950 14
144 561AE951D59A5ED0 561AE951D59A5ED0 561AE951D59A5ED0 561AE951D59A5ED0 32
145 561AE951D59A5ED4562097500A0C2960 561AE951D59A5ED4562097500A0C2960 561AE951D59A5ED4562097500A0C2960 561AE951D59A5ED4562097500A0C2960 54
146 561AE951D59A5ED4562097500A0C2961E471C5D8CC9A538495205D8CED89D400 561AE951D59A5ED4562097500A0C2961E471C5D8CC9A538495205D8CED89D400 561AE951D59A5ED4562097500A0C2961E471C5D8CC9A538495205D8CED89D400 561AE951D59A5ED4562097500A0C2961E471C5D8CC9A538495205D8CED89D400 111
147 4801 4801 4801 4801 3
148 include/diff_tables.inc [master:bitwise_table, slave:bitwise_table]
149 [Connection Master]
150 # Update rows inside the table
151 UPDATE bitwise_table SET vbin1 = (vbin1 | vbin2) WHERE id <= 6;
152 UPDATE bitwise_table SET vbin2 = (vbin1 & vbin2) WHERE id <= 6;
153 include/sync_slave_sql_with_master.inc
154 [Connection Slave]
155 # Check whether rows are updated
156 SELECT HEX(vbin1), HEX(vbin2) FROM bitwise_table WHERE id <= 6;
157 HEX(vbin1) HEX(vbin2)
158 7B 6A
159 7BFB 6AC3
160 7BFBFDBA 6AC35D2A
161 7BFBFDBA7BB74FFF 6AC35D2A3AB34BDA
162 7BFBFDBA7BB74FFF8FD556EE19E9B7AF 6AC35D2A3AB34BDA8AC412EA0141852C
163 7BFBFDBA7BB74FFF8FD556EE19E9B7AF3EEFB9FFDBD34AF1BAEDCBF1BFFF7A9A 6AC35D2A3AB34BDA8AC412EA0141852C3C8E38BB19934A7092A40BB19DB13A80
164 include/diff_tables.inc [master:bitwise_table, slave:bitwise_table]
165 [Connection Master]
166 UPDATE bitwise_table SET vbin1 = (vbin1 ^ vbin2) WHERE id <= 6;
167 UPDATE bitwise_table SET vbin2 = (~ vbin1) WHERE id <= 6;
168 include/sync_slave_sql_with_master.inc
169 [Connection Slave]
170 # Check whether rows are updated
171 SELECT HEX(vbin1), HEX(vbin2) FROM bitwise_table WHERE id <= 6;
172 HEX(vbin1) HEX(vbin2)
173 11 EE
174 1138 EEC7
175 1138A090 EEC75F6F
176 1138A09041040425 EEC75F6FBEFBFBDA
177 1138A090410404250511440418A83283 EEC75F6FBEFBFBDAFAEEBBFBE757CD7C
178 1138A090410404250511440418A8328302618144C24000812849C040224E401A EEC75F6FBEFBFBDAFAEEBBFBE757CD7CFD9E7EBB3DBFFF7ED7B63FBFDDB1BFE5
179 include/diff_tables.inc [master:bitwise_table, slave:bitwise_table]
180 [Connection Master]
181 # Delete rows from the table
182 DELETE FROM bitwise_table WHERE BIT_COUNT(vbin1) <= 8;
183 include/sync_slave_sql_with_master.inc
184 [Connection Slave]
185 # check whether the rows are deleted
186 SELECT HEX(vbin1), HEX(vbin2) FROM bitwise_table;
187 HEX(vbin1) HEX(vbin2)
188 1138A090 EEC75F6F
189 1138A09041040425 EEC75F6FBEFBFBDA
190 1138A090410404250511440418A83283 EEC75F6FBEFBFBDAFAEEBBFBE757CD7C
191 1138A090410404250511440418A8328302618144C24000812849C040224E401A EEC75F6FBEFBFBDAFAEEBBFBE757CD7CFD9E7EBB3DBFFF7ED7B63FBFDDB1BFE5
192 5939A99861154F3587D5440618E9B28B 8AC412EA0141852C
193 5939A99861154F35 6AC35D2A3AB34BDA8AC412EA0141852C
194 4801090820114B10 7BFBFDBA7BB74FFF
195 4801090820114B1082C4000200418008 7BFBFDBA7BB74FFF8FD556EE19E9B7AF
196 4801090820114B1082C40002004180081400008108114A3090A009308C100200 7BFBFDBA7BB74FFF8FD556EE19E9B7AF3EEFB9FFDBD34AF1BAEDCBF1BFFF7A9A
197 33FA A6C6
198 33FAF4B2 A6C65667
199 33FAF4B25BA604EF A6C656679EEAB0CA
200 33FAF4B25BA604EF0D1156EC19A837A7 A6C656679EEAB0CA782ABBF9E7164D74
201 33FAF4B25BA604EF0D1156EC19A837A72AEFB97ED3C200C12A4DC2C133EF789A A6C656679EEAB0CA782ABBF9E7164D74E99E7E3A35AEB54E4716368F51A1BDE5
202 05939A99 561AE950
203 05939A99861154F3 561AE951D59A5ED0
204 05939A99861154F3587D5440618E9B28 561AE951D59A5ED4562097500A0C2960
205 05939A99861154F3587D5440618E9B28B166181C5CA514AB1B8E9C970AE5E421 561AE951D59A5ED4562097500A0C2961E471C5D8CC9A538495205D8CED89D400
206 33FA 4801
207 include/diff_tables.inc [master:bitwise_table, slave:bitwise_table]
208 [Connection Master]
209 # Drop tables and clean up
210 DROP TABLE bitwise_table;
211 include/sync_slave_sql_with_master.inc
212 [Connection Slave]
213 # Check whether table is dropped
214 SELECT * FROM bitwise_table;
215 ERROR 42S02: Table 'test.bitwise_table' doesn't exist
216 include/rpl_end.inc