Debian Codegraph @

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