Debian Codegraph @

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

raw
1 SET @start_global_value = @@global.div_precision_increment;
2 SELECT @start_global_value;
3 @start_global_value
4 4
5 SET @start_session_value = @@session.div_precision_increment;
6 SELECT @start_session_value;
7 @start_session_value
8 4
9 '#--------------------FN_DYNVARS_027_01-------------------------#'
10 SET @@global.div_precision_increment = 100;
11 Warnings:
12 Warning 1292 Truncated incorrect div_precision_increment value: '100'
13 SET @@global.div_precision_increment = DEFAULT;
14 SELECT @@global.div_precision_increment;
15 @@global.div_precision_increment
16 4
17 SET @@session.div_precision_increment = 200;
18 Warnings:
19 Warning 1292 Truncated incorrect div_precision_increment value: '200'
20 SET @@session.div_precision_increment = DEFAULT;
21 SELECT @@session.div_precision_increment;
22 @@session.div_precision_increment
23 4
24 '#--------------------FN_DYNVARS_027_02-------------------------#'
25 SET @@global.div_precision_increment = @start_global_value;
26 SELECT @@global.div_precision_increment = 4;
27 @@global.div_precision_increment = 4
28 1
29 SET @@session.div_precision_increment = @start_session_value;
30 SELECT @@session.div_precision_increment = 4;
31 @@session.div_precision_increment = 4
32 1
33 '#--------------------FN_DYNVARS_027_03-------------------------#'
34 SET @@global.div_precision_increment = 1;
35 SELECT @@global.div_precision_increment;
36 @@global.div_precision_increment
37 1
38 SET @@global.div_precision_increment = 0;
39 SELECT @@global.div_precision_increment;
40 @@global.div_precision_increment
41 0
42 SET @@global.div_precision_increment = 10;
43 SELECT @@global.div_precision_increment;
44 @@global.div_precision_increment
45 10
46 SET @@global.div_precision_increment = 30;
47 SELECT @@global.div_precision_increment;
48 @@global.div_precision_increment
49 30
50 '#--------------------FN_DYNVARS_027_04-------------------------#'
51 SET @@session.div_precision_increment = 1;
52 SELECT @@session.div_precision_increment;
53 @@session.div_precision_increment
54 1
55 SET @@session.div_precision_increment = 0;
56 SELECT @@session.div_precision_increment;
57 @@session.div_precision_increment
58 0
59 SET @@session.div_precision_increment = 7;
60 SELECT @@session.div_precision_increment;
61 @@session.div_precision_increment
62 7
63 SET @@session.div_precision_increment = 30;
64 SELECT @@session.div_precision_increment;
65 @@session.div_precision_increment
66 30
67 '#------------------FN_DYNVARS_027_05-----------------------#'
68 SET @@global.div_precision_increment = 31;
69 Warnings:
70 Warning 1292 Truncated incorrect div_precision_increment value: '31'
71 SELECT @@global.div_precision_increment;
72 @@global.div_precision_increment
73 30
74 SET @@global.div_precision_increment = -1;
75 Warnings:
76 Warning 1292 Truncated incorrect div_precision_increment value: '-1'
77 SELECT @@global.div_precision_increment;
78 @@global.div_precision_increment
79 0
80 SET @@global.div_precision_increment = -1024;
81 Warnings:
82 Warning 1292 Truncated incorrect div_precision_increment value: '-1024'
83 SELECT @@global.div_precision_increment;
84 @@global.div_precision_increment
85 0
86 SET @@global.div_precision_increment = 65536;
87 Warnings:
88 Warning 1292 Truncated incorrect div_precision_increment value: '65536'
89 SELECT @@global.div_precision_increment;
90 @@global.div_precision_increment
91 30
92 SET @@session.div_precision_increment = -1;
93 Warnings:
94 Warning 1292 Truncated incorrect div_precision_increment value: '-1'
95 SELECT @@session.div_precision_increment;
96 @@session.div_precision_increment
97 0
98 SET @@session.div_precision_increment = 31;
99 Warnings:
100 Warning 1292 Truncated incorrect div_precision_increment value: '31'
101 SELECT @@session.div_precision_increment;
102 @@session.div_precision_increment
103 30
104 SET @@session.div_precision_increment = -1042;
105 Warnings:
106 Warning 1292 Truncated incorrect div_precision_increment value: '-1042'
107 SELECT @@session.div_precision_increment;
108 @@session.div_precision_increment
109 0
110 SET @@session.div_precision_increment = 65550;
111 Warnings:
112 Warning 1292 Truncated incorrect div_precision_increment value: '65550'
113 SELECT @@session.div_precision_increment;
114 @@session.div_precision_increment
115 30
116 SET @@global.div_precision_increment = 65530.30;
117 ERROR 42000: Incorrect argument type to variable 'div_precision_increment'
118 SELECT @@global.div_precision_increment;
119 @@global.div_precision_increment
120 30
121 SET @@global.div_precision_increment = OFF;
122 ERROR 42000: Incorrect argument type to variable 'div_precision_increment'
123 SELECT @@global.div_precision_increment;
124 @@global.div_precision_increment
125 30
126 SET @@session.div_precision_increment = ON;
127 ERROR 42000: Incorrect argument type to variable 'div_precision_increment'
128 SELECT @@session.div_precision_increment;
129 @@session.div_precision_increment
130 30
131 SET @@session.div_precision_increment = 65530.30;
132 ERROR 42000: Incorrect argument type to variable 'div_precision_increment'
133 SELECT @@session.div_precision_increment;
134 @@session.div_precision_increment
135 30
136 SELECT @@global.div_precision_increment;
137 @@global.div_precision_increment
138 30
139 SET @@global.div_precision_increment = " ";
140 ERROR 42000: Incorrect argument type to variable 'div_precision_increment'
141 SELECT @@global.div_precision_increment;
142 @@global.div_precision_increment
143 30
144 SET @@session.div_precision_increment = " ";
145 ERROR 42000: Incorrect argument type to variable 'div_precision_increment'
146 SELECT @@session.div_precision_increment;
147 @@session.div_precision_increment
148 30
149 '#------------------FN_DYNVARS_027_06-----------------------#'
150 SELECT @@global.div_precision_increment = VARIABLE_VALUE
151 FROM performance_schema.global_variables
152 WHERE VARIABLE_NAME='div_precision_increment';
153 @@global.div_precision_increment = VARIABLE_VALUE
154 1
155 '#------------------FN_DYNVARS_027_07-----------------------#'
156 SELECT @@session.div_precision_increment = VARIABLE_VALUE FROM performance_schema.session_variables WHERE VARIABLE_NAME='div_precision_increment';
157 @@session.div_precision_increment = VARIABLE_VALUE
158 1
159 SET @@global.div_precision_increment = TRUE;
160 SELECT @@global.div_precision_increment;
161 @@global.div_precision_increment
162 1
163 SET @@global.div_precision_increment = FALSE;
164 SELECT @@global.div_precision_increment;
165 @@global.div_precision_increment
166 0
167 '#---------------------FN_DYNVARS_027_08----------------------#'
168 SET @@global.div_precision_increment = 0;
169 SELECT @@div_precision_increment = @@global.div_precision_increment;
170 @@div_precision_increment = @@global.div_precision_increment
171 0
172 '#---------------------FN_DYNVARS_027_09----------------------#'
173 SET @@div_precision_increment = 1;
174 SELECT @@div_precision_increment = @@local.div_precision_increment;
175 @@div_precision_increment = @@local.div_precision_increment
176 1
177 SELECT @@local.div_precision_increment = @@session.div_precision_increment;
178 @@local.div_precision_increment = @@session.div_precision_increment
179 1
180 '#---------------------FN_DYNVARS_027_10----------------------#'
181 SET div_precision_increment = 1;
182 SELECT @@div_precision_increment;
183 @@div_precision_increment
184 1
185 SET local.div_precision_increment = 1;
186 ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'local.div_precision_increment = 1' at line 1
187 SELECT local.div_precision_increment;
188 ERROR 42S02: Unknown table 'local' in field list
189 SET session.div_precision_increment = 1;
190 ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'session.div_precision_increment = 1' at line 1
191 SELECT session.div_precision_increment;
192 ERROR 42S02: Unknown table 'session' in field list
193 SELECT div_precision_increment = @@session.div_precision_increment;
194 ERROR 42S22: Unknown column 'div_precision_increment' in 'field list'
195 SET @@global.div_precision_increment = @start_global_value;
196 SELECT @@global.div_precision_increment;
197 @@global.div_precision_increment
198 4
199 SET @@session.div_precision_increment = @start_session_value;
200 SELECT @@session.div_precision_increment;
201 @@session.div_precision_increment
202 4