## Test configuration ## --let $wait_for_unixsocket_status = no_wait --let $wait_for_tcpsocket_status = no_wait --source include/xplugin_preamble.inc call mtr.add_suppression("option 'mysqlx-port-open-timeout': value -1 adjusted to 0"); call mtr.add_suppression("option 'mysqlx-port-open-timeout': unsigned value 10000 adjusted to 120"); call mtr.add_suppression("option 'mysqlx-port-open-timeout': unsigned value 2147483648 adjusted to 120"); call mtr.add_suppression("option 'mysqlx-port-open-timeout': unsigned value 1024 adjusted to 120"); call mtr.add_suppression("Parsing options for plugin 'mysqlx' failed"); ## Test body ## --echo # --echo # --echo # X Plugin started with timeout set to "0" --echo # --echo # --let $assert_text= Mysqlx_port_open_timeout global variablem must exist --let $assert_cond= [SELECT COUNT(@@GLOBAL.Mysqlx_port_open_timeout) as Result;, Result, 1] =1 --source include/assert.inc --error ER_INCORRECT_GLOBAL_LOCAL_VAR SET @@GLOBAL.Mysqlx_port_open_timeout=1; --error ER_INCORRECT_GLOBAL_LOCAL_VAR SET @@GLOBAL.Mysqlx_port_open_timeout="1.0.1.0"; --Error ER_INCORRECT_GLOBAL_LOCAL_VAR SELECT COUNT(@@local.Mysqlx_port_open_timeout); --Error ER_INCORRECT_GLOBAL_LOCAL_VAR SELECT COUNT(@@SESSION.Mysqlx_port_open_timeout); --let $assert_text= Mysqlx_port_open_timeout global variable must is read-only, should hold to 0 --let $assert_cond= [SELECT @@GLOBAL.Mysqlx_port_open_timeout as Result;, Result, 1] =0 --source include/assert.inc --echo # --echo # --echo # X Plugin started with timeout set to "1" --echo # --echo # --let $restart_parameters = restart: --loose-mysqlx-port-open-timeout=1 --source include/restart_mysqld.inc --let $assert_text= Mysqlx_port_open_timeout global variablem must exist --let $assert_cond= [SELECT COUNT(@@GLOBAL.Mysqlx_port_open_timeout) as Result;, Result, 1] =1 --source include/assert.inc --error ER_INCORRECT_GLOBAL_LOCAL_VAR SET @@GLOBAL.Mysqlx_port_open_timeout=1; --error ER_INCORRECT_GLOBAL_LOCAL_VAR SET @@GLOBAL.Mysqlx_port_open_timeout="1.0.1.0"; --Error ER_INCORRECT_GLOBAL_LOCAL_VAR SELECT COUNT(@@local.Mysqlx_port_open_timeout); --Error ER_INCORRECT_GLOBAL_LOCAL_VAR SELECT COUNT(@@SESSION.Mysqlx_port_open_timeout); --let $assert_text= Mysqlx_port_open_timeout global variable must is read-only, should hold to 1 --let $assert_cond= [SELECT @@GLOBAL.Mysqlx_port_open_timeout as Result;, Result, 1] =1 --source include/assert.inc --echo # --echo # --echo # X Plugin restarted with invalid values --echo # --echo # # Under the MIN value --let $restart_parameters = restart: --loose-mysqlx-port-open-timeout=-1 --source include/restart_mysqld.inc --let $assert_text= Mysqlx_port_open_timeout global variable must be changed to 0 by MySQL Server --let $assert_cond= [SELECT @@GLOBAL.Mysqlx_port_open_timeout as Result;, Result, 1] =0 --source include/assert.inc # Above the MAX value --let $restart_parameters = restart: --loose-mysqlx-port-open-timeout=10000 --source include/restart_mysqld.inc --let $assert_text= Mysqlx_port_open_timeout global variable must be changed to 120 by MySQL Server --let $assert_cond= [SELECT @@GLOBAL.Mysqlx_port_open_timeout as Result;, Result, 1] =120 --source include/assert.inc # Above the MAX value --let $restart_parameters = restart: --loose-mysqlx-port-open-timeout=2G --source include/restart_mysqld.inc --let $assert_text= 2Giga is outside the range of Mysqlx_port_open_timeout global variable, MySQL Server is going to set it to 120 --let $assert_cond= [SELECT @@GLOBAL.Mysqlx_port_open_timeout as Result;, Result, 1] =120 --source include/assert.inc # Above the MAX value --let $restart_parameters = restart: --loose-mysqlx-port-open-timeout=1K --source include/restart_mysqld.inc --let $assert_text= 1Kilo is outside the range of Mysqlx_port_open_timeout global variable, MySQL Server is going to set it to 120 --let $assert_cond= [SELECT @@GLOBAL.Mysqlx_port_open_timeout as Result;, Result, 1] =120 --source include/assert.inc ## Cleanup --let $restart_parameters = restart: --source include/restart_mysqld.inc