Debian Codegraph @

mysql-test/suite/x/t/compression_client_mixed_caps.test

raw
1 ## Compression done on client side
2 #
3 # client->server: Compress
4 #
5 # Client compresses X protocol messages placing it in single
6 # compression frame and verifies that configuration of:
7 #
8 # * server_combine_mixed_messages
9 # * server_max_combine_messages
10 #
11 # doesn't have any influence on messages send from client.
12 #
13 # The test checks if the server correctly interpreted the compressed
14 # block by looking at its responses
15 #
16 #
17
18 --source include/xplugin_preamble.inc
19 --source include/xplugin_create_user.inc
20
21 ## Test starts here
22 --write_file $MYSQL_TMP_DIR/resultset.xpl
23
24 -->echo
25 -->echo
26 -->echo ## I. Send compression message to the server and verify successful execution
27 -->echo # also show that neither "server_combine_mixed_messages" nor "server_max_combine_messages"
28 -->echo # has influence on client compression messages
29 -->echo #
30 -->echo # 1. Send compression message containing single X Protocol message (StmtExecute)
31 -->echo # 2. Send compression message containing single X Protocol message (Expect.Open)
32 -->echo # 3. Send compression message containing multiple X Protocol message
33 -->echo # of the same type (StmtExecute)
34 -->echo # 4. Send compression message containing multiple X Protocol message
35 -->echo # of the different types (StmtExecute, Expect.Open)
36
37 -->echo
38 -->echo #
39 -->echo # I.1
40 -->begin_compress
41 Mysqlx.Sql.StmtExecute {
42 stmt: "SELECT 1"
43 namespace: "sql"
44 }
45 -->end_compress
46
47 recvresult;
48
49 -->echo
50 -->echo #
51 -->echo # I.2
52 -->begin_compress
53 Mysqlx.Expect.Open {
54 }
55 -->end_compress
56
57 recvok;
58
59 -->echo
60 -->echo #
61 -->echo # I.3
62 -->begin_compress
63 Mysqlx.Sql.StmtExecute {
64 stmt: "SELECT 2"
65 namespace: "sql"
66 }
67
68 Mysqlx.Sql.StmtExecute {
69 stmt: "SELECT 3"
70 namespace: "sql"
71 }
72
73 Mysqlx.Sql.StmtExecute {
74 stmt: "SELECT 4"
75 namespace: "sql"
76 }
77 -->end_compress
78
79 recvresult;
80 recvresult;
81 recvresult;
82
83 -->echo
84 -->echo #
85 -->echo # I.4
86 -->begin_compress
87 Mysqlx.Expect.Open {
88 }
89
90 Mysqlx.Sql.StmtExecute {
91 stmt: "SELECT 5"
92 namespace: "sql"
93 }
94
95 Mysqlx.Sql.StmtExecute {
96 stmt: "ping"
97 namespace: "mysqlx"
98 }
99 -->end_compress
100
101 recvok;
102 recvresult;
103 recvresult;
104
105 EOF
106
107
108 --echo
109 --echo ## A. Execute the test using valid compression: deflate + combine mixed=false
110 --echo #
111 exec $MYSQLXTEST
112 -ux_root --password=''
113 --compression-mode=preferred
114 --compression-algorithm=deflate_stream
115 --compression-combine-mixed-messages=0
116 --file=$MYSQL_TMP_DIR/resultset.xpl 2>&1;
117
118
119 --echo
120 --echo ## B. Execute the test using valid compression: deflate + combine mixed=true
121 --echo #
122 exec $MYSQLXTEST
123 -ux_root --password=''
124 --compression-mode=preferred
125 --compression-algorithm=deflate_stream
126 --compression-combine-mixed-messages=1
127 --file=$MYSQL_TMP_DIR/resultset.xpl 2>&1;
128
129
130 --echo
131 --echo ## C. Execute the test using valid compression: deflate + combine mixed=true + limit-messages=1
132 --echo #
133 exec $MYSQLXTEST
134 -ux_root --password=''
135 --compression-mode=preferred
136 --compression-algorithm=deflate_stream
137 --compression-combine-mixed-messages=1
138 --compression-max-combine-messages=1
139 --file=$MYSQL_TMP_DIR/resultset.xpl 2>&1;
140
141
142 --echo
143 --echo ## D. Execute the test using valid compression: deflate + combine mixed=true + limit-messages=2
144 --echo #
145 exec $MYSQLXTEST
146 -ux_root --password=''
147 --compression-mode=preferred
148 --compression-algorithm=deflate_stream
149 --compression-combine-mixed-messages=1
150 --compression-max-combine-messages=2
151 --file=$MYSQL_TMP_DIR/resultset.xpl 2>&1;
152
153
154 --echo
155 --echo ## E. Execute the test using valid compression: lz4 + combine mixed=false
156 --echo #
157 exec $MYSQLXTEST
158 -ux_root --password=''
159 --compression-mode=preferred
160 --compression-algorithm=lz4_message
161 --compression-combine-mixed-messages=0
162 --file=$MYSQL_TMP_DIR/resultset.xpl 2>&1;
163
164
165 --echo
166 --echo ## F. Execute the test using valid compression: lz4 + combine mixed=true
167 --echo #
168 exec $MYSQLXTEST
169 -ux_root --password=''
170 --compression-mode=preferred
171 --compression-algorithm=lz4_message
172 --compression-combine-mixed-messages=1
173 --file=$MYSQL_TMP_DIR/resultset.xpl 2>&1;
174
175
176 --echo
177 --echo ## G. Execute the test using valid compression: lz4 + combine mixed=true + limit-messages=1
178 --echo #
179 exec $MYSQLXTEST
180 -ux_root --password=''
181 --compression-mode=preferred
182 --compression-algorithm=lz4_message
183 --compression-combine-mixed-messages=1
184 --compression-max-combine-messages=1
185 --file=$MYSQL_TMP_DIR/resultset.xpl 2>&1;
186
187
188 --echo
189 --echo ## H. Execute the test using valid compression: lz4 + combine mixed=true + limit-messages=2
190 --echo #
191 exec $MYSQLXTEST
192 -ux_root --password=''
193 --compression-mode=preferred
194 --compression-algorithm=lz4_message
195 --compression-combine-mixed-messages=1
196 --compression-max-combine-messages=2
197 --file=$MYSQL_TMP_DIR/resultset.xpl 2>&1;
198
199
200 --echo
201 --echo ## I. Execute the test using valid compression: zstd + combine mixed=false
202 --echo #
203 exec $MYSQLXTEST
204 -ux_root --password=''
205 --compression-mode=preferred
206 --compression-algorithm=zstd_stream
207 --compression-combine-mixed-messages=0
208 --file=$MYSQL_TMP_DIR/resultset.xpl 2>&1;
209
210
211 --echo
212 --echo ## J. Execute the test using valid compression: zstd + combine mixed=true
213 --echo #
214 exec $MYSQLXTEST
215 -ux_root --password=''
216 --compression-mode=preferred
217 --compression-algorithm=zstd_stream
218 --compression-combine-mixed-messages=1
219 --file=$MYSQL_TMP_DIR/resultset.xpl 2>&1;
220
221
222 --echo
223 --echo ## K. Execute the test using valid compression: zstd + combine mixed=true + limit-messages=1
224 --echo #
225 exec $MYSQLXTEST
226 -ux_root --password=''
227 --compression-mode=preferred
228 --compression-algorithm=zstd_stream
229 --compression-combine-mixed-messages=1
230 --compression-max-combine-messages=1
231 --file=$MYSQL_TMP_DIR/resultset.xpl 2>&1;
232
233
234 --echo
235 --echo ## L. Execute the test using valid compression: zstd + combine mixed=true + limit-messages=2
236 --echo #
237 exec $MYSQLXTEST
238 -ux_root --password=''
239 --compression-mode=preferred
240 --compression-algorithm=zstd_stream
241 --compression-combine-mixed-messages=1
242 --compression-max-combine-messages=2
243 --file=$MYSQL_TMP_DIR/resultset.xpl 2>&1;
244
245 ## Cleanup
246 --source ../include/xplugin_cleanup.inc