1SET @start_global_value = @@global.old_passwords; 2SELECT @start_global_value; 3@start_global_value 40 5SET @start_session_value = @@session.old_passwords; 6SELECT @start_session_value; 7@start_session_value 80 9'#--------------------FN_DYNVARS_114_01-------------------------#' 10SET @@global.old_passwords = ON; 11SET @@global.old_passwords = DEFAULT; 12SELECT @@global.old_passwords; 13@@global.old_passwords 140 15SET @@session.old_passwords = ON; 16SET @@session.old_passwords = DEFAULT; 17SELECT @@session.old_passwords; 18@@session.old_passwords 190 20'#--------------------FN_DYNVARS_114_02-------------------------#' 21SET @@global.old_passwords = DEFAULT; 22SELECT @@global.old_passwords = FALSE; 23@@global.old_passwords = FALSE 241 25SET @@session.old_passwords = DEFAULT; 26SELECT @@session.old_passwords = FALSE; 27@@session.old_passwords = FALSE 281 29'#--------------------FN_DYNVARS_114_03-------------------------#' 30SET @@global.old_passwords = ON; 31SELECT @@global.old_passwords; 32@@global.old_passwords 331 34SET @@global.old_passwords = OFF; 35SELECT @@global.old_passwords; 36@@global.old_passwords 370 38SET @@global.old_passwords = 0; 39SELECT @@global.old_passwords; 40@@global.old_passwords 410 42SET @@global.old_passwords = 1; 43SELECT @@global.old_passwords; 44@@global.old_passwords 451 46SET @@global.old_passwords = TRUE; 47SELECT @@global.old_passwords; 48@@global.old_passwords 491 50SET @@global.old_passwords = FALSE; 51SELECT @@global.old_passwords; 52@@global.old_passwords 530 54'#--------------------FN_DYNVARS_114_04-------------------------#' 55SET @@session.old_passwords = ON; 56SELECT @@session.old_passwords; 57@@session.old_passwords 581 59SET @@session.old_passwords = OFF; 60SELECT @@session.old_passwords; 61@@session.old_passwords 620 63SET @@session.old_passwords = 0; 64SELECT @@session.old_passwords; 65@@session.old_passwords 660 67SET @@session.old_passwords = 1; 68SELECT @@session.old_passwords; 69@@session.old_passwords 701 71SET @@session.old_passwords = TRUE; 72SELECT @@session.old_passwords; 73@@session.old_passwords 741 75SET @@session.old_passwords = FALSE; 76SELECT @@session.old_passwords; 77@@session.old_passwords 780 79'#------------------FN_DYNVARS_114_05-----------------------#' 80SET @@global.old_passwords = 'ONN'; 81ERROR 42000: Variable 'old_passwords' can't be set to the value of 'ONN' 82SET @@global.old_passwords = "OFFF"; 83ERROR 42000: Variable 'old_passwords' can't be set to the value of 'OFFF' 84SET @@global.old_passwords = TTRUE; 85ERROR 42000: Variable 'old_passwords' can't be set to the value of 'TTRUE' 86SET @@global.old_passwords = FELSE; 87ERROR 42000: Variable 'old_passwords' can't be set to the value of 'FELSE' 88SET @@global.old_passwords = -1024; 89ERROR 42000: Variable 'old_passwords' can't be set to the value of '-1024' 90SET @@global.old_passwords = 65536; 91ERROR 42000: Variable 'old_passwords' can't be set to the value of '65536' 92SET @@global.old_passwords = 65530.34; 93ERROR 42000: Incorrect argument type to variable 'old_passwords' 94SET @@global.old_passwords = test; 95ERROR 42000: Variable 'old_passwords' can't be set to the value of 'test' 96SET @@session.old_passwords = ONN; 97ERROR 42000: Variable 'old_passwords' can't be set to the value of 'ONN' 98SET @@session.old_passwords = ONF; 99ERROR 42000: Variable 'old_passwords' can't be set to the value of 'ONF' 100SET @@session.old_passwords = OF; 101ERROR 42000: Variable 'old_passwords' can't be set to the value of 'OF' 102SET @@session.old_passwords = 'OFN'; 103ERROR 42000: Variable 'old_passwords' can't be set to the value of 'OFN' 104SET @@session.old_passwords = -2; 105ERROR 42000: Variable 'old_passwords' can't be set to the value of '-2' 106SET @@session.old_passwords = 65530.34; 107ERROR 42000: Incorrect argument type to variable 'old_passwords' 108SET @@session.old_passwords = 65550; 109ERROR 42000: Variable 'old_passwords' can't be set to the value of '65550' 110SET @@session.old_passwords = test; 111ERROR 42000: Variable 'old_passwords' can't be set to the value of 'test' 112'#------------------FN_DYNVARS_114_06-----------------------#' 113SELECT IF(@@global.old_passwords, "ON", "OFF") = VARIABLE_VALUE 114FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 115WHERE VARIABLE_NAME='old_passwords'; 116IF(@@global.old_passwords, "ON", "OFF") = VARIABLE_VALUE 1171 118'#------------------FN_DYNVARS_114_07-----------------------#' 119SELECT IF(@@session.old_passwords, "ON", "OFF") = VARIABLE_VALUE 120FROM INFORMATION_SCHEMA.SESSION_VARIABLES 121WHERE VARIABLE_NAME='old_passwords'; 122IF(@@session.old_passwords, "ON", "OFF") = VARIABLE_VALUE 1231 124'#---------------------FN_DYNVARS_114_08----------------------#' 125SET @@old_passwords = OFF; 126SET @@global.old_passwords = ON; 127SELECT @@old_passwords = @@global.old_passwords; 128@@old_passwords = @@global.old_passwords 1290 130'#---------------------FN_DYNVARS_114_09----------------------#' 131SET @@old_passwords = ON; 132SELECT @@old_passwords = @@local.old_passwords; 133@@old_passwords = @@local.old_passwords 1341 135SELECT @@local.old_passwords = @@session.old_passwords; 136@@local.old_passwords = @@session.old_passwords 1371 138'#---------------------FN_DYNVARS_114_10----------------------#' 139SET old_passwords = 1; 140SELECT @@old_passwords; 141@@old_passwords 1421 143SELECT local.old_passwords; 144ERROR 42S02: Unknown table 'local' in field list 145SELECT session.old_passwords; 146ERROR 42S02: Unknown table 'session' in field list 147SELECT old_passwords = @@session.old_passwords; 148ERROR 42S22: Unknown column 'old_passwords' in 'field list' 149SET @@global.old_passwords = @start_global_value; 150SELECT @@global.old_passwords; 151@@global.old_passwords 1520 153SET @@session.old_passwords = @start_session_value; 154SELECT @@session.old_passwords; 155@@session.old_passwords 1560 157