1SET @start_global_value = @@global.max_statement_time; 2SELECT @start_global_value; 3@start_global_value 40 5SET @start_session_value = @@session.max_statement_time; 6SELECT @start_session_value; 7@start_session_value 80 9'#--------------------FN_DYNVARS_068_01-------------------------#' 10SET @@global.max_statement_time = 100; 11SET @@global.max_statement_time = DEFAULT; 12SELECT @@global.max_statement_time; 13@@global.max_statement_time 140.000000 15SET @@session.max_statement_time = 200; 16SET @@session.max_statement_time = DEFAULT; 17SELECT @@session.max_statement_time; 18@@session.max_statement_time 190.000000 20'#--------------------FN_DYNVARS_068_02-------------------------#' 21SET @@global.max_statement_time = DEFAULT; 22SELECT @@global.max_statement_time = 0; 23@@global.max_statement_time = 0 241 25SET @@session.max_statement_time = DEFAULT; 26SELECT @@session.max_statement_time = 0; 27@@session.max_statement_time = 0 281 29'#--------------------FN_DYNVARS_068_03-------------------------#' 30SET @@global.max_statement_time = 0; 31SELECT @@global.max_statement_time; 32@@global.max_statement_time 330.000000 34SET @@global.max_statement_time = 0.123456; 35SELECT @@global.max_statement_time; 36@@global.max_statement_time 370.123456 38SET @@global.max_statement_time = 60020; 39SELECT @@global.max_statement_time; 40@@global.max_statement_time 4160020.000000 42SET @@global.max_statement_time = 31536000; 43SELECT @@global.max_statement_time; 44@@global.max_statement_time 4531536000.000000 46SET @@global.max_statement_time = 65536; 47SELECT @@global.max_statement_time; 48@@global.max_statement_time 4965536.000000 50'#--------------------FN_DYNVARS_068_04-------------------------#' 51SET @@session.max_statement_time = 0; 52SELECT @@session.max_statement_time; 53@@session.max_statement_time 540.000000 55SET @@session.max_statement_time = 1; 56SELECT @@session.max_statement_time; 57@@session.max_statement_time 581.000000 59SET @@session.max_statement_time = 50050; 60SELECT @@session.max_statement_time; 61@@session.max_statement_time 6250050.000000 63SET @@session.max_statement_time = 31536000; 64SELECT @@session.max_statement_time; 65@@session.max_statement_time 6631536000.000000 67SET @@session.max_statement_time = 65550; 68SELECT @@session.max_statement_time; 69@@session.max_statement_time 7065550.000000 71'#------------------FN_DYNVARS_068_05-----------------------#' 72SET @@global.max_statement_time = 100000000000; 73Warnings: 74Warning 1292 Truncated incorrect max_statement_time value: '100000000000' 75SELECT @@global.max_statement_time; 76@@global.max_statement_time 7731536000.000000 78SET @@global.max_statement_time = -1; 79Warnings: 80Warning 1292 Truncated incorrect max_statement_time value: '-1' 81SELECT @@global.max_statement_time; 82@@global.max_statement_time 830.000000 84SET @@global.max_statement_time = 65530.34; 85SELECT @@global.max_statement_time; 86@@global.max_statement_time 8765530.340000 88SET @@global.max_statement_time = test; 89ERROR 42000: Incorrect argument type to variable 'max_statement_time' 90SELECT @@global.max_statement_time; 91@@global.max_statement_time 9265530.340000 93SET @@session.max_statement_time = 100000000000; 94Warnings: 95Warning 1292 Truncated incorrect max_statement_time value: '100000000000' 96SELECT @@session.max_statement_time; 97@@session.max_statement_time 9831536000.000000 99SET @@session.max_statement_time = -2; 100Warnings: 101Warning 1292 Truncated incorrect max_statement_time value: '-2' 102SELECT @@session.max_statement_time; 103@@session.max_statement_time 1040.000000 105SET @@session.max_statement_time = 65530.34; 106SELECT @@session.max_statement_time; 107@@session.max_statement_time 10865530.340000 109SET @@session.max_statement_time = test; 110ERROR 42000: Incorrect argument type to variable 'max_statement_time' 111SELECT @@session.max_statement_time; 112@@session.max_statement_time 11365530.340000 114'#------------------FN_DYNVARS_068_06-----------------------#' 115SELECT @@global.max_statement_time = VARIABLE_VALUE 116FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 117WHERE VARIABLE_NAME='max_statement_time'; 118@@global.max_statement_time = VARIABLE_VALUE 1191 120'#------------------FN_DYNVARS_068_07-----------------------#' 121SELECT @@session.max_statement_time = VARIABLE_VALUE 122FROM INFORMATION_SCHEMA.SESSION_VARIABLES 123WHERE VARIABLE_NAME='max_statement_time'; 124@@session.max_statement_time = VARIABLE_VALUE 1251 126'#------------------FN_DYNVARS_068_08-----------------------#' 127SET @@global.max_statement_time = TRUE; 128SELECT @@global.max_statement_time; 129@@global.max_statement_time 1301.000000 131SET @@global.max_statement_time = FALSE; 132SELECT @@global.max_statement_time; 133@@global.max_statement_time 1340.000000 135'#---------------------FN_DYNVARS_001_09----------------------#' 136SET @@global.max_statement_time = 10; 137SELECT @@max_statement_time = @@global.max_statement_time; 138@@max_statement_time = @@global.max_statement_time 1390 140'#---------------------FN_DYNVARS_001_10----------------------#' 141SET @@max_statement_time = 100; 142SELECT @@max_statement_time = @@local.max_statement_time; 143@@max_statement_time = @@local.max_statement_time 1441 145SELECT @@local.max_statement_time = @@session.max_statement_time; 146@@local.max_statement_time = @@session.max_statement_time 1471 148'#---------------------FN_DYNVARS_001_11----------------------#' 149SET max_statement_time = 1; 150SELECT @@max_statement_time; 151@@max_statement_time 1521.000000 153SELECT local.max_statement_time; 154ERROR 42S02: Unknown table 'local' in field list 155SELECT session.max_statement_time; 156ERROR 42S02: Unknown table 'session' in field list 157SELECT max_statement_time = @@session.max_statement_time; 158ERROR 42S22: Unknown column 'max_statement_time' in 'field list' 159# 160# Check that one can use max_statement_time as a field 161# 162drop table if exists t1; 163create table t1 (a int, max_statement_time int); 164drop table t1; 165SET @@global.max_statement_time = @start_global_value; 166SELECT @@global.max_statement_time; 167@@global.max_statement_time 1680.000000 169SET @@session.max_statement_time = @start_session_value; 170SELECT @@session.max_statement_time; 171@@session.max_statement_time 1720.000000 173