1SET @@global.general_log= 0; 2SET @start_global_value = @@global.server_id_bits; 3SELECT @start_global_value; 4@start_global_value 532 6'#--------------------FN_DYNVARS_144_01-------------------------#' 7SET @@global.server_id_bits = 16; 8SET @@global.server_id_bits = DEFAULT; 9SELECT @@global.server_id_bits; 10@@global.server_id_bits 1132 12'#--------------------FN_DYNVARS_144_02-------------------------#' 13SET @@global.server_id_bits = DEFAULT; 14SELECT @@global.server_id_bits = 0; 15@@global.server_id_bits = 0 160 17'#--------------------FN_DYNVARS_144_03-------------------------#' 18SET @@global.server_id_bits = 0; 19SELECT @@global.server_id_bits; 20@@global.server_id_bits 210 22SET @@global.server_id_bits = 1; 23SELECT @@global.server_id_bits; 24@@global.server_id_bits 251 26SET @@global.server_id_bits = 15; 27SELECT @@global.server_id_bits; 28@@global.server_id_bits 2915 30SET @@global.server_id_bits = 31; 31SELECT @@global.server_id_bits; 32@@global.server_id_bits 3331 34SET @@global.server_id_bits = 32; 35SELECT @@global.server_id_bits; 36@@global.server_id_bits 3732 38'#--------------------FN_DYNVARS_144_04-------------------------#' 39SET @@server_id_bits = 2; 40ERROR HY000: Variable 'server_id_bits' is a GLOBAL variable and should be set with SET GLOBAL 41SET @@session.server_id_bits = 3; 42ERROR HY000: Variable 'server_id_bits' is a GLOBAL variable and should be set with SET GLOBAL 43SET @@local.server_id_bits = 4; 44ERROR HY000: Variable 'server_id_bits' is a GLOBAL variable and should be set with SET GLOBAL 45'#------------------FN_DYNVARS_144_05-----------------------#' 46SET @@global.server_id_bits = -1; 47Warnings: 48Warning 1292 Truncated incorrect server_id_bits value: '-1' 49SELECT @@global.server_id_bits; 50@@global.server_id_bits 510 52SET @@global.server_id_bits = -2147483648; 53Warnings: 54Warning 1292 Truncated incorrect server_id_bits value: '-2147483648' 55SELECT @@global.server_id_bits; 56@@global.server_id_bits 570 58SET @@global.server_id_bits = 2147483649*2; 59Warnings: 60Warning 1292 Truncated incorrect server_id_bits value: '4294967298' 61SELECT @@global.server_id_bits; 62@@global.server_id_bits 6332 64SET @@global.server_id_bits = 65530.34; 65ERROR 42000: Incorrect argument type to variable 'server_id_bits' 66SET @@global.server_id_bits = '125'; 67ERROR 42000: Incorrect argument type to variable 'server_id_bits' 68SET @@global.server_id_bits = 7483649.56; 69ERROR 42000: Incorrect argument type to variable 'server_id_bits' 70SET @@global.server_id_bits = 1G; 71ERROR 42000: Incorrect argument type to variable 'server_id_bits' 72'#------------------FN_DYNVARS_144_06-----------------------#' 73SET @@global.server_id_bits = 12; 74SELECT @@global.server_id_bits = VARIABLE_VALUE 75FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 76WHERE VARIABLE_NAME='server_id_bits'; 77@@global.server_id_bits = VARIABLE_VALUE 781 79'#------------------FN_DYNVARS_144_07-----------------------#' 80SELECT count(VARIABLE_VALUE) 81FROM INFORMATION_SCHEMA.SESSION_VARIABLES 82WHERE VARIABLE_NAME='server_id_bits'; 83count(VARIABLE_VALUE) 841 85'#------------------FN_DYNVARS_144_08-----------------------#' 86SET @@global.server_id_bits = TRUE; 87SELECT @@global.server_id_bits; 88@@global.server_id_bits 891 90SET @@global.server_id_bits = FALSE; 91SELECT @@global.server_id_bits; 92@@global.server_id_bits 930 94'#---------------------FN_DYNVARS_001_09----------------------#' 95SET @@global.server_id_bits = 19; 96SELECT @@server_id_bits = @@global.server_id_bits; 97@@server_id_bits = @@global.server_id_bits 981 99'#---------------------FN_DYNVARS_001_10----------------------#' 100SET server_id_bits = 2048; 101ERROR HY000: Variable 'server_id_bits' is a GLOBAL variable and should be set with SET GLOBAL 102SELECT server_id_bits; 103ERROR 42S22: Unknown column 'server_id_bits' in 'field list' 104SELECT @@server_id_bits; 105@@server_id_bits 10619 107SET global server_id_bits = 20; 108SET @@global.server_id_bits = @start_global_value; 109SELECT @@global.server_id_bits; 110@@global.server_id_bits 11132 112SET @@global.general_log= 1; 113