1SET @start_global_value = @@global.net_write_timeout; 2SELECT @start_global_value; 3@start_global_value 460 5SET @start_session_value = @@session.net_write_timeout; 6SELECT @start_session_value; 7@start_session_value 860 9'#--------------------FN_DYNVARS_112_01-------------------------#' 10SET @@global.net_write_timeout = 100; 11SET @@global.net_write_timeout = DEFAULT; 12SELECT @@global.net_write_timeout; 13@@global.net_write_timeout 1460 15SET @@session.net_write_timeout = 200; 16SET @@session.net_write_timeout = DEFAULT; 17SELECT @@session.net_write_timeout; 18@@session.net_write_timeout 1960 20'#--------------------FN_DYNVARS_112_02-------------------------#' 21SET @@global.net_write_timeout = DEFAULT; 22SELECT @@global.net_write_timeout = 60; 23@@global.net_write_timeout = 60 241 25SET @@session.net_write_timeout = DEFAULT; 26SELECT @@session.net_write_timeout = 60; 27@@session.net_write_timeout = 60 281 29'#--------------------FN_DYNVARS_112_03-------------------------#' 30SET @@global.net_write_timeout = 1; 31SELECT @@global.net_write_timeout; 32@@global.net_write_timeout 331 34SET @@global.net_write_timeout = 60020; 35SELECT @@global.net_write_timeout; 36@@global.net_write_timeout 3760020 38SET @@global.net_write_timeout = 65535; 39SELECT @@global.net_write_timeout; 40@@global.net_write_timeout 4165535 42'#--------------------FN_DYNVARS_112_04-------------------------#' 43SET @@session.net_write_timeout = 1; 44SELECT @@session.net_write_timeout; 45@@session.net_write_timeout 461 47SET @@session.net_write_timeout = 50050; 48SELECT @@session.net_write_timeout; 49@@session.net_write_timeout 5050050 51SET @@session.net_write_timeout = 65535; 52SELECT @@session.net_write_timeout; 53@@session.net_write_timeout 5465535 55'#------------------FN_DYNVARS_112_05-----------------------#' 56SET @@global.net_write_timeout = 0; 57Warnings: 58Warning 1292 Truncated incorrect net_write_timeout value: '0' 59SELECT @@global.net_write_timeout; 60@@global.net_write_timeout 611 62SET @@global.net_write_timeout = -1024; 63Warnings: 64Warning 1292 Truncated incorrect net_write_timeout value: '-1024' 65SELECT @@global.net_write_timeout; 66@@global.net_write_timeout 671 68SET @@global.net_write_timeout = 655360354; 69Warnings: 70Warning 1292 Truncated incorrect net_write_timeout value: '655360354' 71SELECT @@global.net_write_timeout; 72@@global.net_write_timeout 7331536000 74SET @@global.net_write_timeout = 65530.34; 75ERROR 42000: Incorrect argument type to variable 'net_write_timeout' 76SELECT @@global.net_write_timeout; 77@@global.net_write_timeout 7831536000 79SET @@global.net_write_timeout = test; 80ERROR 42000: Incorrect argument type to variable 'net_write_timeout' 81SELECT @@global.net_write_timeout; 82@@global.net_write_timeout 8331536000 84SET @@global.net_write_timeout = ' '; 85ERROR 42000: Incorrect argument type to variable 'net_write_timeout' 86SELECT @@global.net_write_timeout; 87@@global.net_write_timeout 8831536000 89SET @@session.net_write_timeout = 0; 90Warnings: 91Warning 1292 Truncated incorrect net_write_timeout value: '0' 92SELECT @@session.net_write_timeout; 93@@session.net_write_timeout 941 95SET @@session.net_write_timeout = -2; 96Warnings: 97Warning 1292 Truncated incorrect net_write_timeout value: '-2' 98SELECT @@session.net_write_timeout; 99@@session.net_write_timeout 1001 101SET @@session.net_write_timeout = 65530.34; 102ERROR 42000: Incorrect argument type to variable 'net_write_timeout' 103SET @@session.net_write_timeout = 6555015425; 104Warnings: 105Warning 1292 Truncated incorrect net_write_timeout value: '6555015425' 106SELECT @@session.net_write_timeout; 107@@session.net_write_timeout 10831536000 109SET @@session.net_write_timeout = test; 110ERROR 42000: Incorrect argument type to variable 'net_write_timeout' 111SELECT @@session.net_write_timeout; 112@@session.net_write_timeout 11331536000 114SET @@session.net_write_timeout = ' '; 115ERROR 42000: Incorrect argument type to variable 'net_write_timeout' 116SELECT @@session.net_write_timeout; 117@@session.net_write_timeout 11831536000 119'#------------------FN_DYNVARS_112_06-----------------------#' 120SELECT @@global.net_write_timeout = VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE_NAME='net_write_timeout'; 121@@global.net_write_timeout = VARIABLE_VALUE 1221 123'#------------------FN_DYNVARS_112_07-----------------------#' 124SELECT @@session.net_write_timeout = VARIABLE_VALUE FROM INFORMATION_SCHEMA.SESSION_VARIABLES WHERE VARIABLE_NAME='net_write_timeout'; 125@@session.net_write_timeout = VARIABLE_VALUE 1261 127'#------------------FN_DYNVARS_112_08-----------------------#' 128SET @@global.net_write_timeout = TRUE; 129SELECT @@global.net_write_timeout; 130@@global.net_write_timeout 1311 132SET @@global.net_write_timeout = FALSE; 133Warnings: 134Warning 1292 Truncated incorrect net_write_timeout value: '0' 135SELECT @@global.net_write_timeout; 136@@global.net_write_timeout 1371 138'#---------------------FN_DYNVARS_112_09----------------------#' 139SET @@global.net_write_timeout = 10; 140SELECT @@net_write_timeout = @@global.net_write_timeout; 141@@net_write_timeout = @@global.net_write_timeout 1420 143'#---------------------FN_DYNVARS_112_10----------------------#' 144SET @@net_write_timeout = 100; 145SELECT @@net_write_timeout = @@local.net_write_timeout; 146@@net_write_timeout = @@local.net_write_timeout 1471 148SELECT @@local.net_write_timeout = @@session.net_write_timeout; 149@@local.net_write_timeout = @@session.net_write_timeout 1501 151'#---------------------FN_DYNVARS_112_11----------------------#' 152SET net_write_timeout = 1; 153SELECT @@net_write_timeout; 154@@net_write_timeout 1551 156SELECT local.net_write_timeout; 157ERROR 42S02: Unknown table 'local' in field list 158SELECT session.net_write_timeout; 159ERROR 42S02: Unknown table 'session' in field list 160SELECT net_write_timeout = @@session.net_write_timeout; 161ERROR 42S22: Unknown column 'net_write_timeout' in 'field list' 162SET @@global.net_write_timeout = @start_global_value; 163SELECT @@global.net_write_timeout; 164@@global.net_write_timeout 16560 166SET @@session.net_write_timeout = @start_session_value; 167SELECT @@session.net_write_timeout; 168@@session.net_write_timeout 16960 170