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