diff options
Diffstat (limited to 'mysql-test/suite/sys_vars/r/innodb_print_lock_wait_timeout_info_basic.result')
-rw-r--r-- | mysql-test/suite/sys_vars/r/innodb_print_lock_wait_timeout_info_basic.result | 104 |
1 files changed, 0 insertions, 104 deletions
diff --git a/mysql-test/suite/sys_vars/r/innodb_print_lock_wait_timeout_info_basic.result b/mysql-test/suite/sys_vars/r/innodb_print_lock_wait_timeout_info_basic.result deleted file mode 100644 index cc035e4f8bc..00000000000 --- a/mysql-test/suite/sys_vars/r/innodb_print_lock_wait_timeout_info_basic.result +++ /dev/null @@ -1,104 +0,0 @@ -SET @start_global_value = @@global.innodb_print_lock_wait_timeout_info; -SELECT @start_global_value; -@start_global_value -0 -Valid values are 'ON' and 'OFF' -SELECT @@global.innodb_print_lock_wait_timeout_info in (0, 1); -@@global.innodb_print_lock_wait_timeout_info in (0, 1) -1 -SELECT @@global.innodb_print_lock_wait_timeout_info; -@@global.innodb_print_lock_wait_timeout_info -0 -SELECT @@session.innodb_print_lock_wait_timeout_info; -ERROR HY000: Variable 'innodb_print_lock_wait_timeout_info' is a GLOBAL variable -SHOW global variables LIKE 'innodb_print_lock_wait_timeout_info'; -Variable_name Value -innodb_print_lock_wait_timeout_info OFF -SHOW session variables LIKE 'innodb_print_lock_wait_timeout_info'; -Variable_name Value -innodb_print_lock_wait_timeout_info OFF -SELECT * FROM information_schema.global_variables -WHERE variable_name='innodb_print_lock_wait_timeout_info'; -VARIABLE_NAME VARIABLE_VALUE -INNODB_PRINT_LOCK_WAIT_TIMEOUT_INFO OFF -SELECT * FROM information_schema.session_variables -WHERE variable_name='innodb_print_lock_wait_timeout_info'; -VARIABLE_NAME VARIABLE_VALUE -INNODB_PRINT_LOCK_WAIT_TIMEOUT_INFO OFF -SET global innodb_print_lock_wait_timeout_info='OFF'; -SELECT @@global.innodb_print_lock_wait_timeout_info; -@@global.innodb_print_lock_wait_timeout_info -0 -SELECT * FROM information_schema.global_variables -WHERE variable_name='innodb_print_lock_wait_timeout_info'; -VARIABLE_NAME VARIABLE_VALUE -INNODB_PRINT_LOCK_WAIT_TIMEOUT_INFO OFF -SELECT * FROM information_schema.session_variables -WHERE variable_name='innodb_print_lock_wait_timeout_info'; -VARIABLE_NAME VARIABLE_VALUE -INNODB_PRINT_LOCK_WAIT_TIMEOUT_INFO OFF -SET @@global.innodb_print_lock_wait_timeout_info=1; -SELECT @@global.innodb_print_lock_wait_timeout_info; -@@global.innodb_print_lock_wait_timeout_info -1 -SELECT * FROM information_schema.global_variables -WHERE variable_name='innodb_print_lock_wait_timeout_info'; -VARIABLE_NAME VARIABLE_VALUE -INNODB_PRINT_LOCK_WAIT_TIMEOUT_INFO ON -SELECT * FROM information_schema.session_variables -WHERE variable_name='innodb_print_lock_wait_timeout_info'; -VARIABLE_NAME VARIABLE_VALUE -INNODB_PRINT_LOCK_WAIT_TIMEOUT_INFO ON -SET global innodb_print_lock_wait_timeout_info=0; -SELECT @@global.innodb_print_lock_wait_timeout_info; -@@global.innodb_print_lock_wait_timeout_info -0 -SELECT * FROM information_schema.global_variables -WHERE variable_name='innodb_print_lock_wait_timeout_info'; -VARIABLE_NAME VARIABLE_VALUE -INNODB_PRINT_LOCK_WAIT_TIMEOUT_INFO OFF -SELECT * FROM information_schema.session_variables -WHERE variable_name='innodb_print_lock_wait_timeout_info'; -VARIABLE_NAME VARIABLE_VALUE -INNODB_PRINT_LOCK_WAIT_TIMEOUT_INFO OFF -SET @@global.innodb_print_lock_wait_timeout_info='ON'; -SELECT @@global.innodb_print_lock_wait_timeout_info; -@@global.innodb_print_lock_wait_timeout_info -1 -SELECT * FROM information_schema.global_variables -WHERE variable_name='innodb_print_lock_wait_timeout_info'; -VARIABLE_NAME VARIABLE_VALUE -INNODB_PRINT_LOCK_WAIT_TIMEOUT_INFO ON -SELECT * FROM information_schema.session_variables -WHERE variable_name='innodb_print_lock_wait_timeout_info'; -VARIABLE_NAME VARIABLE_VALUE -INNODB_PRINT_LOCK_WAIT_TIMEOUT_INFO ON -SET session innodb_print_lock_wait_timeout_info='OFF'; -ERROR HY000: Variable 'innodb_print_lock_wait_timeout_info' is a GLOBAL variable and should be set with SET GLOBAL -SET @@session.innodb_print_lock_wait_timeout_info='ON'; -ERROR HY000: Variable 'innodb_print_lock_wait_timeout_info' is a GLOBAL variable and should be set with SET GLOBAL -SET global innodb_print_lock_wait_timeout_info=1.1; -ERROR 42000: Incorrect argument type to variable 'innodb_print_lock_wait_timeout_info' -SET global innodb_print_lock_wait_timeout_info=1e1; -ERROR 42000: Incorrect argument type to variable 'innodb_print_lock_wait_timeout_info' -SET global innodb_print_lock_wait_timeout_info=2; -ERROR 42000: Variable 'innodb_print_lock_wait_timeout_info' can't be set to the value of '2' -SET global innodb_print_lock_wait_timeout_info=-3; -ERROR 42000: Variable 'innodb_print_lock_wait_timeout_info' can't be set to the value of '-3' -SELECT @@global.innodb_print_lock_wait_timeout_info; -@@global.innodb_print_lock_wait_timeout_info -1 -SELECT * FROM information_schema.global_variables -WHERE variable_name='innodb_print_lock_wait_timeout_info'; -VARIABLE_NAME VARIABLE_VALUE -INNODB_PRINT_LOCK_WAIT_TIMEOUT_INFO ON -SELECT * FROM information_schema.session_variables -WHERE variable_name='innodb_print_lock_wait_timeout_info'; -VARIABLE_NAME VARIABLE_VALUE -INNODB_PRINT_LOCK_WAIT_TIMEOUT_INFO ON -SET global innodb_print_lock_wait_timeout_info='AUTO'; -ERROR 42000: Variable 'innodb_print_lock_wait_timeout_info' can't be set to the value of 'AUTO' -SET @@global.innodb_print_lock_wait_timeout_info = @start_global_value; -SELECT @@global.innodb_print_lock_wait_timeout_info; -@@global.innodb_print_lock_wait_timeout_info -0 |