diff options
Diffstat (limited to 'mysql-test/suite/sys_vars/r/timed_mutexes_basic.result')
| -rw-r--r-- | mysql-test/suite/sys_vars/r/timed_mutexes_basic.result | 104 |
1 files changed, 104 insertions, 0 deletions
diff --git a/mysql-test/suite/sys_vars/r/timed_mutexes_basic.result b/mysql-test/suite/sys_vars/r/timed_mutexes_basic.result new file mode 100644 index 00000000000..d8bd2cd975f --- /dev/null +++ b/mysql-test/suite/sys_vars/r/timed_mutexes_basic.result @@ -0,0 +1,104 @@ +SET @global_start_value = @@global.timed_mutexes; +SELECT @global_start_value; +@global_start_value +0 +'#--------------------FN_DYNVARS_177_01------------------------#' +SET @@global.timed_mutexes = 1; +SET @@global.timed_mutexes = DEFAULT; +SELECT @@global.timed_mutexes; +@@global.timed_mutexes +0 +'#---------------------FN_DYNVARS_177_02-------------------------#' +SET timed_mutexes = 1; +ERROR HY000: Variable 'timed_mutexes' is a GLOBAL variable and should be set with SET GLOBAL +SELECT @@timed_mutexes; +@@timed_mutexes +0 +SELECT global.timed_mutexes; +ERROR 42S02: Unknown table 'global' in field list +SET global timed_mutexes = 1; +SELECT @@global.timed_mutexes; +@@global.timed_mutexes +1 +'#--------------------FN_DYNVARS_177_03------------------------#' +SET @@global.timed_mutexes = 0; +SELECT @@global.timed_mutexes; +@@global.timed_mutexes +0 +SET @@global.timed_mutexes = 1; +SELECT @@global.timed_mutexes; +@@global.timed_mutexes +1 +'#--------------------FN_DYNVARS_177_04-------------------------#' +SET @@global.timed_mutexes = -1; +ERROR 42000: Variable 'timed_mutexes' can't be set to the value of '-1' +SET @@global.timed_mutexes = 2; +ERROR 42000: Variable 'timed_mutexes' can't be set to the value of '2' +SET @@global.timed_mutexes = "T"; +ERROR 42000: Variable 'timed_mutexes' can't be set to the value of 'T' +SET @@global.timed_mutexes = "Y"; +ERROR 42000: Variable 'timed_mutexes' can't be set to the value of 'Y' +SET @@global.timed_mutexes = _true; +ERROR 42000: Variable 'timed_mutexes' can't be set to the value of '_true' +SET @@global.timed_mutexes = 0N; +ERROR 42000: Variable 'timed_mutexes' can't be set to the value of '0N' +SET @@global.timed_mutexes = 1+1; +ERROR 42000: Variable 'timed_mutexes' can't be set to the value of '2' +SET @@global.timed_mutexes = 0FF; +ERROR 42000: Variable 'timed_mutexes' can't be set to the value of '0FF' +SET @@global.timed_mutexes = '0'; +ERROR 42000: Variable 'timed_mutexes' can't be set to the value of '0' +SET @@global.timed_mutexes = N; +ERROR 42000: Variable 'timed_mutexes' can't be set to the value of 'N' +'#-------------------FN_DYNVARS_177_05----------------------------#' +SET @@session.timed_mutexes = 0; +ERROR HY000: Variable 'timed_mutexes' is a GLOBAL variable and should be set with SET GLOBAL +SET @@timed_mutexes = 0; +ERROR HY000: Variable 'timed_mutexes' is a GLOBAL variable and should be set with SET GLOBAL +SET @@local.timed_mutexes = 0; +ERROR HY000: Variable 'timed_mutexes' is a GLOBAL variable and should be set with SET GLOBAL +SELECT @@session.timed_mutexes; +ERROR HY000: Variable 'timed_mutexes' is a GLOBAL variable +SELECT @@local.timed_mutexes; +ERROR HY000: Variable 'timed_mutexes' is a GLOBAL variable +'#----------------------FN_DYNVARS_177_06------------------------#' +SELECT count(VARIABLE_VALUE) FROM INFORMATION_SCHEMA.SESSION_VARIABLES +WHERE VARIABLE_NAME='timed_mutexes'; +count(VARIABLE_VALUE) +1 +'#----------------------FN_DYNVARS_177_07------------------------#' +SELECT @@global.timed_mutexes = VARIABLE_VALUE +FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES +WHERE VARIABLE_NAME='timed_mutexes'; +@@global.timed_mutexes = VARIABLE_VALUE +0 +SELECT @@global.timed_mutexes; +@@global.timed_mutexes +1 +SELECT VARIABLE_VALUE +FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES +WHERE VARIABLE_NAME='timed_mutexes'; +VARIABLE_VALUE +ON +'#---------------------FN_DYNVARS_177_08-------------------------#' +SET @@global.timed_mutexes = OFF; +SELECT @@global.timed_mutexes; +@@global.timed_mutexes +0 +SET @@global.timed_mutexes = ON; +SELECT @@global.timed_mutexes; +@@global.timed_mutexes +1 +'#---------------------FN_DYNVARS_177_09----------------------#' +SET @@global.timed_mutexes = TRUE; +SELECT @@global.timed_mutexes; +@@global.timed_mutexes +1 +SET @@global.timed_mutexes = FALSE; +SELECT @@global.timed_mutexes; +@@global.timed_mutexes +0 +SET @@global.timed_mutexes = @global_start_value; +SELECT @@global.timed_mutexes; +@@global.timed_mutexes +0 |