1SET @start_global_value = @@global.keep_files_on_create; 2SELECT @start_global_value; 3@start_global_value 40 5SET @start_session_value = @@session.keep_files_on_create; 6SELECT @start_session_value; 7@start_session_value 80 9'#--------------------FN_DYNVARS_054_01-------------------------#' 10SET @@global.keep_files_on_create = ON; 11SET @@global.keep_files_on_create = DEFAULT; 12SELECT @@global.keep_files_on_create; 13@@global.keep_files_on_create 140 15SET @@session.keep_files_on_create = ON; 16SET @@session.keep_files_on_create = DEFAULT; 17SELECT @@session.keep_files_on_create; 18@@session.keep_files_on_create 190 20'#--------------------FN_DYNVARS_054_02-------------------------#' 21SET @@global.keep_files_on_create = DEFAULT; 22SELECT @@global.keep_files_on_create = 'OFF'; 23@@global.keep_files_on_create = 'OFF' 241 25Warnings: 26Warning 1292 Truncated incorrect DOUBLE value: 'OFF' 27SET @@session.keep_files_on_create = DEFAULT; 28SELECT @@session.keep_files_on_create = 'OFF'; 29@@session.keep_files_on_create = 'OFF' 301 31Warnings: 32Warning 1292 Truncated incorrect DOUBLE value: 'OFF' 33'#--------------------FN_DYNVARS_054_03-------------------------#' 34SET @@global.keep_files_on_create = ON; 35SELECT @@global.keep_files_on_create; 36@@global.keep_files_on_create 371 38SET @@global.keep_files_on_create = OFF; 39SELECT @@global.keep_files_on_create; 40@@global.keep_files_on_create 410 42SET @@global.keep_files_on_create = 0; 43SELECT @@global.keep_files_on_create; 44@@global.keep_files_on_create 450 46SET @@global.keep_files_on_create = 1; 47SELECT @@global.keep_files_on_create; 48@@global.keep_files_on_create 491 50SET @@global.keep_files_on_create = TRUE; 51SELECT @@global.keep_files_on_create; 52@@global.keep_files_on_create 531 54SET @@global.keep_files_on_create = FALSE; 55SELECT @@global.keep_files_on_create; 56@@global.keep_files_on_create 570 58'#--------------------FN_DYNVARS_054_04-------------------------#' 59SET @@session.keep_files_on_create = ON; 60SELECT @@session.keep_files_on_create; 61@@session.keep_files_on_create 621 63SET @@session.keep_files_on_create = OFF; 64SELECT @@session.keep_files_on_create; 65@@session.keep_files_on_create 660 67SET @@session.keep_files_on_create = 0; 68SELECT @@session.keep_files_on_create; 69@@session.keep_files_on_create 700 71SET @@session.keep_files_on_create = 1; 72SELECT @@session.keep_files_on_create; 73@@session.keep_files_on_create 741 75SET @@session.keep_files_on_create = TRUE; 76SELECT @@session.keep_files_on_create; 77@@session.keep_files_on_create 781 79SET @@session.keep_files_on_create = FALSE; 80SELECT @@session.keep_files_on_create; 81@@session.keep_files_on_create 820 83'#------------------FN_DYNVARS_054_05-----------------------#' 84SET @@global.keep_files_on_create = 'ONN'; 85ERROR 42000: Variable 'keep_files_on_create' can't be set to the value of 'ONN' 86SET @@global.keep_files_on_create = "OFFF"; 87ERROR 42000: Variable 'keep_files_on_create' can't be set to the value of 'OFFF' 88SET @@global.keep_files_on_create = TTRUE; 89ERROR 42000: Variable 'keep_files_on_create' can't be set to the value of 'TTRUE' 90SET @@global.keep_files_on_create = FELSE; 91ERROR 42000: Variable 'keep_files_on_create' can't be set to the value of 'FELSE' 92SET @@global.keep_files_on_create = -1024; 93ERROR 42000: Variable 'keep_files_on_create' can't be set to the value of '-1024' 94SET @@global.keep_files_on_create = 65536; 95ERROR 42000: Variable 'keep_files_on_create' can't be set to the value of '65536' 96SET @@global.keep_files_on_create = 65530.34; 97ERROR 42000: Incorrect argument type to variable 'keep_files_on_create' 98SET @@global.keep_files_on_create = test; 99ERROR 42000: Variable 'keep_files_on_create' can't be set to the value of 'test' 100SET @@session.keep_files_on_create = ONN; 101ERROR 42000: Variable 'keep_files_on_create' can't be set to the value of 'ONN' 102SET @@session.keep_files_on_create = ONF; 103ERROR 42000: Variable 'keep_files_on_create' can't be set to the value of 'ONF' 104SET @@session.keep_files_on_create = OF; 105ERROR 42000: Variable 'keep_files_on_create' can't be set to the value of 'OF' 106SET @@session.keep_files_on_create = 'OFN'; 107ERROR 42000: Variable 'keep_files_on_create' can't be set to the value of 'OFN' 108SET @@session.keep_files_on_create = -2; 109ERROR 42000: Variable 'keep_files_on_create' can't be set to the value of '-2' 110SET @@session.keep_files_on_create = 65530.34; 111ERROR 42000: Incorrect argument type to variable 'keep_files_on_create' 112SET @@session.keep_files_on_create = 65550; 113ERROR 42000: Variable 'keep_files_on_create' can't be set to the value of '65550' 114SET @@session.keep_files_on_create = test; 115ERROR 42000: Variable 'keep_files_on_create' can't be set to the value of 'test' 116SELECT @@session.keep_files_on_create; 117@@session.keep_files_on_create 1180 119'#------------------FN_DYNVARS_054_06-----------------------#' 120SELECT IF(@@global.keep_files_on_create, "ON", "OFF") = VARIABLE_VALUE 121FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 122WHERE VARIABLE_NAME='keep_files_on_create'; 123IF(@@global.keep_files_on_create, "ON", "OFF") = VARIABLE_VALUE 1241 125'#------------------FN_DYNVARS_054_07-----------------------#' 126SELECT IF(@@session.keep_files_on_create, "ON", "OFF") = VARIABLE_VALUE 127FROM INFORMATION_SCHEMA.SESSION_VARIABLES 128WHERE VARIABLE_NAME='keep_files_on_create'; 129IF(@@session.keep_files_on_create, "ON", "OFF") = VARIABLE_VALUE 1301 131'#---------------------FN_DYNVARS_001_08----------------------#' 132SET @@keep_files_on_create = OFF; 133SET @@global.keep_files_on_create = ON; 134SELECT @@keep_files_on_create = @@global.keep_files_on_create; 135@@keep_files_on_create = @@global.keep_files_on_create 1360 137'#---------------------FN_DYNVARS_001_09----------------------#' 138SET @@keep_files_on_create = ON; 139SELECT @@keep_files_on_create = @@local.keep_files_on_create; 140@@keep_files_on_create = @@local.keep_files_on_create 1411 142SELECT @@local.keep_files_on_create = @@session.keep_files_on_create; 143@@local.keep_files_on_create = @@session.keep_files_on_create 1441 145'#---------------------FN_DYNVARS_001_10----------------------#' 146SET keep_files_on_create = 1; 147SELECT @@keep_files_on_create; 148@@keep_files_on_create 1491 150SELECT local.keep_files_on_create; 151ERROR 42S02: Unknown table 'local' in field list 152SELECT session.keep_files_on_create; 153ERROR 42S02: Unknown table 'session' in field list 154SELECT keep_files_on_create = @@session.keep_files_on_create; 155ERROR 42S22: Unknown column 'keep_files_on_create' in 'field list' 156SET @@global.keep_files_on_create = @start_global_value; 157SELECT @@global.keep_files_on_create; 158@@global.keep_files_on_create 1590 160SET @@session.keep_files_on_create = @start_session_value; 161SELECT @@session.keep_files_on_create; 162@@session.keep_files_on_create 1630 164