Debian Codegraph @

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

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