1SET @start_global_value = @@global.net_retry_count; 2SELECT @start_global_value; 3@start_global_value 410 5SET @start_session_value = @@session.net_retry_count; 6SELECT @start_session_value; 7@start_session_value 810 9'#--------------------FN_DYNVARS_111_01-------------------------#' 10SET @@global.net_retry_count = 100; 11SET @@global.net_retry_count = DEFAULT; 12SELECT @@global.net_retry_count; 13@@global.net_retry_count 1410 15SET @@session.net_retry_count = 200; 16SET @@session.net_retry_count = DEFAULT; 17SELECT @@session.net_retry_count; 18@@session.net_retry_count 1910 20'#--------------------FN_DYNVARS_111_02-------------------------#' 21SET @@global.net_retry_count = DEFAULT; 22SELECT @@global.net_retry_count = 10; 23@@global.net_retry_count = 10 241 25SET @@session.net_retry_count = DEFAULT; 26SELECT @@session.net_retry_count = 10; 27@@session.net_retry_count = 10 281 29'#--------------------FN_DYNVARS_111_03-------------------------#' 30SET @@global.net_retry_count = 1; 31SELECT @@global.net_retry_count; 32@@global.net_retry_count 331 34SET @@global.net_retry_count = 2; 35SELECT @@global.net_retry_count; 36@@global.net_retry_count 372 38SET @@global.net_retry_count = 4294967295; 39SELECT @@global.net_retry_count; 40@@global.net_retry_count 414294967295 42SET @@global.net_retry_count = 4294967294; 43SELECT @@global.net_retry_count; 44@@global.net_retry_count 454294967294 46SET @@global.net_retry_count = 65536; 47SELECT @@global.net_retry_count; 48@@global.net_retry_count 4965536 50'#--------------------FN_DYNVARS_111_04-------------------------#' 51SET @@session.net_retry_count = 1; 52SELECT @@session.net_retry_count; 53@@session.net_retry_count 541 55SET @@session.net_retry_count = 2; 56SELECT @@session.net_retry_count; 57@@session.net_retry_count 582 59SET @@session.net_retry_count = 65535; 60SELECT @@session.net_retry_count; 61@@session.net_retry_count 6265535 63SET @@session.net_retry_count = 4294967295; 64SELECT @@session.net_retry_count; 65@@session.net_retry_count 664294967295 67SET @@session.net_retry_count = 4294967294; 68SELECT @@session.net_retry_count; 69@@session.net_retry_count 704294967294 71'#------------------FN_DYNVARS_111_05-----------------------#' 72SET @@global.net_retry_count = 0; 73Warnings: 74Warning 1292 Truncated incorrect net_retry_count value: '0' 75SELECT @@global.net_retry_count; 76@@global.net_retry_count 771 78SET @@global.net_retry_count = -1024; 79Warnings: 80Warning 1292 Truncated incorrect net_retry_count value: '-1024' 81SELECT @@global.net_retry_count; 82@@global.net_retry_count 831 84SET @@global.net_retry_count = 4294967296; 85Warnings: 86Warning 1292 Truncated incorrect net_retry_count value: '4294967296' 87SELECT @@global.net_retry_count; 88@@global.net_retry_count 894294967295 90SET @@global.net_retry_count = 429496729500; 91Warnings: 92Warning 1292 Truncated incorrect net_retry_count value: '429496729500' 93SELECT @@global.net_retry_count; 94@@global.net_retry_count 954294967295 96SET @@global.net_retry_count = 65530.34; 97ERROR 42000: Incorrect argument type to variable 'net_retry_count' 98SELECT @@global.net_retry_count; 99@@global.net_retry_count 1004294967295 101SET @@global.net_retry_count = test; 102ERROR 42000: Incorrect argument type to variable 'net_retry_count' 103SELECT @@global.net_retry_count; 104@@global.net_retry_count 1054294967295 106SET @@session.net_retry_count = 0; 107Warnings: 108Warning 1292 Truncated incorrect net_retry_count value: '0' 109SELECT @@session.net_retry_count; 110@@session.net_retry_count 1111 112SET @@session.net_retry_count = -2; 113Warnings: 114Warning 1292 Truncated incorrect net_retry_count value: '-2' 115SELECT @@session.net_retry_count; 116@@session.net_retry_count 1171 118SET @@session.net_retry_count = 65530.34; 119ERROR 42000: Incorrect argument type to variable 'net_retry_count' 120SET @@session.net_retry_count = 6555015425; 121Warnings: 122Warning 1292 Truncated incorrect net_retry_count value: '6555015425' 123SELECT @@session.net_retry_count; 124@@session.net_retry_count 1254294967295 126SET @@session.net_retry_count = 4294967296; 127Warnings: 128Warning 1292 Truncated incorrect net_retry_count value: '4294967296' 129SELECT @@session.net_retry_count; 130@@session.net_retry_count 1314294967295 132SET @@session.net_retry_count = test; 133ERROR 42000: Incorrect argument type to variable 'net_retry_count' 134SELECT @@session.net_retry_count; 135@@session.net_retry_count 1364294967295 137'#------------------FN_DYNVARS_111_06-----------------------#' 138SELECT @@global.net_retry_count = VARIABLE_VALUE 139FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 140WHERE VARIABLE_NAME='net_retry_count'; 141@@global.net_retry_count = VARIABLE_VALUE 1421 143'#------------------FN_DYNVARS_111_07-----------------------#' 144SELECT @@session.net_retry_count = VARIABLE_VALUE 145FROM INFORMATION_SCHEMA.SESSION_VARIABLES 146WHERE VARIABLE_NAME='net_retry_count'; 147@@session.net_retry_count = VARIABLE_VALUE 1481 149'#------------------FN_DYNVARS_111_08-----------------------#' 150SET @@global.net_retry_count = TRUE; 151SELECT @@global.net_retry_count; 152@@global.net_retry_count 1531 154SET @@global.net_retry_count = FALSE; 155Warnings: 156Warning 1292 Truncated incorrect net_retry_count value: '0' 157SELECT @@global.net_retry_count; 158@@global.net_retry_count 1591 160'#---------------------FN_DYNVARS_111_09----------------------#' 161SET @@global.net_retry_count = 10; 162SELECT @@net_retry_count = @@global.net_retry_count; 163@@net_retry_count = @@global.net_retry_count 1640 165'#---------------------FN_DYNVARS_111_10----------------------#' 166SET @@net_retry_count = 100; 167SELECT @@net_retry_count = @@local.net_retry_count; 168@@net_retry_count = @@local.net_retry_count 1691 170SELECT @@local.net_retry_count = @@session.net_retry_count; 171@@local.net_retry_count = @@session.net_retry_count 1721 173'#---------------------FN_DYNVARS_111_11----------------------#' 174SET net_retry_count = 1; 175SELECT @@net_retry_count; 176@@net_retry_count 1771 178SELECT local.net_retry_count; 179ERROR 42S02: Unknown table 'local' in field list 180SELECT session.net_retry_count; 181ERROR 42S02: Unknown table 'session' in field list 182SELECT net_retry_count = @@session.net_retry_count; 183ERROR 42S22: Unknown column 'net_retry_count' in 'field list' 184SET @@global.net_retry_count = @start_global_value; 185SELECT @@global.net_retry_count; 186@@global.net_retry_count 18710 188SET @@session.net_retry_count = @start_session_value; 189SELECT @@session.net_retry_count; 190@@session.net_retry_count 19110 192