1SET @start_value = @@global.connect_timeout; 2SELECT @start_value; 3@start_value 460 5'#--------------------FN_DYNVARS_019_01------------------------#' 6SET @@global.connect_timeout = 100; 7SET @@global.connect_timeout = DEFAULT; 8SELECT @@global.connect_timeout; 9@@global.connect_timeout 1010 11'#---------------------FN_DYNVARS_019_02-------------------------#' 12SET @@global.connect_timeout = @start_value; 13SELECT @@global.connect_timeout = 5; 14@@global.connect_timeout = 5 150 16'#--------------------FN_DYNVARS_019_03------------------------#' 17SET @@global.connect_timeout = 2; 18SELECT @@global.connect_timeout; 19@@global.connect_timeout 202 21SET @@global.connect_timeout = 10000; 22SELECT @@global.connect_timeout; 23@@global.connect_timeout 2410000 25SET @@global.connect_timeout = 21221204; 26SELECT @@global.connect_timeout; 27@@global.connect_timeout 2821221204 29'#--------------------FN_DYNVARS_019_04-------------------------#' 30SET @@global.connect_timeout = 1; 31Warnings: 32Warning 1292 Truncated incorrect connect_timeout value: '1' 33SELECT @@global.connect_timeout; 34@@global.connect_timeout 352 36SET @@global.connect_timeout = -1024; 37Warnings: 38Warning 1292 Truncated incorrect connect_timeout value: '-1024' 39SELECT @@global.connect_timeout; 40@@global.connect_timeout 412 42SET @@global.connect_timeout = 42949672950; 43Warnings: 44Warning 1292 Truncated incorrect connect_timeout value: '42949672950' 45SELECT @@global.connect_timeout; 46@@global.connect_timeout 4731536000 48SET @@global.connect_timeout = 21221204.10; 49ERROR 42000: Incorrect argument type to variable 'connect_timeout' 50SET @@global.connect_timeout = ON; 51ERROR 42000: Incorrect argument type to variable 'connect_timeout' 52'#-------------------FN_DYNVARS_019_05----------------------------#' 53SET @@session.connect_timeout = 0; 54ERROR HY000: Variable 'connect_timeout' is a GLOBAL variable and should be set with SET GLOBAL 55SELECT @@session.connect_timeout; 56ERROR HY000: Variable 'connect_timeout' is a GLOBAL variable 57'#----------------------FN_DYNVARS_019_06------------------------#' 58SELECT @@global.connect_timeout = VARIABLE_VALUE 59FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 60WHERE VARIABLE_NAME='connect_timeout'; 61@@global.connect_timeout = VARIABLE_VALUE 621 63'#---------------------FN_DYNVARS_019_07----------------------#' 64SET @@global.connect_timeout = TRUE; 65Warnings: 66Warning 1292 Truncated incorrect connect_timeout value: '1' 67SELECT @@global.connect_timeout; 68@@global.connect_timeout 692 70SET @@global.connect_timeout = FALSE; 71Warnings: 72Warning 1292 Truncated incorrect connect_timeout value: '0' 73SELECT @@global.connect_timeout; 74@@global.connect_timeout 752 76'#---------------------FN_DYNVARS_019_08----------------------#' 77SET @@global.connect_timeout = 5; 78SELECT @@connect_timeout = @@global.connect_timeout; 79@@connect_timeout = @@global.connect_timeout 801 81'#---------------------FN_DYNVARS_019_09----------------------#' 82SET connect_timeout = 1; 83ERROR HY000: Variable 'connect_timeout' is a GLOBAL variable and should be set with SET GLOBAL 84SELECT global.connect_timeout; 85ERROR 42S02: Unknown table 'global' in field list 86SELECT connect_timeout = @@session.connect_timeout; 87ERROR 42S22: Unknown column 'connect_timeout' in 'field list' 88SET @@global.connect_timeout = @start_value; 89SELECT @@global.connect_timeout; 90@@global.connect_timeout 9160 92