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