Debian Codegraph @

mysql-test/suite/x/t/flow_compression_resultset_prepexecute_stored_procedures.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 SP execution through X Protocol-prepare-statement
9 ## after decompression (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_stored_procedures.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
54 CALL `recreate_tables_for_sp`();
55
56 exec $MYSQLXTEST
57 -ux_root --password=''
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/prep_stmt_cursor.xpl 2>&1;
63
64
65 --echo
66 --echo ## B. Execute the test using zlib/multiple
67 --echo #
68
69 CALL `recreate_tables_for_sp`();
70
71 exec $MYSQLXTEST
72 -ux_root --password=''
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/prep_stmt_cursor.xpl 2>&1;
78
79
80 --echo
81 --echo ## C. Execute the test using zlib/single
82 --echo #
83
84 CALL `recreate_tables_for_sp`();
85
86 exec $MYSQLXTEST
87 -ux_root --password=''
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/prep_stmt_cursor.xpl 2>&1;
93
94
95 --echo
96 --echo ## D. Execute the test using lz4/group
97 --echo #
98
99 CALL `recreate_tables_for_sp`();
100
101 exec $MYSQLXTEST
102 -ux_root --password=''
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/prep_stmt_cursor.xpl 2>&1;
108
109
110 --echo
111 --echo ## E. Execute the test using lz4/multiple
112 --echo #
113
114 CALL `recreate_tables_for_sp`();
115
116 exec $MYSQLXTEST
117 -ux_root --password=''
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/prep_stmt_cursor.xpl 2>&1;
123
124
125 --echo
126 --echo ## F. Execute the test using lz4/single
127 --echo #
128
129 CALL `recreate_tables_for_sp`();
130
131 exec $MYSQLXTEST
132 -ux_root --password=''
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/prep_stmt_cursor.xpl 2>&1;
138
139
140 --echo
141 --echo ## G. Execute the test using zstd/group
142 --echo #
143
144 CALL `recreate_tables_for_sp`();
145
146 exec $MYSQLXTEST
147 -ux_root --password=''
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/prep_stmt_cursor.xpl 2>&1;
153
154
155 --echo
156 --echo ## H. Execute the test using zstd/multiple
157 --echo #
158
159 CALL `recreate_tables_for_sp`();
160
161 exec $MYSQLXTEST
162 -ux_root --password=''
163 --compression-mode=required
164 --compression-algorithm=zstd_stream
165 --compression-combine-mixed-messages=0
166 --compression-max-combine-messages=0
167 --file=$MYSQL_TMP_DIR/prep_stmt_cursor.xpl 2>&1;
168
169
170 --echo
171 --echo ## I. Execute the test using zstd/single
172 --echo #
173
174 CALL `recreate_tables_for_sp`();
175
176 exec $MYSQLXTEST
177 -ux_root --password=''
178 --compression-mode=required
179 --compression-algorithm=zstd_stream
180 --compression-combine-mixed-messages=0
181 --compression-max-combine-messages=1
182 --file=$MYSQL_TMP_DIR/prep_stmt_cursor.xpl 2>&1;
183
184 ## Cleanup
185 --source ../include/xplugin_cleanup.inc