1SET @start_global_value = @@global.log_warnings; 2SELECT @start_global_value; 3@start_global_value 42 5SET @start_session_value = @@session.log_warnings; 6SELECT @start_session_value; 7@start_session_value 82 9'#--------------------FN_DYNVARS_067_01-------------------------#' 10SET @@global.log_warnings = 100; 11SET @@global.log_warnings = DEFAULT; 12SELECT @@global.log_warnings; 13@@global.log_warnings 142 15SET @@session.log_warnings = 200; 16SET @@session.log_warnings = DEFAULT; 17SELECT @@session.log_warnings; 18@@session.log_warnings 192 20'#--------------------FN_DYNVARS_067_02-------------------------#' 21SET @@global.log_warnings = DEFAULT; 22SELECT @@global.log_warnings = 1; 23@@global.log_warnings = 1 240 25SET @@session.log_warnings = DEFAULT; 26SELECT @@session.log_warnings = 1; 27@@session.log_warnings = 1 280 29'#--------------------FN_DYNVARS_067_03-------------------------#' 30SET @@global.log_warnings = 0; 31SELECT @@global.log_warnings; 32@@global.log_warnings 330 34SET @@global.log_warnings = 1; 35SELECT @@global.log_warnings; 36@@global.log_warnings 371 38SET @@global.log_warnings = 60020; 39SELECT @@global.log_warnings; 40@@global.log_warnings 4160020 42SET @@global.log_warnings = 65535; 43SELECT @@global.log_warnings; 44@@global.log_warnings 4565535 46SET @@global.log_warnings = 65536; 47SELECT @@global.log_warnings; 48@@global.log_warnings 4965536 50'#--------------------FN_DYNVARS_067_04-------------------------#' 51SET @@session.log_warnings = 0; 52SELECT @@session.log_warnings; 53@@session.log_warnings 540 55SET @@session.log_warnings = 1; 56SELECT @@session.log_warnings; 57@@session.log_warnings 581 59SET @@session.log_warnings = 50050; 60SELECT @@session.log_warnings; 61@@session.log_warnings 6250050 63SET @@session.log_warnings = 65535; 64SELECT @@session.log_warnings; 65@@session.log_warnings 6665535 67SET @@session.log_warnings = 65550; 68SELECT @@session.log_warnings; 69@@session.log_warnings 7065550 71'#------------------FN_DYNVARS_067_05-----------------------#' 72SET @@global.log_warnings = 100000000000; 73Warnings: 74Warning 1292 Truncated incorrect log_warnings value: '100000000000' 75SELECT @@global.log_warnings; 76@@global.log_warnings 774294967295 78SET @@global.log_warnings = -1024; 79Warnings: 80Warning 1292 Truncated incorrect log_warnings value: '-1024' 81SELECT @@global.log_warnings; 82@@global.log_warnings 830 84SET @@global.log_warnings = 65530.34; 85ERROR 42000: Incorrect argument type to variable 'log_warnings' 86SELECT @@global.log_warnings; 87@@global.log_warnings 880 89SET @@global.log_warnings = test; 90ERROR 42000: Incorrect argument type to variable 'log_warnings' 91SELECT @@global.log_warnings; 92@@global.log_warnings 930 94SET @@session.log_warnings = 100000000000; 95Warnings: 96Warning 1292 Truncated incorrect log_warnings value: '100000000000' 97SELECT @@session.log_warnings; 98@@session.log_warnings 994294967295 100SET @@session.log_warnings = -2; 101Warnings: 102Warning 1292 Truncated incorrect log_warnings value: '-2' 103SELECT @@session.log_warnings; 104@@session.log_warnings 1050 106SET @@session.log_warnings = 65530.34; 107ERROR 42000: Incorrect argument type to variable 'log_warnings' 108SET @@session.log_warnings = test; 109ERROR 42000: Incorrect argument type to variable 'log_warnings' 110SELECT @@session.log_warnings; 111@@session.log_warnings 1120 113'#------------------FN_DYNVARS_067_06-----------------------#' 114SELECT @@global.log_warnings = VARIABLE_VALUE 115FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 116WHERE VARIABLE_NAME='log_warnings'; 117@@global.log_warnings = VARIABLE_VALUE 1181 119'#------------------FN_DYNVARS_067_07-----------------------#' 120SELECT @@session.log_warnings = VARIABLE_VALUE 121FROM INFORMATION_SCHEMA.SESSION_VARIABLES 122WHERE VARIABLE_NAME='log_warnings'; 123@@session.log_warnings = VARIABLE_VALUE 1241 125'#------------------FN_DYNVARS_067_08-----------------------#' 126SET @@global.log_warnings = TRUE; 127SELECT @@global.log_warnings; 128@@global.log_warnings 1291 130SET @@global.log_warnings = FALSE; 131SELECT @@global.log_warnings; 132@@global.log_warnings 1330 134'#---------------------FN_DYNVARS_067_09----------------------#' 135SET @@global.log_warnings = 10; 136SELECT @@log_warnings = @@global.log_warnings; 137@@log_warnings = @@global.log_warnings 1380 139'#---------------------FN_DYNVARS_067_10----------------------#' 140SET @@log_warnings = 100; 141SELECT @@log_warnings = @@local.log_warnings; 142@@log_warnings = @@local.log_warnings 1431 144SELECT @@local.log_warnings = @@session.log_warnings; 145@@local.log_warnings = @@session.log_warnings 1461 147'#---------------------FN_DYNVARS_067_11----------------------#' 148SET log_warnings = 1; 149SELECT @@log_warnings; 150@@log_warnings 1511 152SELECT local.log_warnings; 153ERROR 42S02: Unknown table 'local' in field list 154SELECT session.log_warnings; 155ERROR 42S02: Unknown table 'session' in field list 156SELECT log_warnings = @@session.log_warnings; 157ERROR 42S22: Unknown column 'log_warnings' in 'field list' 158SET @@global.log_warnings = @start_global_value; 159SELECT @@global.log_warnings; 160@@global.log_warnings 1612 162SET @@session.log_warnings = @start_session_value; 163SELECT @@session.log_warnings; 164@@session.log_warnings 1652 166