Debian Codegraph @

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

raw
1 SET @start_global_value = @@global.max_error_count;
2 SELECT @start_global_value;
3 @start_global_value
4 64
5 SET @start_session_value = @@session.max_error_count;
6 SELECT @start_session_value;
7 @start_session_value
8 64
9 '#--------------------FN_DYNVARS_076_01-------------------------#'
10 SET @@global.max_error_count = 1000;
11 SET @@global.max_error_count = DEFAULT;
12 SELECT @@global.max_error_count;
13 @@global.max_error_count
14 64
15 SET @@session.max_error_count = 20000;
16 SET @@session.max_error_count = DEFAULT;
17 SELECT @@session.max_error_count;
18 @@session.max_error_count
19 64
20 '#--------------------FN_DYNVARS_076_02-------------------------#'
21 SET @@global.max_error_count = DEFAULT;
22 SELECT @@global.max_error_count = 64;
23 @@global.max_error_count = 64
24 1
25 SET @@session.max_error_count = DEFAULT;
26 SELECT @@session.max_error_count = 64;
27 @@session.max_error_count = 64
28 1
29 '#--------------------FN_DYNVARS_076_03-------------------------#'
30 SET @@global.max_error_count = 1;
31 SELECT @@global.max_error_count;
32 @@global.max_error_count
33 1
34 SET @@global.max_error_count = 0;
35 SELECT @@global.max_error_count;
36 @@global.max_error_count
37 0
38 SET @@global.max_error_count = 65535;
39 SELECT @@global.max_error_count;
40 @@global.max_error_count
41 65535
42 SET @@global.max_error_count = 65534;
43 SELECT @@global.max_error_count;
44 @@global.max_error_count
45 65534
46 '#--------------------FN_DYNVARS_076_04-------------------------#'
47 SET @@session.max_error_count = 0;
48 SELECT @@session.max_error_count;
49 @@session.max_error_count
50 0
51 SET @@session.max_error_count = 1;
52 SELECT @@session.max_error_count;
53 @@session.max_error_count
54 1
55 SET @@session.max_error_count = 65535;
56 SELECT @@session.max_error_count;
57 @@session.max_error_count
58 65535
59 SET @@session.max_error_count = 65534;
60 SELECT @@session.max_error_count;
61 @@session.max_error_count
62 65534
63 '#------------------FN_DYNVARS_076_05-----------------------#'
64 SET @@global.max_error_count = -1;
65 Warnings:
66 Warning 1292 Truncated incorrect max_error_count value: '-1'
67 SELECT @@global.max_error_count;
68 @@global.max_error_count
69 0
70 SET @@global.max_error_count = -1024;
71 Warnings:
72 Warning 1292 Truncated incorrect max_error_count value: '-1024'
73 SELECT @@global.max_error_count;
74 @@global.max_error_count
75 0
76 SET @@global.max_error_count = 65536;
77 Warnings:
78 Warning 1292 Truncated incorrect max_error_count value: '65536'
79 SELECT @@global.max_error_count;
80 @@global.max_error_count
81 65535
82 SET @@global.max_error_count = 10737418241;
83 Warnings:
84 Warning 1292 Truncated incorrect max_error_count value: '10737418241'
85 SELECT @@global.max_error_count;
86 @@global.max_error_count
87 65535
88 SET @@global.max_error_count = 65530.34;
89 ERROR 42000: Incorrect argument type to variable 'max_error_count'
90 SELECT @@global.max_error_count;
91 @@global.max_error_count
92 65535
93 SET @@global.max_error_count = test;
94 ERROR 42000: Incorrect argument type to variable 'max_error_count'
95 SELECT @@global.max_error_count;
96 @@global.max_error_count
97 65535
98 SET @@session.max_error_count = -1;
99 Warnings:
100 Warning 1292 Truncated incorrect max_error_count value: '-1'
101 SELECT @@session.max_error_count;
102 @@session.max_error_count
103 0
104 SET @@session.max_error_count = 65536;
105 Warnings:
106 SELECT @@session.max_error_count;
107 @@session.max_error_count
108 65535
109 SET @@session.max_error_count = -2;
110 Warnings:
111 Warning 1292 Truncated incorrect max_error_count value: '-2'
112 SELECT @@session.max_error_count;
113 @@session.max_error_count
114 0
115 SET @@session.max_error_count = 65530.34;
116 ERROR 42000: Incorrect argument type to variable 'max_error_count'
117 SET @@session.max_error_count = 10737418241;
118 Warnings:
119 SELECT @@session.max_error_count;
120 @@session.max_error_count
121 65535
122 SET @@session.max_error_count = test;
123 ERROR 42000: Incorrect argument type to variable 'max_error_count'
124 SELECT @@session.max_error_count;
125 @@session.max_error_count
126 65535
127 '#------------------FN_DYNVARS_076_06-----------------------#'
128 SELECT @@global.max_error_count = VARIABLE_VALUE
129 FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
130 WHERE VARIABLE_NAME='max_error_count';
131 @@global.max_error_count = VARIABLE_VALUE
132 1
133 '#------------------FN_DYNVARS_076_07-----------------------#'
134 SELECT @@session.max_error_count = VARIABLE_VALUE
135 FROM INFORMATION_SCHEMA.SESSION_VARIABLES
136 WHERE VARIABLE_NAME='max_error_count';
137 @@session.max_error_count = VARIABLE_VALUE
138 1
139 '#------------------FN_DYNVARS_076_08-----------------------#'
140 SET @@global.max_error_count = TRUE;
141 SELECT @@global.max_error_count;
142 @@global.max_error_count
143 1
144 SET @@global.max_error_count = FALSE;
145 SELECT @@global.max_error_count;
146 @@global.max_error_count
147 0
148 '#---------------------FN_DYNVARS_001_09----------------------#'
149 SET @@global.max_error_count = 2048;
150 SELECT @@max_error_count = @@global.max_error_count;
151 @@max_error_count = @@global.max_error_count
152 0
153 '#---------------------FN_DYNVARS_001_10----------------------#'
154 SET @@max_error_count = 60000;
155 SELECT @@max_error_count = @@local.max_error_count;
156 @@max_error_count = @@local.max_error_count
157 1
158 SELECT @@local.max_error_count = @@session.max_error_count;
159 @@local.max_error_count = @@session.max_error_count
160 1
161 '#---------------------FN_DYNVARS_001_11----------------------#'
162 SET max_error_count = 1024;
163 SELECT @@max_error_count;
164 @@max_error_count
165 1024
166 SELECT local.max_error_count;
167 ERROR 42S02: Unknown table 'local' in SELECT
168 SELECT session.max_error_count;
169 ERROR 42S02: Unknown table 'session' in SELECT
170 SELECT max_error_count = @@session.max_error_count;
171 ERROR 42S22: Unknown column 'max_error_count' in 'SELECT'
172 SET @@global.max_error_count = @start_global_value;
173 SELECT @@global.max_error_count;
174 @@global.max_error_count
175 64
176 SET @@session.max_error_count = @start_session_value;
177 SELECT @@session.max_error_count;
178 @@session.max_error_count
179 64