94 lines
2.6 KiB
Plaintext
94 lines
2.6 KiB
Plaintext
## Preamble
|
|
--source include/xplugin_preamble.inc
|
|
--source include/xplugin_create_user.inc
|
|
|
|
--echo #
|
|
--echo # Tests for setting the global and session value for net_read_timeout
|
|
--echo #
|
|
|
|
--echo # Get initial values
|
|
SET @start_global_read_value = @@global.net_read_timeout;
|
|
SELECT @start_global_read_value;
|
|
SET @start_session_read_value = @@session.net_read_timeout;
|
|
SELECT @start_session_read_value;
|
|
|
|
--echo # Try to change the values
|
|
--write_file $MYSQL_TMP_DIR/net_var_1.tmp
|
|
-->expecterror ER_PLUGGABLE_PROTOCOL_COMMAND_NOT_SUPPORTED
|
|
-->sql
|
|
SET @@global.net_read_timeout = 100;
|
|
SET @@session.net_read_timeout = 200;
|
|
-->endsql
|
|
EOF
|
|
--exec $MYSQLXTEST -ux_root --password='' --file=$MYSQL_TMP_DIR/net_var_1.tmp 2>&1
|
|
|
|
--echo # Get after values
|
|
SELECT @@global.net_read_timeout;
|
|
SELECT @@session.net_read_timeout;
|
|
|
|
# reset value
|
|
SET @@global.net_read_timeout = @start_global_read_value;
|
|
|
|
--echo #
|
|
--echo # Tests for setting the global and session value for net_write_timeout
|
|
--echo #
|
|
|
|
--echo # Get initial values
|
|
SET @start_global_write_value = @@global.net_write_timeout;
|
|
SELECT @start_global_write_value;
|
|
SET @start_session_write_value = @@session.net_write_timeout;
|
|
SELECT @start_session_write_value;
|
|
|
|
--echo # Try to change the values
|
|
--write_file $MYSQL_TMP_DIR/net_var_2.tmp
|
|
-->expecterror ER_PLUGGABLE_PROTOCOL_COMMAND_NOT_SUPPORTED
|
|
-->sql
|
|
SET @@global.net_write_timeout = 100;
|
|
SET @@session.net_write_timeout = 200;
|
|
-->endsql
|
|
EOF
|
|
|
|
--exec $MYSQLXTEST -ux_root --password='' --file=$MYSQL_TMP_DIR/net_var_2.tmp 2>&1
|
|
|
|
--echo # Get after values
|
|
SELECT @@global.net_write_timeout;
|
|
SELECT @@session.net_write_timeout;
|
|
|
|
# reset value
|
|
SET @@global.net_write_timeout = @start_global_write_value;
|
|
|
|
--echo #
|
|
--echo # Tests for setting the global and session value for net_retry_count
|
|
--echo #
|
|
|
|
--echo # Get initial values
|
|
SET @start_global_retry_value = @@global.net_retry_count;
|
|
SELECT @start_global_retry_value;
|
|
SET @start_session_retry_value = @@session.net_retry_count;
|
|
SELECT @start_session_retry_value;
|
|
|
|
--echo # Try to change the values
|
|
--write_file $MYSQL_TMP_DIR/net_var_3.tmp
|
|
|
|
-->expecterror ER_PLUGGABLE_PROTOCOL_COMMAND_NOT_SUPPORTED
|
|
-->sql
|
|
SET @@global.net_retry_count = 100;
|
|
SET @@session.net_retry_count = 200;
|
|
-->endsql
|
|
EOF
|
|
|
|
--exec $MYSQLXTEST -ux_root --password='' --file=$MYSQL_TMP_DIR/net_var_3.tmp 2>&1
|
|
|
|
--echo # Get after values
|
|
SELECT @@global.net_retry_count;
|
|
SELECT @@session.net_retry_count;
|
|
|
|
# reset value
|
|
SET @@global.net_retry_count = @start_global_retry_value;
|
|
|
|
## Cleanup
|
|
--remove_file $MYSQL_TMP_DIR/net_var_1.tmp
|
|
--remove_file $MYSQL_TMP_DIR/net_var_2.tmp
|
|
--remove_file $MYSQL_TMP_DIR/net_var_3.tmp
|
|
--source include/xplugin_drop_user.inc
|