Debian Codegraph @

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