Debian Codegraph @

mysql-test/suite/sys_vars/r/server_id_bits_basic.result

raw
1 SET @@global.general_log= 0;
2 SET @start_global_value = @@global.server_id_bits;
3 SELECT @start_global_value;
4 @start_global_value
5 32
6 '#--------------------FN_DYNVARS_144_01-------------------------#'
7 SET @@global.server_id_bits = 16;
8 SET @@global.server_id_bits = DEFAULT;
9 SELECT @@global.server_id_bits;
10 @@global.server_id_bits
11 32
12 '#--------------------FN_DYNVARS_144_02-------------------------#'
13 SET @@global.server_id_bits = DEFAULT;
14 SELECT @@global.server_id_bits = 0;
15 @@global.server_id_bits = 0
16 0
17 '#--------------------FN_DYNVARS_144_03-------------------------#'
18 SET @@global.server_id_bits = 0;
19 SELECT @@global.server_id_bits;
20 @@global.server_id_bits
21 0
22 SET @@global.server_id_bits = 1;
23 SELECT @@global.server_id_bits;
24 @@global.server_id_bits
25 1
26 SET @@global.server_id_bits = 15;
27 SELECT @@global.server_id_bits;
28 @@global.server_id_bits
29 15
30 SET @@global.server_id_bits = 31;
31 SELECT @@global.server_id_bits;
32 @@global.server_id_bits
33 31
34 SET @@global.server_id_bits = 32;
35 SELECT @@global.server_id_bits;
36 @@global.server_id_bits
37 32
38 '#--------------------FN_DYNVARS_144_04-------------------------#'
39 SET @@server_id_bits = 2;
40 ERROR HY000: Variable 'server_id_bits' is a GLOBAL variable and should be set with SET GLOBAL
41 SET @@session.server_id_bits = 3;
42 ERROR HY000: Variable 'server_id_bits' is a GLOBAL variable and should be set with SET GLOBAL
43 SET @@local.server_id_bits = 4;
44 ERROR HY000: Variable 'server_id_bits' is a GLOBAL variable and should be set with SET GLOBAL
45 '#------------------FN_DYNVARS_144_05-----------------------#'
46 SET @@global.server_id_bits = -1;
47 Warnings:
48 Warning 1292 Truncated incorrect server_id_bits value: '-1'
49 SELECT @@global.server_id_bits;
50 @@global.server_id_bits
51 0
52 SET @@global.server_id_bits = -2147483648;
53 Warnings:
54 Warning 1292 Truncated incorrect server_id_bits value: '-2147483648'
55 SELECT @@global.server_id_bits;
56 @@global.server_id_bits
57 0
58 SET @@global.server_id_bits = 2147483649*2;
59 Warnings:
60 Warning 1292 Truncated incorrect server_id_bits value: '4294967298'
61 SELECT @@global.server_id_bits;
62 @@global.server_id_bits
63 32
64 SET @@global.server_id_bits = 65530.34;
65 ERROR 42000: Incorrect argument type to variable 'server_id_bits'
66 SET @@global.server_id_bits = '125';
67 ERROR 42000: Incorrect argument type to variable 'server_id_bits'
68 SET @@global.server_id_bits = 7483649.56;
69 ERROR 42000: Incorrect argument type to variable 'server_id_bits'
70 SET @@global.server_id_bits = 1G;
71 ERROR 42000: Incorrect argument type to variable 'server_id_bits'
72 '#------------------FN_DYNVARS_144_06-----------------------#'
73 SET @@global.server_id_bits = 12;
74 SELECT @@global.server_id_bits = VARIABLE_VALUE
75 FROM performance_schema.global_variables
76 WHERE VARIABLE_NAME='server_id_bits';
77 @@global.server_id_bits = VARIABLE_VALUE
78 1
79 '#------------------FN_DYNVARS_144_07-----------------------#'
80 SELECT count(VARIABLE_VALUE)
81 FROM performance_schema.session_variables
82 WHERE VARIABLE_NAME='server_id_bits';
83 count(VARIABLE_VALUE)
84 1
85 '#------------------FN_DYNVARS_144_08-----------------------#'
86 SET @@global.server_id_bits = TRUE;
87 SELECT @@global.server_id_bits;
88 @@global.server_id_bits
89 1
90 SET @@global.server_id_bits = FALSE;
91 SELECT @@global.server_id_bits;
92 @@global.server_id_bits
93 0
94 '#---------------------FN_DYNVARS_001_09----------------------#'
95 SET @@global.server_id_bits = 19;
96 SELECT @@server_id_bits = @@global.server_id_bits;
97 @@server_id_bits = @@global.server_id_bits
98 1
99 '#---------------------FN_DYNVARS_001_10----------------------#'
100 SET server_id_bits = 2048;
101 ERROR HY000: Variable 'server_id_bits' is a GLOBAL variable and should be set with SET GLOBAL
102 SELECT server_id_bits;
103 ERROR 42S22: Unknown column 'server_id_bits' in 'field list'
104 SELECT @@server_id_bits;
105 @@server_id_bits
106 19
107 SET global server_id_bits = 20;
108 SET @@global.server_id_bits = @start_global_value;
109 SELECT @@global.server_id_bits;
110 @@global.server_id_bits
111 32
112 SET @@global.general_log= 1;