Debian Codegraph @

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

raw
1 ##
2 ## There are three levels on which the feature is verified:
3 ##
4 ## * on X Protocol layer (without decompressing)
5 ## * confirming that resultset flow is correct
6 ## * confirming that resultset contains correct data
7 ##
8 ## Test of that verifies X Protocol flow for standard SQL queries (after decompression, bullet no 2)
9
10 ## Preamble
11 --source include/xplugin_preamble.inc
12 --source include/xplugin_create_user.inc
13 ## Test starts here
14
15 --source ../include/test_flow_resultset_stmtexecute_sql.inc
16
17 ##
18 ## Please take a note that this test (and others) use following terms:
19 ## SINGLE, MULTIPLE, GROUP
20 ##
21 ## Those correspond to concrete setting of compression capabilities:
22 ## server_combine_mixed_messages, server_max_combine_messages and
23 ## describe only compressed messages generated by the server.
24 ##
25 ## * SINGLE - it corresponds to
26 ## server_combine_mixed_messages=TRUE|FALSE,
27 ## server_max_combine_messages=1
28 ## In this configuration exact one X Protocol message is
29 ## encapsulated in one Mysqlx.Connection.Compression
30 ##
31 ## * MULTIPLE - it corresponds to
32 ## server_combine_mixed_messages=FALSE,
33 ## server_max_combine_messages=UNSET|0
34 ## In this configuration multiple X Protocol messages
35 ## of the same type are encapsulated in one
36 ## Mysqlx.Connection.Compression
37 ##
38 ## * GROUP - it corresponds to
39 ## server_combine_mixed_messages=TRUE,
40 ## server_max_combine_messages=UNSET|0
41 ## In this configuration multiple X Protocol messages
42 ## of different types are encapsulated in one
43 ## Mysqlx.Connection.Compression
44 ##
45 ## Cases where "server_max_combine_message" has values grater than 1
46 ## are in separate test file: compression_limit_message_count.test
47 ##
48
49 --echo
50 --echo ## A. Execute the test using zlib/group
51 --echo #
52
53 call recreate_tables();
54
55 exec $MYSQLXTEST
56 -ux_root --password=''
57 --schema=xtest
58 --compression-mode=required
59 --compression-algorithm=deflate_stream
60 --compression-combine-mixed-messages=1
61 --compression-max-combine-messages=0
62 --file=$MYSQL_TMP_DIR/resultset.xpl 2>&1;
63
64
65 --echo
66 --echo ## B. Execute the test using zlib/multiple
67 --echo #
68
69 call recreate_tables();
70
71 exec $MYSQLXTEST
72 -ux_root --password=''
73 --schema=xtest
74 --compression-mode=required
75 --compression-algorithm=deflate_stream
76 --compression-combine-mixed-messages=0
77 --compression-max-combine-messages=0
78 --file=$MYSQL_TMP_DIR/resultset.xpl 2>&1;
79
80
81 --echo
82 --echo ## C. Execute the test using zlib/single
83 --echo #
84
85 call recreate_tables();
86
87 exec $MYSQLXTEST
88 -ux_root --password=''
89 --schema=xtest
90 --compression-mode=required
91 --compression-algorithm=deflate_stream
92 --compression-combine-mixed-messages=0
93 --compression-max-combine-messages=1
94 --file=$MYSQL_TMP_DIR/resultset.xpl 2>&1;
95
96
97 --echo
98 --echo ## D. Execute the test using lz4/group
99 --echo #
100
101 call recreate_tables();
102
103 exec $MYSQLXTEST
104 -ux_root --password=''
105 --schema=xtest
106 --compression-mode=required
107 --compression-algorithm=lz4_message
108 --compression-combine-mixed-messages=1
109 --compression-max-combine-messages=0
110 --file=$MYSQL_TMP_DIR/resultset.xpl 2>&1;
111
112
113 --echo
114 --echo ## E. Execute the test using lz4/multiple
115 --echo #
116
117 call recreate_tables();
118
119 exec $MYSQLXTEST
120 -ux_root --password=''
121 --schema=xtest
122 --compression-mode=required
123 --compression-algorithm=lz4_message
124 --compression-combine-mixed-messages=0
125 --compression-max-combine-messages=0
126 --file=$MYSQL_TMP_DIR/resultset.xpl 2>&1;
127
128
129 --echo
130 --echo ## F. Execute the test using lz4/single
131 --echo #
132
133 call recreate_tables();
134
135 exec $MYSQLXTEST
136 -ux_root --password=''
137 --schema=xtest
138 --compression-mode=required
139 --compression-algorithm=lz4_message
140 --compression-combine-mixed-messages=0
141 --compression-max-combine-messages=1
142 --file=$MYSQL_TMP_DIR/resultset.xpl 2>&1;
143
144
145 --echo
146 --echo ## G. Execute the test using zstd/group
147 --echo #
148
149 call recreate_tables();
150
151 exec $MYSQLXTEST
152 -ux_root --password=''
153 --schema=xtest
154 --compression-mode=required
155 --compression-algorithm=zstd_stream
156 --compression-combine-mixed-messages=1
157 --compression-max-combine-messages=0
158 --file=$MYSQL_TMP_DIR/resultset.xpl 2>&1;
159
160
161 --echo
162 --echo ## H. Execute the test using zstd/multiple
163 --echo #
164
165 call recreate_tables();
166
167 exec $MYSQLXTEST
168 -ux_root --password=''
169 --schema=xtest
170 --compression-mode=required
171 --compression-algorithm=zstd_stream
172 --compression-combine-mixed-messages=0
173 --compression-max-combine-messages=0
174 --file=$MYSQL_TMP_DIR/resultset.xpl 2>&1;
175
176
177 --echo
178 --echo ## I. Execute the test using zstd/single
179 --echo #
180
181 call recreate_tables();
182
183 exec $MYSQLXTEST
184 -ux_root --password=''
185 --schema=xtest
186 --compression-mode=required
187 --compression-algorithm=zstd_stream
188 --compression-combine-mixed-messages=0
189 --compression-max-combine-messages=1
190 --file=$MYSQL_TMP_DIR/resultset.xpl 2>&1;
191
192 ## Cleanup
193 --source ../include/xplugin_cleanup.inc