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 Warnings:
20 Warning 1292 Truncated incorrect server_id value: '0'
21 SELECT @@global.server_id;
22 @@global.server_id
23 1
24 SET @@global.server_id = 1;
25 SELECT @@global.server_id;
26 @@global.server_id
27 1
28 SET @@global.server_id = 15;
29 SELECT @@global.server_id;
30 @@global.server_id
31 15
32 SET @@global.server_id = 1024;
33 SELECT @@global.server_id;
34 @@global.server_id
35 1024
36 SET @@global.server_id = 123456789;
37 SELECT @@global.server_id;
38 @@global.server_id
39 123456789
40 SET @@global.server_id = 2147483648;
41 SELECT @@global.server_id;
42 @@global.server_id
43 2147483648
44 SET @@global.server_id = 2147483648*2-1;
45 SELECT @@global.server_id;
46 @@global.server_id
47 4294967295
48 '#--------------------FN_DYNVARS_144_04-------------------------#'
49 SELECT @@server_id;
50 @@server_id
51 4294967295
52 SET @@server_id = 2;
53 SELECT @@server_id;
54 @@server_id
55 2
56 SET @@session.server_id = 3;
57 SELECT @@server_id;
58 @@server_id
59 3
60 SET @@local.server_id = 4;
61 '#------------------FN_DYNVARS_144_05-----------------------#'
62 SET @@global.server_id = -1;
63 Warnings:
64 Warning 1292 Truncated incorrect server_id value: '-1'
65 SELECT @@global.server_id;
66 @@global.server_id
67 1
68 SET @@global.server_id = -2147483648;
69 Warnings:
70 Warning 1292 Truncated incorrect server_id value: '-2147483648'
71 SELECT @@global.server_id;
72 @@global.server_id
73 1
74 SET @@global.server_id = 2147483649*2;
75 Warnings:
76 Warning 1292 Truncated incorrect server_id value: '4294967298'
77 SELECT @@global.server_id;
78 @@global.server_id
79 4294967295
80 SET @@global.server_id = 65530.34;
81 ERROR 42000: Incorrect argument type to variable 'server_id'
82 SET @@global.server_id = '125';
83 ERROR 42000: Incorrect argument type to variable 'server_id'
84 SET @@global.server_id = 7483649.56;
85 ERROR 42000: Incorrect argument type to variable 'server_id'
86 SET @@global.server_id = 1G;
87 ERROR 42000: Incorrect argument type to variable 'server_id'
88 '#------------------FN_DYNVARS_144_06-----------------------#'
89 SET @@global.server_id = 3000;
90 SELECT @@global.server_id = VARIABLE_VALUE
91 FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
92 WHERE VARIABLE_NAME='server_id';
93 @@global.server_id = VARIABLE_VALUE
94 1
95 '#------------------FN_DYNVARS_144_07-----------------------#'
96 SELECT count(VARIABLE_VALUE)
97 FROM INFORMATION_SCHEMA.SESSION_VARIABLES
98 WHERE VARIABLE_NAME='server_id';
99 count(VARIABLE_VALUE)
100 1
101 '#------------------FN_DYNVARS_144_08-----------------------#'
102 SET @@global.server_id = TRUE;
103 SELECT @@global.server_id;
104 @@global.server_id
105 1
106 SET @@global.server_id = FALSE;
107 Warnings:
108 Warning 1292 Truncated incorrect server_id value: '0'
109 SELECT @@global.server_id;
110 @@global.server_id
111 1
112 '#---------------------FN_DYNVARS_001_09----------------------#'
113 SET @@global.server_id = 512;
114 SELECT @@server_id = @@global.server_id;
115 @@server_id = @@global.server_id
116 1
117 '#---------------------FN_DYNVARS_001_10----------------------#'
118 SET server_id = 2048;
119 SELECT server_id;
120 ERROR 42S22: Unknown column 'server_id' in 'SELECT'
121 SELECT @@server_id;
122 @@server_id
123 2048
124 SET global server_id = 99;
125 SET @@global.server_id = @start_global_value;
126 SELECT @@global.server_id;
127 @@global.server_id
128 1
129 SET @@global.general_log= 1;