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 = 39;
69 Warnings:
70 Warning 1292 Truncated incorrect div_precision_increment value: '39'
71 SELECT @@global.div_precision_increment;
72 @@global.div_precision_increment
73 38
74 SET @@global.div_precision_increment = 50;
75 Warnings:
76 Warning 1292 Truncated incorrect div_precision_increment value: '50'
77 SELECT @@global.div_precision_increment;
78 @@global.div_precision_increment
79 38
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 38
92 SET @@session.div_precision_increment = 50;
93 Warnings:
94 Warning 1292 Truncated incorrect div_precision_increment value: '50'
95 SELECT @@session.div_precision_increment;
96 @@session.div_precision_increment
97 38
98 SET @@session.div_precision_increment = 37;
99 SELECT @@session.div_precision_increment;
100 @@session.div_precision_increment
101 37
102 SET @@session.div_precision_increment = -2;
103 Warnings:
104 Warning 1292 Truncated incorrect div_precision_increment value: '-2'
105 SELECT @@session.div_precision_increment;
106 @@session.div_precision_increment
107 0
108 SET @@session.div_precision_increment = 65550;
109 Warnings:
110 Warning 1292 Truncated incorrect div_precision_increment value: '65550'
111 SELECT @@session.div_precision_increment;
112 @@session.div_precision_increment
113 38
114 SET @@global.div_precision_increment = 65530.30;
115 ERROR 42000: Incorrect argument type to variable 'div_precision_increment'
116 SELECT @@global.div_precision_increment;
117 @@global.div_precision_increment
118 38
119 SET @@global.div_precision_increment = OFF;
120 ERROR 42000: Incorrect argument type to variable 'div_precision_increment'
121 SELECT @@global.div_precision_increment;
122 @@global.div_precision_increment
123 38
124 SET @@session.div_precision_increment = ON;
125 ERROR 42000: Incorrect argument type to variable 'div_precision_increment'
126 SELECT @@session.div_precision_increment;
127 @@session.div_precision_increment
128 38
129 SET @@session.div_precision_increment = 65530.30;
130 ERROR 42000: Incorrect argument type to variable 'div_precision_increment'
131 SELECT @@session.div_precision_increment;
132 @@session.div_precision_increment
133 38
134 '#------------------FN_DYNVARS_027_06-----------------------#'
135 SELECT @@global.div_precision_increment = VARIABLE_VALUE
136 FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
137 WHERE VARIABLE_NAME='div_precision_increment';
138 @@global.div_precision_increment = VARIABLE_VALUE
139 1
140 '#------------------FN_DYNVARS_027_07-----------------------#'
141 SELECT @@session.div_precision_increment = VARIABLE_VALUE FROM INFORMATION_SCHEMA.SESSION_VARIABLES WHERE VARIABLE_NAME='div_precision_increment';
142 @@session.div_precision_increment = VARIABLE_VALUE
143 1
144 SET @@global.div_precision_increment = TRUE;
145 SELECT @@global.div_precision_increment;
146 @@global.div_precision_increment
147 1
148 SET @@global.div_precision_increment = FALSE;
149 SELECT @@global.div_precision_increment;
150 @@global.div_precision_increment
151 0
152 '#---------------------FN_DYNVARS_027_08----------------------#'
153 SET @@global.div_precision_increment = 0;
154 SELECT @@div_precision_increment = @@global.div_precision_increment;
155 @@div_precision_increment = @@global.div_precision_increment
156 0
157 '#---------------------FN_DYNVARS_027_09----------------------#'
158 SET @@div_precision_increment = 1;
159 SELECT @@div_precision_increment = @@local.div_precision_increment;
160 @@div_precision_increment = @@local.div_precision_increment
161 1
162 SELECT @@local.div_precision_increment = @@session.div_precision_increment;
163 @@local.div_precision_increment = @@session.div_precision_increment
164 1
165 '#---------------------FN_DYNVARS_027_10----------------------#'
166 SET div_precision_increment = 1;
167 SELECT @@div_precision_increment;
168 @@div_precision_increment
169 1
170 SELECT local.div_precision_increment;
171 ERROR 42S02: Unknown table 'local' in SELECT
172 SELECT session.div_precision_increment;
173 ERROR 42S02: Unknown table 'session' in SELECT
174 SELECT div_precision_increment = @@session.div_precision_increment;
175 ERROR 42S22: Unknown column 'div_precision_increment' in 'SELECT'
176 SET @@global.div_precision_increment = @start_global_value;
177 SELECT @@global.div_precision_increment;
178 @@global.div_precision_increment
179 4
180 SET @@session.div_precision_increment = @start_session_value;
181 SELECT @@session.div_precision_increment;
182 @@session.div_precision_increment
183 4