1SET @start_global_value = @@global.interactive_timeout; 2SELECT @start_global_value; 3@start_global_value 428800 5SET @start_session_value = @@session.interactive_timeout; 6SELECT @start_session_value; 7@start_session_value 828800 9'#--------------------FN_DYNVARS_052_01-------------------------#' 10SET @@global.interactive_timeout = 100; 11SET @@global.interactive_timeout = DEFAULT; 12SELECT @@global.interactive_timeout; 13@@global.interactive_timeout 1428800 15SET @@session.interactive_timeout = 200; 16SET @@session.interactive_timeout = DEFAULT; 17SELECT @@session.interactive_timeout; 18@@session.interactive_timeout 1928800 20'#--------------------FN_DYNVARS_052_02-------------------------#' 21SET @@global.interactive_timeout = DEFAULT; 22SELECT @@global.interactive_timeout = 28800; 23@@global.interactive_timeout = 28800 241 25SET @@session.interactive_timeout = DEFAULT; 26SELECT @@session.interactive_timeout = 28800; 27@@session.interactive_timeout = 28800 281 29'#--------------------FN_DYNVARS_052_03-------------------------#' 30SET @@global.interactive_timeout = 1; 31SELECT @@global.interactive_timeout; 32@@global.interactive_timeout 331 34SET @@global.interactive_timeout = 60020; 35SELECT @@global.interactive_timeout; 36@@global.interactive_timeout 3760020 38SET @@global.interactive_timeout = 65535; 39SELECT @@global.interactive_timeout; 40@@global.interactive_timeout 4165535 42'#--------------------FN_DYNVARS_052_04-------------------------#' 43SET @@session.interactive_timeout = 1; 44SELECT @@session.interactive_timeout; 45@@session.interactive_timeout 461 47SET @@session.interactive_timeout = 50050; 48SELECT @@session.interactive_timeout; 49@@session.interactive_timeout 5050050 51SET @@session.interactive_timeout = 65535; 52SELECT @@session.interactive_timeout; 53@@session.interactive_timeout 5465535 55'#------------------FN_DYNVARS_052_05-----------------------#' 56SET @@global.interactive_timeout = 0; 57Warnings: 58Warning 1292 Truncated incorrect interactive_timeout value: '0' 59SELECT @@global.interactive_timeout; 60@@global.interactive_timeout 611 62SET @@global.interactive_timeout = -1024; 63Warnings: 64Warning 1292 Truncated incorrect interactive_timeout value: '-1024' 65SELECT @@global.interactive_timeout; 66@@global.interactive_timeout 671 68SET @@global.interactive_timeout = 1000000000; 69Warnings: 70Warning 1292 Truncated incorrect interactive_timeout value: '1000000000' 71SELECT @@global.interactive_timeout; 72@@global.interactive_timeout 7331536000 74SET @@global.interactive_timeout = 65530.34; 75ERROR 42000: Incorrect argument type to variable 'interactive_timeout' 76SELECT @@global.interactive_timeout; 77@@global.interactive_timeout 7831536000 79SET @@global.interactive_timeout = test; 80ERROR 42000: Incorrect argument type to variable 'interactive_timeout' 81SELECT @@global.interactive_timeout; 82@@global.interactive_timeout 8331536000 84SET @@session.interactive_timeout = 0; 85Warnings: 86Warning 1292 Truncated incorrect interactive_timeout value: '0' 87SELECT @@session.interactive_timeout; 88@@session.interactive_timeout 891 90SET @@session.interactive_timeout = -2; 91Warnings: 92Warning 1292 Truncated incorrect interactive_timeout value: '-2' 93SELECT @@session.interactive_timeout; 94@@session.interactive_timeout 951 96SET @@session.interactive_timeout = 65530.34; 97ERROR 42000: Incorrect argument type to variable 'interactive_timeout' 98SET @@session.interactive_timeout = 100000000; 99Warnings: 100Warning 1292 Truncated incorrect interactive_timeout value: '100000000' 101SELECT @@session.interactive_timeout; 102@@session.interactive_timeout 10331536000 104SET @@session.interactive_timeout = test; 105ERROR 42000: Incorrect argument type to variable 'interactive_timeout' 106SELECT @@session.interactive_timeout; 107@@session.interactive_timeout 10831536000 109'#------------------FN_DYNVARS_052_06-----------------------#' 110SELECT @@global.interactive_timeout = VARIABLE_VALUE 111FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 112WHERE VARIABLE_NAME='interactive_timeout'; 113@@global.interactive_timeout = VARIABLE_VALUE 1141 115'#------------------FN_DYNVARS_052_07-----------------------#' 116SELECT @@session.interactive_timeout = VARIABLE_VALUE 117FROM INFORMATION_SCHEMA.SESSION_VARIABLES 118WHERE VARIABLE_NAME='interactive_timeout'; 119@@session.interactive_timeout = VARIABLE_VALUE 1201 121'#------------------FN_DYNVARS_052_08-----------------------#' 122SET @@global.interactive_timeout = TRUE; 123SELECT @@global.interactive_timeout; 124@@global.interactive_timeout 1251 126SET @@global.interactive_timeout = FALSE; 127Warnings: 128Warning 1292 Truncated incorrect interactive_timeout value: '0' 129SELECT @@global.interactive_timeout; 130@@global.interactive_timeout 1311 132'#---------------------FN_DYNVARS_052_09----------------------#' 133SET @@global.interactive_timeout = 10; 134SELECT @@interactive_timeout = @@global.interactive_timeout; 135@@interactive_timeout = @@global.interactive_timeout 1360 137'#---------------------FN_DYNVARS_052_10----------------------#' 138SET @@interactive_timeout = 100; 139SELECT @@interactive_timeout = @@local.interactive_timeout; 140@@interactive_timeout = @@local.interactive_timeout 1411 142SELECT @@local.interactive_timeout = @@session.interactive_timeout; 143@@local.interactive_timeout = @@session.interactive_timeout 1441 145'#---------------------FN_DYNVARS_052_11----------------------#' 146SET interactive_timeout = 1; 147SELECT @@interactive_timeout; 148@@interactive_timeout 1491 150SELECT local.interactive_timeout; 151ERROR 42S02: Unknown table 'local' in field list 152SELECT session.interactive_timeout; 153ERROR 42S02: Unknown table 'session' in field list 154SELECT interactive_timeout = @@session.interactive_timeout; 155ERROR 42S22: Unknown column 'interactive_timeout' in 'field list' 156SET @@global.interactive_timeout = @start_global_value; 157SELECT @@global.interactive_timeout; 158@@global.interactive_timeout 15928800 160SET @@session.interactive_timeout = @start_session_value; 161SELECT @@session.interactive_timeout; 162@@session.interactive_timeout 16328800 164