# Test a Mysqlx_compression_algorithms system variable by capabilities --source include/xplugin_preamble.inc --source include/xplugin_create_user.inc --write_file $MYSQL_TMP_DIR/capabilities_compression_algorithm_get.xpl -->import connection.macro -->callmacro Verify_its_xprotocol_connection Mysqlx.Connection.CapabilitiesGet { } -->recv capabilities[4].value.obj.fld[0] EOF --write_file $MYSQL_TMP_DIR/capabilities_compression_algorithm_set.xpl -->import connection.macro -->quiet -->callmacro Verify_its_xprotocol_connection -->echo compression_algorithm = %VALUE% Mysqlx.Connection.CapabilitiesSet { capabilities { capabilities { name: "compression" value { type: OBJECT obj { fld { key: "algorithm" value { type: SCALAR scalar { type: V_STRING v_string { value: "%VALUE%" } } } } } } } } } -->recvtype %RESULT% EOF --echo ############################################## --echo ## Mysqlx_compression_algorithms = default (deflate,lz4,zstd_stream) --echo SET GLOBAL Mysqlx_compression_algorithms = DEFAULT; exec $MYSQLXTEST -u x_root --password='' -h127.0.0.1 --no-auth --file=$MYSQL_TMP_DIR/capabilities_compression_algorithm_get.xpl 2>&1; exec $MYSQLXTEST -u x_root --password='' -h127.0.0.1 --no-auth --file=$MYSQL_TMP_DIR/capabilities_compression_algorithm_set.xpl 2>&1 -v%VALUE%=lz4_message -v%RESULT%=Mysqlx.Ok; exec $MYSQLXTEST -u x_root --password='' -h127.0.0.1 --no-auth --file=$MYSQL_TMP_DIR/capabilities_compression_algorithm_set.xpl 2>&1 -v%VALUE%=deflate_stream -v%RESULT%=Mysqlx.Ok; exec $MYSQLXTEST -u x_root --password='' -h127.0.0.1 --no-auth --file=$MYSQL_TMP_DIR/capabilities_compression_algorithm_set.xpl 2>&1 -v%VALUE%=zstd_stream -v%RESULT%=Mysqlx.Ok; exec $MYSQLXTEST -u x_root --password='' -h127.0.0.1 --no-auth --file=$MYSQL_TMP_DIR/capabilities_compression_algorithm_set.xpl 2>&1 -v%VALUE%=wrong_name -v%RESULT%=Mysqlx.Error; --echo ############################################## --echo ## Mysqlx_compression_algorithms = deflate --echo SET GLOBAL Mysqlx_compression_algorithms = deflate_stream; exec $MYSQLXTEST -u x_root --password='' -h127.0.0.1 --no-auth --file=$MYSQL_TMP_DIR/capabilities_compression_algorithm_get.xpl 2>&1; exec $MYSQLXTEST -u x_root --password='' -h127.0.0.1 --no-auth --file=$MYSQL_TMP_DIR/capabilities_compression_algorithm_set.xpl 2>&1 -v%VALUE%=lz4_message -v%RESULT%=Mysqlx.Error; exec $MYSQLXTEST -u x_root --password='' -h127.0.0.1 --no-auth --file=$MYSQL_TMP_DIR/capabilities_compression_algorithm_set.xpl 2>&1 -v%VALUE%=deflate_stream -v%RESULT%=Mysqlx.Ok; exec $MYSQLXTEST -u x_root --password='' -h127.0.0.1 --no-auth --file=$MYSQL_TMP_DIR/capabilities_compression_algorithm_set.xpl 2>&1 -v%VALUE%=zstd_stream -v%RESULT%=Mysqlx.Error; exec $MYSQLXTEST -u x_root --password='' -h127.0.0.1 --no-auth --file=$MYSQL_TMP_DIR/capabilities_compression_algorithm_set.xpl 2>&1 -v%VALUE%=wrong_name -v%RESULT%=Mysqlx.Error; --echo ############################################## --echo ## Mysqlx_compression_algorithms = lz4 --echo SET GLOBAL Mysqlx_compression_algorithms = lz4_message; exec $MYSQLXTEST -u x_root --password='' -h127.0.0.1 --no-auth --file=$MYSQL_TMP_DIR/capabilities_compression_algorithm_get.xpl 2>&1; exec $MYSQLXTEST -u x_root --password='' -h127.0.0.1 --no-auth --file=$MYSQL_TMP_DIR/capabilities_compression_algorithm_set.xpl 2>&1 -v%VALUE%=lz4_message -v%RESULT%=Mysqlx.Ok; exec $MYSQLXTEST -u x_root --password='' -h127.0.0.1 --no-auth --file=$MYSQL_TMP_DIR/capabilities_compression_algorithm_set.xpl 2>&1 -v%VALUE%=deflate_stream -v%RESULT%=Mysqlx.Error; exec $MYSQLXTEST -u x_root --password='' -h127.0.0.1 --no-auth --file=$MYSQL_TMP_DIR/capabilities_compression_algorithm_set.xpl 2>&1 -v%VALUE%=zstd_stream -v%RESULT%=Mysqlx.Error; exec $MYSQLXTEST -u x_root --password='' -h127.0.0.1 --no-auth --file=$MYSQL_TMP_DIR/capabilities_compression_algorithm_set.xpl 2>&1 -v%VALUE%=wrong_name -v%RESULT%=Mysqlx.Error; --echo ############################################## --echo ## Mysqlx_compression_algorithms = zstd_stream --echo SET GLOBAL Mysqlx_compression_algorithms = zstd_stream; exec $MYSQLXTEST -u x_root --password='' -h127.0.0.1 --no-auth --file=$MYSQL_TMP_DIR/capabilities_compression_algorithm_get.xpl 2>&1; exec $MYSQLXTEST -u x_root --password='' -h127.0.0.1 --no-auth --file=$MYSQL_TMP_DIR/capabilities_compression_algorithm_set.xpl 2>&1 -v%VALUE%=lz4_message -v%RESULT%=Mysqlx.Error; exec $MYSQLXTEST -u x_root --password='' -h127.0.0.1 --no-auth --file=$MYSQL_TMP_DIR/capabilities_compression_algorithm_set.xpl 2>&1 -v%VALUE%=deflate_stream -v%RESULT%=Mysqlx.Error; exec $MYSQLXTEST -u x_root --password='' -h127.0.0.1 --no-auth --file=$MYSQL_TMP_DIR/capabilities_compression_algorithm_set.xpl 2>&1 -v%VALUE%=zstd_stream -v%RESULT%=Mysqlx.Ok; exec $MYSQLXTEST -u x_root --password='' -h127.0.0.1 --no-auth --file=$MYSQL_TMP_DIR/capabilities_compression_algorithm_set.xpl 2>&1 -v%VALUE%=wrong_name -v%RESULT%=Mysqlx.Error; --echo ############################################## --echo ## Mysqlx_compression_algorithms = empty --echo SET GLOBAL Mysqlx_compression_algorithms = ''; exec $MYSQLXTEST -u x_root --password='' -h127.0.0.1 --no-auth --file=$MYSQL_TMP_DIR/capabilities_compression_algorithm_get.xpl 2>&1; exec $MYSQLXTEST -u x_root --password='' -h127.0.0.1 --no-auth --file=$MYSQL_TMP_DIR/capabilities_compression_algorithm_set.xpl 2>&1 -v%VALUE%=lz4_message -v%RESULT%=Mysqlx.Error; exec $MYSQLXTEST -u x_root --password='' -h127.0.0.1 --no-auth --file=$MYSQL_TMP_DIR/capabilities_compression_algorithm_set.xpl 2>&1 -v%VALUE%=deflate_stream -v%RESULT%=Mysqlx.Error; exec $MYSQLXTEST -u x_root --password='' -h127.0.0.1 --no-auth --file=$MYSQL_TMP_DIR/capabilities_compression_algorithm_set.xpl 2>&1 -v%VALUE%=zstd_stream -v%RESULT%=Mysqlx.Error; exec $MYSQLXTEST -u x_root --password='' -h127.0.0.1 --no-auth --file=$MYSQL_TMP_DIR/capabilities_compression_algorithm_set.xpl 2>&1 -v%VALUE%=wrong_name -v%RESULT%=Mysqlx.Error; --echo ############################################## --echo ## Mysqlx_compression_algorithms = deflate,lz4,zstd_stream --echo SET GLOBAL Mysqlx_compression_algorithms = 'deflate_stream,lz4_message,zstd_stream'; exec $MYSQLXTEST -u x_root --password='' -h127.0.0.1 --no-auth --file=$MYSQL_TMP_DIR/capabilities_compression_algorithm_get.xpl 2>&1; exec $MYSQLXTEST -u x_root --password='' -h127.0.0.1 --no-auth --file=$MYSQL_TMP_DIR/capabilities_compression_algorithm_set.xpl 2>&1 -v%VALUE%=lz4_message -v%RESULT%=Mysqlx.Ok; exec $MYSQLXTEST -u x_root --password='' -h127.0.0.1 --no-auth --file=$MYSQL_TMP_DIR/capabilities_compression_algorithm_set.xpl 2>&1 -v%VALUE%=deflate_stream -v%RESULT%=Mysqlx.Ok; exec $MYSQLXTEST -u x_root --password='' -h127.0.0.1 --no-auth --file=$MYSQL_TMP_DIR/capabilities_compression_algorithm_set.xpl 2>&1 -v%VALUE%=zstd_stream -v%RESULT%=Mysqlx.Ok; exec $MYSQLXTEST -u x_root --password='' -h127.0.0.1 --no-auth --file=$MYSQL_TMP_DIR/capabilities_compression_algorithm_set.xpl 2>&1 -v%VALUE%=wrong_name -v%RESULT%=Mysqlx.Error; ## Cleanup SET GLOBAL Mysqlx_compression_algorithms = DEFAULT; --source ../include/xplugin_cleanup.inc