## 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