1SET @start_global_value = @@global.net_read_timeout; 2SELECT @start_global_value; 3@start_global_value 430 5SET @start_session_value = @@session.net_read_timeout; 6SELECT @start_session_value; 7@start_session_value 830 9'#--------------------FN_DYNVARS_110_01-------------------------#' 10SET @@global.net_read_timeout = 100; 11SET @@global.net_read_timeout = DEFAULT; 12SELECT @@global.net_read_timeout; 13@@global.net_read_timeout 1430 15SET @@session.net_read_timeout = 200; 16SET @@session.net_read_timeout = DEFAULT; 17SELECT @@session.net_read_timeout; 18@@session.net_read_timeout 1930 20'#--------------------FN_DYNVARS_110_02-------------------------#' 21SET @@global.net_read_timeout = DEFAULT; 22SELECT @@global.net_read_timeout = 30; 23@@global.net_read_timeout = 30 241 25SET @@session.net_read_timeout = DEFAULT; 26SELECT @@session.net_read_timeout = 30; 27@@session.net_read_timeout = 30 281 29'#--------------------FN_DYNVARS_110_03-------------------------#' 30SET @@global.net_read_timeout = 1; 31SELECT @@global.net_read_timeout; 32@@global.net_read_timeout 331 34SET @@global.net_read_timeout = 60020; 35SELECT @@global.net_read_timeout; 36@@global.net_read_timeout 3760020 38SET @@global.net_read_timeout = 65535; 39SELECT @@global.net_read_timeout; 40@@global.net_read_timeout 4165535 42'#--------------------FN_DYNVARS_110_04-------------------------#' 43SET @@session.net_read_timeout = 1; 44SELECT @@session.net_read_timeout; 45@@session.net_read_timeout 461 47SET @@session.net_read_timeout = 50050; 48SELECT @@session.net_read_timeout; 49@@session.net_read_timeout 5050050 51SET @@session.net_read_timeout = 65535; 52SELECT @@session.net_read_timeout; 53@@session.net_read_timeout 5465535 55'#------------------FN_DYNVARS_110_05-----------------------#' 56SET @@global.net_read_timeout = 0; 57Warnings: 58Warning 1292 Truncated incorrect net_read_timeout value: '0' 59SELECT @@global.net_read_timeout; 60@@global.net_read_timeout 611 62SET @@global.net_read_timeout = -1024; 63Warnings: 64Warning 1292 Truncated incorrect net_read_timeout value: '-1024' 65SELECT @@global.net_read_timeout; 66@@global.net_read_timeout 671 68SET @@global.net_read_timeout = 655360354; 69Warnings: 70Warning 1292 Truncated incorrect net_read_timeout value: '655360354' 71SELECT @@global.net_read_timeout; 72@@global.net_read_timeout 7331536000 74SET @@global.net_read_timeout = 65530.34; 75ERROR 42000: Incorrect argument type to variable 'net_read_timeout' 76SELECT @@global.net_read_timeout; 77@@global.net_read_timeout 7831536000 79SET @@global.net_read_timeout = test; 80ERROR 42000: Incorrect argument type to variable 'net_read_timeout' 81SELECT @@global.net_read_timeout; 82@@global.net_read_timeout 8331536000 84SET @@global.net_read_timeout = ' '; 85ERROR 42000: Incorrect argument type to variable 'net_read_timeout' 86SELECT @@global.net_read_timeout; 87@@global.net_read_timeout 8831536000 89SET @@session.net_read_timeout = 0; 90Warnings: 91Warning 1292 Truncated incorrect net_read_timeout value: '0' 92SELECT @@session.net_read_timeout; 93@@session.net_read_timeout 941 95SET @@session.net_read_timeout = -2; 96Warnings: 97Warning 1292 Truncated incorrect net_read_timeout value: '-2' 98SELECT @@session.net_read_timeout; 99@@session.net_read_timeout 1001 101SET @@session.net_read_timeout = 65530.34; 102ERROR 42000: Incorrect argument type to variable 'net_read_timeout' 103SET @@session.net_read_timeout = 6555015425; 104Warnings: 105Warning 1292 Truncated incorrect net_read_timeout value: '6555015425' 106SELECT @@session.net_read_timeout; 107@@session.net_read_timeout 10831536000 109SET @@session.net_read_timeout = test; 110ERROR 42000: Incorrect argument type to variable 'net_read_timeout' 111SELECT @@session.net_read_timeout; 112@@session.net_read_timeout 11331536000 114SET @@session.net_read_timeout = ' '; 115ERROR 42000: Incorrect argument type to variable 'net_read_timeout' 116SELECT @@session.net_read_timeout; 117@@session.net_read_timeout 11831536000 119'#------------------FN_DYNVARS_110_06-----------------------#' 120SELECT @@global.net_read_timeout = VARIABLE_VALUE 121FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 122WHERE VARIABLE_NAME='net_read_timeout'; 123@@global.net_read_timeout = VARIABLE_VALUE 1241 125'#------------------FN_DYNVARS_110_07-----------------------#' 126SELECT @@session.net_read_timeout = VARIABLE_VALUE 127FROM INFORMATION_SCHEMA.SESSION_VARIABLES 128WHERE VARIABLE_NAME='net_read_timeout'; 129@@session.net_read_timeout = VARIABLE_VALUE 1301 131'#------------------FN_DYNVARS_110_08-----------------------#' 132SET @@global.net_read_timeout = TRUE; 133SELECT @@global.net_read_timeout; 134@@global.net_read_timeout 1351 136SET @@global.net_read_timeout = FALSE; 137Warnings: 138Warning 1292 Truncated incorrect net_read_timeout value: '0' 139SELECT @@global.net_read_timeout; 140@@global.net_read_timeout 1411 142'#---------------------FN_DYNVARS_110_09----------------------#' 143SET @@global.net_read_timeout = 10; 144SELECT @@net_read_timeout = @@global.net_read_timeout; 145@@net_read_timeout = @@global.net_read_timeout 1460 147'#---------------------FN_DYNVARS_110_10----------------------#' 148SET @@net_read_timeout = 100; 149SELECT @@net_read_timeout = @@local.net_read_timeout; 150@@net_read_timeout = @@local.net_read_timeout 1511 152SELECT @@local.net_read_timeout = @@session.net_read_timeout; 153@@local.net_read_timeout = @@session.net_read_timeout 1541 155'#---------------------FN_DYNVARS_110_11----------------------#' 156SET net_read_timeout = 1; 157SELECT @@net_read_timeout; 158@@net_read_timeout 1591 160SELECT local.net_read_timeout; 161ERROR 42S02: Unknown table 'local' in field list 162SELECT session.net_read_timeout; 163ERROR 42S02: Unknown table 'session' in field list 164SELECT net_read_timeout = @@session.net_read_timeout; 165ERROR 42S22: Unknown column 'net_read_timeout' in 'field list' 166SET @@global.net_read_timeout = @start_global_value; 167SELECT @@global.net_read_timeout; 168@@global.net_read_timeout 16930 170SET @@session.net_read_timeout = @start_session_value; 171SELECT @@session.net_read_timeout; 172@@session.net_read_timeout 17330 174