Debian Codegraph @

mysql-test/suite/x/include/compression_level_client_common.inc

raw
1 ## Test to verifies compression level functionality from the client side
2 #
3
4 --write_file $MYSQL_TMP_DIR/compression_level_client.xpl
5 -->import assert_status_variable.macro
6 -->quiet
7 -->title =Verify %OPTION_COMPRESSION_ALGORITHM% at level %OPTION_COMPRESSION_LEVEL%
8
9 -->callmacro Assert_status_variable Mysqlx_compression_level %EXPECT_SERVER_LEVEL%
10
11 -->repeat 32
12 -->begin_compress GROUP
13 Mysqlx.Sql.StmtExecute {
14 stmt: "SELECT 1 /* Example data for testing compression level */"
15 }
16 Mysqlx.Sql.StmtExecute {
17 stmt: "SELECT 2 /* Example data for testing compression level */"
18 }
19 Mysqlx.Sql.StmtExecute {
20 stmt: "SELECT 3 /* Example data for testing compression level */"
21 }
22 Mysqlx.Sql.StmtExecute {
23 stmt: "SELECT 4 /* Example data for testing compression level */"
24 }
25 Mysqlx.Sql.StmtExecute {
26 stmt: "SELECT 5 /* Example data for testing compression level */"
27 }
28 Mysqlx.Sql.StmtExecute {
29 stmt: "SELECT 6 /* Example data for testing compression level */"
30 }
31 Mysqlx.Sql.StmtExecute {
32 stmt: "SELECT 7 /* Example data for testing compression level */"
33 }
34 -->end_compress
35
36 -->recvresult be-quiet
37 -->recvresult be-quiet
38 -->recvresult be-quiet
39 -->recvresult be-quiet
40 -->recvresult be-quiet
41 -->recvresult be-quiet
42 -->recvresult be-quiet
43 -->endrepeat
44
45 -->stmtsql SHOW STATUS LIKE 'Mysqlx_bytes_received_uncompressed_frame'
46 -->recvtovar %UNCOMPRESSED_BYTES% Value
47 -->stmtsql SHOW STATUS LIKE 'Mysqlx_bytes_received_compressed_payload'
48 -->recvtovar %COMPRESSED_BYTES% Value
49 -->echo Verify [Status variable "Mysqlx_bytes_received_compressed_payload" needs to be lower than "Mysqlx_bytes_received_uncompressed_frame"]
50 -->assert_gt %UNCOMPRESSED_BYTES% %COMPRESSED_BYTES%
51
52 EOF
53
54 CREATE SCHEMA xtest;
55 CREATE TABLE xtest.data(val VARCHAR(256));
56
57 SET GLOBAL mysqlx_compression_algorithms='DEFLATE_STREAM,LZ4_MESSAGE,ZSTD_STREAM';
58