diff options
Diffstat (limited to 'mysql-test/r/secure_auth_basic.result')
| -rw-r--r-- | mysql-test/r/secure_auth_basic.result | 105 |
1 files changed, 105 insertions, 0 deletions
diff --git a/mysql-test/r/secure_auth_basic.result b/mysql-test/r/secure_auth_basic.result new file mode 100644 index 00000000000..b8a903ba420 --- /dev/null +++ b/mysql-test/r/secure_auth_basic.result @@ -0,0 +1,105 @@ +SET @global_start_value = @@global.secure_auth; +SELECT @global_start_value; +@global_start_value +0 +'#--------------------FN_DYNVARS_143_01------------------------#' +SET @@global.secure_auth = 1; +SET @@global.secure_auth = DEFAULT; +SELECT @@global.secure_auth; +@@global.secure_auth +0 +'#---------------------FN_DYNVARS_143_02-------------------------#' +SET secure_auth = 1; +ERROR HY000: Variable 'secure_auth' is a GLOBAL variable and should be set with SET GLOBAL +SELECT @@secure_auth; +@@secure_auth +0 +SELECT global.secure_auth; +ERROR 42S02: Unknown table 'global' in field list +SET global secure_auth = 1; +SELECT @@global.secure_auth; +@@global.secure_auth +1 +'#--------------------FN_DYNVARS_143_03------------------------#' +SET @@global.secure_auth = 0; +SELECT @@global.secure_auth; +@@global.secure_auth +0 +SET @@global.secure_auth = 1; +SELECT @@global.secure_auth; +@@global.secure_auth +1 +'#--------------------FN_DYNVARS_143_04-------------------------#' +SET @@global.secure_auth = -1; +ERROR 42000: Variable 'secure_auth' can't be set to the value of '-1' +SET @@global.secure_auth = 2; +ERROR 42000: Variable 'secure_auth' can't be set to the value of '2' +SET @@global.secure_auth = "T"; +ERROR 42000: Variable 'secure_auth' can't be set to the value of 'T' +SET @@global.secure_auth = "Y"; +ERROR 42000: Variable 'secure_auth' can't be set to the value of 'Y' +SET @@global.secure_auth = YES; +ERROR 42000: Variable 'secure_auth' can't be set to the value of 'YES' +SET @@global.secure_auth = ONN; +ERROR 42000: Variable 'secure_auth' can't be set to the value of 'ONN' +SET @@global.secure_auth = OOF; +ERROR 42000: Variable 'secure_auth' can't be set to the value of 'OOF' +SET @@global.secure_auth = 0FF; +ERROR 42000: Variable 'secure_auth' can't be set to the value of '0FF' +SET @@global.secure_auth = ' 1'; +ERROR 42000: Variable 'secure_auth' can't be set to the value of ' 1' +SET @@global.secure_auth = NO; +ERROR 42000: Variable 'secure_auth' can't be set to the value of 'NO' +'#-------------------FN_DYNVARS_143_05----------------------------#' +SET @@session.secure_auth = 0; +ERROR HY000: Variable 'secure_auth' is a GLOBAL variable and should be set with SET GLOBAL +SET @@secure_auth = 0; +ERROR HY000: Variable 'secure_auth' is a GLOBAL variable and should be set with SET GLOBAL +SET @@local.secure_auth = 0; +ERROR HY000: Variable 'secure_auth' is a GLOBAL variable and should be set with SET GLOBAL +SELECT @@session.secure_auth; +ERROR HY000: Variable 'secure_auth' is a GLOBAL variable +SELECT @@local.secure_auth; +ERROR HY000: Variable 'secure_auth' is a GLOBAL variable +'#----------------------FN_DYNVARS_143_06------------------------#' +SELECT count(VARIABLE_VALUE) +FROM INFORMATION_SCHEMA.SESSION_VARIABLES +WHERE VARIABLE_NAME='secure_auth'; +count(VARIABLE_VALUE) +1 +'#----------------------FN_DYNVARS_143_07------------------------#' +SELECT @@global.secure_auth = VARIABLE_VALUE +FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES +WHERE VARIABLE_NAME='secure_auth'; +@@global.secure_auth = VARIABLE_VALUE +0 +SELECT @@global.secure_auth; +@@global.secure_auth +1 +SELECT VARIABLE_VALUE +FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES +WHERE VARIABLE_NAME='secure_auth'; +VARIABLE_VALUE +ON +'#---------------------FN_DYNVARS_143_08-------------------------#' +SET @@global.secure_auth = OFF; +SELECT @@global.secure_auth; +@@global.secure_auth +0 +SET @@global.secure_auth = ON; +SELECT @@global.secure_auth; +@@global.secure_auth +1 +'#---------------------FN_DYNVARS_143_09----------------------#' +SET @@global.secure_auth = TRUE; +SELECT @@global.secure_auth; +@@global.secure_auth +1 +SET @@global.secure_auth = FALSE; +SELECT @@global.secure_auth; +@@global.secure_auth +0 +SET @@global.secure_auth = @global_start_value; +SELECT @@global.secure_auth; +@@global.secure_auth +0 |