Merge lp://staging/~diego-fmpwizard/drizzle/plugin-functions-error-messages into lp://staging/~drizzle-trunk/drizzle/development
- plugin-functions-error-messages
- Merge into development
Status: | Merged |
---|---|
Approved by: | Jay Pipes |
Approved revision: | 1126 |
Merged at revision: | not available |
Proposed branch: | lp://staging/~diego-fmpwizard/drizzle/plugin-functions-error-messages |
Merge into: | lp://staging/~drizzle-trunk/drizzle/development |
Diff against target: | None lines |
To merge this branch: | bzr merge lp://staging/~diego-fmpwizard/drizzle/plugin-functions-error-messages |
Related bugs: | |
Related blueprints: |
Reviewer | Review Type | Date Requested | Status |
---|---|---|---|
Stewart Smith (community) | Approve | ||
Monty Taylor | Approve | ||
Review via email: mp+10680@code.staging.launchpad.net |
This proposal supersedes a proposal from 2009-08-25.
Commit message
Description of the change
fmpwizard (diego-fmpwizard) wrote : Posted in a previous version of this proposal | # |
Monty Taylor (mordred) wrote : Posted in a previous version of this proposal | # |
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Could we change the error message and remove the word native? For that
matter, renaming the define from ER_WRONG_
ER_WRONG_
going to end up with a real distinction between native and non-native
functions anymore.
fmpwizard wrote:
> fmpwizard has proposed merging lp:~diego-fmpwizard/drizzle/plugin-functions-error-messages into lp:drizzle.
>
> Requested reviews:
> Drizzle-developers (drizzle-
>
> UDF plugin functions and built-in function use the same error message when they both receive an incorrect number of parameters.
>
> See https:/
>
>
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://
iEYEARECAAYFAkq
4m8AnRn5B4jGP6q
=K8RJ
-----END PGP SIGNATURE-----
fmpwizard (diego-fmpwizard) wrote : Posted in a previous version of this proposal | # |
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Could we change the error message and remove the word native? For that
> matter, renaming the define from ER_WRONG_
> ER_WRONG_
> going to end up with a real distinction between native and non-native
> functions anymore.
>
Sounds good, I'll rename them to ER_WRONG_
Thanks
-Diego
> fmpwizard wrote:
> > fmpwizard has proposed merging lp:~diego-fmpwizard/drizzle/plugin-functions-
> error-messages into lp:drizzle.
> >
> > Requested reviews:
> > Drizzle-developers (drizzle-
> >
> > UDF plugin functions and built-in function use the same error message when
> they both receive an incorrect number of parameters.
> >
> > See https:/
> consistent-errors for more information.
> >
> >
>
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.9 (GNU/Linux)
> Comment: Using GnuPG with Mozilla - http://
>
> iEYEARECAAYFAkq
> 4m8AnRn5B4jGP6q
> =K8RJ
> -----END PGP SIGNATURE-----
Monty Taylor (mordred) wrote : | # |
Love it. Merging.
Stewart Smith (stewart) : | # |
Preview Diff
1 | === modified file 'client/errname.cc' |
2 | --- client/errname.cc 2009-08-05 22:50:03 +0000 |
3 | +++ client/errname.cc 2009-08-25 18:22:32 +0000 |
4 | @@ -615,7 +615,7 @@ |
5 | { "ER_UNSUPORTED_LOG_ENGINE",1579 }, |
6 | { "ER_BAD_LOG_STATEMENT",1580 }, |
7 | { "ER_CANT_RENAME_LOG_TABLE",1581 }, |
8 | - { "ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT",1582 }, |
9 | + { "ER_WRONG_PARAMCOUNT_TO_FUNCTION",1582 }, |
10 | { "ER_WRONG_PARAMETERS_TO_NATIVE_FCT",1583 }, |
11 | { "ER_WRONG_PARAMETERS_TO_STORED_FCT",1584 }, |
12 | { "ER_NATIVE_FCT_NAME_COLLISION",1585 }, |
13 | |
14 | === modified file 'drizzled/error.cc' |
15 | --- drizzled/error.cc 2009-06-26 06:25:57 +0000 |
16 | +++ drizzled/error.cc 2009-08-25 18:22:32 +0000 |
17 | @@ -1194,7 +1194,7 @@ |
18 | N_("You cannot '%s' a log table if logging is enabled"), |
19 | /* ER_CANT_RENAME_LOG_TABLE */ |
20 | N_("Cannot rename '%s'. When logging enabled, rename to/from log table must rename two tables: the log table to an archive table and another table back to '%s'"), |
21 | -/* ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT 42000 */ |
22 | +/* ER_WRONG_PARAMCOUNT_TO_FUNCTION 42000 */ |
23 | N_("Incorrect parameter count in the call to native function '%-.192s'"), |
24 | /* ER_WRONG_PARAMETERS_TO_NATIVE_FCT 42000 */ |
25 | N_("Incorrect parameters in the call to native function '%-.192s'"), |
26 | |
27 | === modified file 'drizzled/error.h' |
28 | --- drizzled/error.h 2009-06-16 03:02:59 +0000 |
29 | +++ drizzled/error.h 2009-08-25 18:22:32 +0000 |
30 | @@ -611,7 +611,7 @@ |
31 | ER_UNSUPORTED_LOG_ENGINE, |
32 | ER_BAD_LOG_STATEMENT, |
33 | ER_CANT_RENAME_LOG_TABLE, |
34 | - ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT, |
35 | + ER_WRONG_PARAMCOUNT_TO_FUNCTION, |
36 | ER_WRONG_PARAMETERS_TO_NATIVE_FCT, |
37 | ER_WRONG_PARAMETERS_TO_STORED_FCT, |
38 | ER_NATIVE_FCT_NAME_COLLISION, |
39 | |
40 | === modified file 'drizzled/item/create.cc' |
41 | --- drizzled/item/create.cc 2009-08-17 20:54:05 +0000 |
42 | +++ drizzled/item/create.cc 2009-08-25 18:22:32 +0000 |
43 | @@ -1480,7 +1480,7 @@ |
44 | |
45 | if(!func->check_argument_count(arg_count)) |
46 | { |
47 | - my_error(ER_WRONG_PARAMETERS_TO_NATIVE_FCT, MYF(0), func->func_name()); |
48 | + my_error(ER_WRONG_PARAMCOUNT_TO_FUNCTION, MYF(0), func->func_name()); |
49 | return NULL; |
50 | } |
51 | |
52 | @@ -1514,7 +1514,7 @@ |
53 | |
54 | if (arg_count != 0) |
55 | { |
56 | - my_error(ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT, MYF(0), name.str); |
57 | + my_error(ER_WRONG_PARAMCOUNT_TO_FUNCTION, MYF(0), name.str); |
58 | return NULL; |
59 | } |
60 | |
61 | @@ -1532,7 +1532,7 @@ |
62 | |
63 | if (arg_count != 1) |
64 | { |
65 | - my_error(ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT, MYF(0), name.str); |
66 | + my_error(ER_WRONG_PARAMCOUNT_TO_FUNCTION, MYF(0), name.str); |
67 | return NULL; |
68 | } |
69 | |
70 | @@ -1558,7 +1558,7 @@ |
71 | |
72 | if (arg_count != 2) |
73 | { |
74 | - my_error(ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT, MYF(0), name.str); |
75 | + my_error(ER_WRONG_PARAMCOUNT_TO_FUNCTION, MYF(0), name.str); |
76 | return NULL; |
77 | } |
78 | |
79 | @@ -1586,7 +1586,7 @@ |
80 | |
81 | if (arg_count != 3) |
82 | { |
83 | - my_error(ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT, MYF(0), name.str); |
84 | + my_error(ER_WRONG_PARAMCOUNT_TO_FUNCTION, MYF(0), name.str); |
85 | return NULL; |
86 | } |
87 | |
88 | @@ -1660,7 +1660,7 @@ |
89 | } |
90 | default: |
91 | { |
92 | - my_error(ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT, MYF(0), name.str); |
93 | + my_error(ER_WRONG_PARAMCOUNT_TO_FUNCTION, MYF(0), name.str); |
94 | break; |
95 | } |
96 | } |
97 | @@ -1710,7 +1710,7 @@ |
98 | |
99 | if (arg_count < 1) |
100 | { |
101 | - my_error(ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT, MYF(0), name.str); |
102 | + my_error(ER_WRONG_PARAMCOUNT_TO_FUNCTION, MYF(0), name.str); |
103 | return NULL; |
104 | } |
105 | |
106 | @@ -1732,7 +1732,7 @@ |
107 | /* "WS" stands for "With Separator": this function takes 2+ arguments */ |
108 | if (arg_count < 2) |
109 | { |
110 | - my_error(ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT, MYF(0), name.str); |
111 | + my_error(ER_WRONG_PARAMCOUNT_TO_FUNCTION, MYF(0), name.str); |
112 | return NULL; |
113 | } |
114 | |
115 | @@ -1848,7 +1848,7 @@ |
116 | |
117 | if (arg_count < 2) |
118 | { |
119 | - my_error(ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT, MYF(0), name.str); |
120 | + my_error(ER_WRONG_PARAMCOUNT_TO_FUNCTION, MYF(0), name.str); |
121 | return NULL; |
122 | } |
123 | |
124 | @@ -1909,7 +1909,7 @@ |
125 | } |
126 | default: |
127 | { |
128 | - my_error(ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT, MYF(0), name.str); |
129 | + my_error(ER_WRONG_PARAMCOUNT_TO_FUNCTION, MYF(0), name.str); |
130 | break; |
131 | } |
132 | } |
133 | @@ -1931,7 +1931,7 @@ |
134 | |
135 | if (arg_count < 2) |
136 | { |
137 | - my_error(ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT, MYF(0), name.str); |
138 | + my_error(ER_WRONG_PARAMCOUNT_TO_FUNCTION, MYF(0), name.str); |
139 | return NULL; |
140 | } |
141 | |
142 | @@ -2013,7 +2013,7 @@ |
143 | } |
144 | default: |
145 | { |
146 | - my_error(ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT, MYF(0), name.str); |
147 | + my_error(ER_WRONG_PARAMCOUNT_TO_FUNCTION, MYF(0), name.str); |
148 | break; |
149 | } |
150 | } |
151 | @@ -2035,7 +2035,7 @@ |
152 | |
153 | if (arg_count < 2) |
154 | { |
155 | - my_error(ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT, MYF(0), name.str); |
156 | + my_error(ER_WRONG_PARAMCOUNT_TO_FUNCTION, MYF(0), name.str); |
157 | return NULL; |
158 | } |
159 | |
160 | @@ -2114,7 +2114,7 @@ |
161 | } |
162 | default: |
163 | { |
164 | - my_error(ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT, MYF(0), name.str); |
165 | + my_error(ER_WRONG_PARAMCOUNT_TO_FUNCTION, MYF(0), name.str); |
166 | break; |
167 | } |
168 | } |
169 | @@ -2145,7 +2145,7 @@ |
170 | |
171 | if (arg_count < 2) |
172 | { |
173 | - my_error(ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT, MYF(0), name.str); |
174 | + my_error(ER_WRONG_PARAMCOUNT_TO_FUNCTION, MYF(0), name.str); |
175 | return NULL; |
176 | } |
177 | |
178 | @@ -2203,7 +2203,7 @@ |
179 | } |
180 | default: |
181 | { |
182 | - my_error(ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT, MYF(0), name.str); |
183 | + my_error(ER_WRONG_PARAMCOUNT_TO_FUNCTION, MYF(0), name.str); |
184 | break; |
185 | } |
186 | } |
187 | @@ -2240,7 +2240,7 @@ |
188 | } |
189 | default: |
190 | { |
191 | - my_error(ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT, MYF(0), name.str); |
192 | + my_error(ER_WRONG_PARAMCOUNT_TO_FUNCTION, MYF(0), name.str); |
193 | break; |
194 | } |
195 | } |
196 | @@ -2307,7 +2307,7 @@ |
197 | |
198 | if (arg_count < 2) |
199 | { |
200 | - my_error(ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT, MYF(0), name.str); |
201 | + my_error(ER_WRONG_PARAMCOUNT_TO_FUNCTION, MYF(0), name.str); |
202 | return NULL; |
203 | } |
204 | |
205 | @@ -2435,7 +2435,7 @@ |
206 | } |
207 | default: |
208 | { |
209 | - my_error(ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT, MYF(0), name.str); |
210 | + my_error(ER_WRONG_PARAMCOUNT_TO_FUNCTION, MYF(0), name.str); |
211 | break; |
212 | } |
213 | } |
214 | @@ -2473,7 +2473,7 @@ |
215 | } |
216 | default: |
217 | { |
218 | - my_error(ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT, MYF(0), name.str); |
219 | + my_error(ER_WRONG_PARAMCOUNT_TO_FUNCTION, MYF(0), name.str); |
220 | break; |
221 | } |
222 | } |
223 | @@ -2651,7 +2651,7 @@ |
224 | } |
225 | default: |
226 | { |
227 | - my_error(ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT, MYF(0), name.str); |
228 | + my_error(ER_WRONG_PARAMCOUNT_TO_FUNCTION, MYF(0), name.str); |
229 | break; |
230 | } |
231 | } |
232 | |
233 | === modified file 'drizzled/sql_state.cc' |
234 | --- drizzled/sql_state.cc 2009-07-07 09:06:29 +0000 |
235 | +++ drizzled/sql_state.cc 2009-08-25 18:22:32 +0000 |
236 | @@ -240,7 +240,7 @@ |
237 | { ER_NON_GROUPING_FIELD_USED ,"42000", "" }, |
238 | { ER_FOREIGN_DUPLICATE_KEY ,"23000", "S1009" }, |
239 | { ER_CANT_CHANGE_TX_ISOLATION ,"25001", "" }, |
240 | - { ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT ,"42000", "" }, |
241 | + { ER_WRONG_PARAMCOUNT_TO_FUNCTION ,"42000", "" }, |
242 | { ER_WRONG_PARAMETERS_TO_NATIVE_FCT ,"42000", "" }, |
243 | { ER_WRONG_PARAMETERS_TO_STORED_FCT ,"42000", "" }, |
244 | { ER_DUP_ENTRY_WITH_KEY_NAME ,"23000", "S1009" }, |
245 | |
246 | === modified file 'tests/r/crc32.result' |
247 | --- tests/r/crc32.result 2009-06-09 03:59:56 +0000 |
248 | +++ tests/r/crc32.result 2009-08-25 14:58:48 +0000 |
249 | @@ -14,9 +14,9 @@ |
250 | CRC32("I love testing") = CRC32(some_text) |
251 | 1 |
252 | SELECT CRC32(); |
253 | -ERROR 42000: Incorrect parameters in the call to native function 'crc32' |
254 | +ERROR 42000: Incorrect parameter count in the call to native function 'crc32' |
255 | SELECT CRC32('foo','bar','zoo'); |
256 | -ERROR 42000: Incorrect parameters in the call to native function 'crc32' |
257 | +ERROR 42000: Incorrect parameter count in the call to native function 'crc32' |
258 | SELECT CRC32(''); |
259 | CRC32('') |
260 | 0 |
261 | |
262 | === modified file 'tests/r/func_compress.result' |
263 | --- tests/r/func_compress.result 2009-04-24 20:44:50 +0000 |
264 | +++ tests/r/func_compress.result 2009-08-25 14:58:48 +0000 |
265 | @@ -116,14 +116,14 @@ |
266 | drop table t1; |
267 | End of 5.0 tests |
268 | select compress(); |
269 | -ERROR 42000: Incorrect parameters in the call to native function 'compress' |
270 | +ERROR 42000: Incorrect parameter count in the call to native function 'compress' |
271 | select uncompress(); |
272 | -ERROR 42000: Incorrect parameters in the call to native function 'uncompress' |
273 | +ERROR 42000: Incorrect parameter count in the call to native function 'uncompress' |
274 | select uncompressed_length(); |
275 | -ERROR 42000: Incorrect parameters in the call to native function 'uncompressed_length' |
276 | +ERROR 42000: Incorrect parameter count in the call to native function 'uncompressed_length' |
277 | select compress('aeou', 'aoeu', 'aoeu'); |
278 | -ERROR 42000: Incorrect parameters in the call to native function 'compress' |
279 | +ERROR 42000: Incorrect parameter count in the call to native function 'compress' |
280 | select uncompress('aoenuthn', 'aoeu'); |
281 | -ERROR 42000: Incorrect parameters in the call to native function 'uncompress' |
282 | +ERROR 42000: Incorrect parameter count in the call to native function 'uncompress' |
283 | select uncompressed_length('aneohusa','naohuntah','onh'); |
284 | -ERROR 42000: Incorrect parameters in the call to native function 'uncompressed_length' |
285 | +ERROR 42000: Incorrect parameter count in the call to native function 'uncompressed_length' |
286 | |
287 | === modified file 'tests/t/crc32.test' |
288 | --- tests/t/crc32.test 2009-06-09 03:59:56 +0000 |
289 | +++ tests/t/crc32.test 2009-08-25 18:22:32 +0000 |
290 | @@ -18,9 +18,9 @@ |
291 | SELECT CRC32("I love testing") = CRC32(some_text) FROM t1; |
292 | |
293 | # Check for error if no parameter provided |
294 | ---error ER_WRONG_PARAMETERS_TO_NATIVE_FCT |
295 | +--error ER_WRONG_PARAMCOUNT_TO_FUNCTION |
296 | SELECT CRC32(); |
297 | ---error ER_WRONG_PARAMETERS_TO_NATIVE_FCT |
298 | +--error ER_WRONG_PARAMCOUNT_TO_FUNCTION |
299 | SELECT CRC32('foo','bar','zoo'); |
300 | |
301 | # Check that various inputs are processed correctly |
302 | |
303 | === modified file 'tests/t/func_compress.test' |
304 | --- tests/t/func_compress.test 2009-04-24 20:44:50 +0000 |
305 | +++ tests/t/func_compress.test 2009-08-25 18:22:32 +0000 |
306 | @@ -86,16 +86,16 @@ |
307 | |
308 | # parameter count |
309 | |
310 | ---error ER_WRONG_PARAMETERS_TO_NATIVE_FCT |
311 | +--error ER_WRONG_PARAMCOUNT_TO_FUNCTION |
312 | select compress(); |
313 | ---error ER_WRONG_PARAMETERS_TO_NATIVE_FCT |
314 | +--error ER_WRONG_PARAMCOUNT_TO_FUNCTION |
315 | select uncompress(); |
316 | ---error ER_WRONG_PARAMETERS_TO_NATIVE_FCT |
317 | +--error ER_WRONG_PARAMCOUNT_TO_FUNCTION |
318 | select uncompressed_length(); |
319 | |
320 | ---error ER_WRONG_PARAMETERS_TO_NATIVE_FCT |
321 | +--error ER_WRONG_PARAMCOUNT_TO_FUNCTION |
322 | select compress('aeou', 'aoeu', 'aoeu'); |
323 | ---error ER_WRONG_PARAMETERS_TO_NATIVE_FCT |
324 | +--error ER_WRONG_PARAMCOUNT_TO_FUNCTION |
325 | select uncompress('aoenuthn', 'aoeu'); |
326 | ---error ER_WRONG_PARAMETERS_TO_NATIVE_FCT |
327 | +--error ER_WRONG_PARAMCOUNT_TO_FUNCTION |
328 | select uncompressed_length('aneohusa','naohuntah','onh'); |
329 | \ No newline at end of file |
330 | |
331 | === modified file 'tests/t/parser.test' |
332 | --- tests/t/parser.test 2009-02-21 16:00:06 +0000 |
333 | +++ tests/t/parser.test 2009-08-25 18:22:32 +0000 |
334 | @@ -346,94 +346,94 @@ |
335 | |
336 | # Test coverage with edge conditions |
337 | |
338 | --- error ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT |
339 | +-- error ER_WRONG_PARAMCOUNT_TO_FUNCTION |
340 | select pi(3.14); |
341 | |
342 | --- error ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT |
343 | +-- error ER_WRONG_PARAMCOUNT_TO_FUNCTION |
344 | select tan(); |
345 | --- error ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT |
346 | +-- error ER_WRONG_PARAMCOUNT_TO_FUNCTION |
347 | select tan(1, 2); |
348 | |
349 | --- error ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT |
350 | +-- error ER_WRONG_PARAMCOUNT_TO_FUNCTION |
351 | select makedate(1); |
352 | --- error ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT |
353 | +-- error ER_WRONG_PARAMCOUNT_TO_FUNCTION |
354 | select makedate(1, 2, 3); |
355 | |
356 | --- error ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT |
357 | +-- error ER_WRONG_PARAMCOUNT_TO_FUNCTION |
358 | select atan(); |
359 | --- error ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT |
360 | +-- error ER_WRONG_PARAMCOUNT_TO_FUNCTION |
361 | select atan2(1, 2, 3); |
362 | |
363 | --- error ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT |
364 | +-- error ER_WRONG_PARAMCOUNT_TO_FUNCTION |
365 | select concat(); |
366 | select concat("foo"); |
367 | |
368 | --- error ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT |
369 | +-- error ER_WRONG_PARAMCOUNT_TO_FUNCTION |
370 | select concat_ws(); |
371 | --- error ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT |
372 | +-- error ER_WRONG_PARAMCOUNT_TO_FUNCTION |
373 | select concat_ws("foo"); |
374 | |
375 | --- error ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT |
376 | +-- error ER_WRONG_PARAMCOUNT_TO_FUNCTION |
377 | select elt(); |
378 | --- error ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT |
379 | +-- error ER_WRONG_PARAMCOUNT_TO_FUNCTION |
380 | select elt(1); |
381 | |
382 | --- error ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT |
383 | +-- error ER_WRONG_PARAMCOUNT_TO_FUNCTION |
384 | select export_set(); |
385 | --- error ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT |
386 | +-- error ER_WRONG_PARAMCOUNT_TO_FUNCTION |
387 | select export_set("p1"); |
388 | --- error ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT |
389 | +-- error ER_WRONG_PARAMCOUNT_TO_FUNCTION |
390 | select export_set("p1", "p2"); |
391 | --- error ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT |
392 | +-- error ER_WRONG_PARAMCOUNT_TO_FUNCTION |
393 | select export_set("p1", "p2", "p3", "p4", "p5", "p6"); |
394 | |
395 | --- error ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT |
396 | +-- error ER_WRONG_PARAMCOUNT_TO_FUNCTION |
397 | select field(); |
398 | --- error ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT |
399 | +-- error ER_WRONG_PARAMCOUNT_TO_FUNCTION |
400 | select field("p1"); |
401 | |
402 | --- error ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT |
403 | +-- error ER_WRONG_PARAMCOUNT_TO_FUNCTION |
404 | select from_unixtime(); |
405 | --- error ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT |
406 | +-- error ER_WRONG_PARAMCOUNT_TO_FUNCTION |
407 | select from_unixtime(1, 2, 3); |
408 | |
409 | --- error ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT |
410 | +-- error ER_WRONG_PARAMCOUNT_TO_FUNCTION |
411 | select unix_timestamp(1, 2); |
412 | |
413 | --- error ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT |
414 | +-- error ER_WRONG_PARAMCOUNT_TO_FUNCTION |
415 | select greatest(); |
416 | --- error ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT |
417 | +-- error ER_WRONG_PARAMCOUNT_TO_FUNCTION |
418 | select greatest(12); |
419 | |
420 | --- error ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT |
421 | +-- error ER_WRONG_PARAMCOUNT_TO_FUNCTION |
422 | select last_insert_id(1, 2); |
423 | |
424 | --- error ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT |
425 | +-- error ER_WRONG_PARAMCOUNT_TO_FUNCTION |
426 | select least(); |
427 | --- error ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT |
428 | +-- error ER_WRONG_PARAMCOUNT_TO_FUNCTION |
429 | select least(12); |
430 | |
431 | --- error ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT |
432 | +-- error ER_WRONG_PARAMCOUNT_TO_FUNCTION |
433 | select locate(); |
434 | --- error ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT |
435 | +-- error ER_WRONG_PARAMCOUNT_TO_FUNCTION |
436 | select locate(1); |
437 | --- error ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT |
438 | +-- error ER_WRONG_PARAMCOUNT_TO_FUNCTION |
439 | select locate(1, 2, 3, 4); |
440 | |
441 | --- error ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT |
442 | +-- error ER_WRONG_PARAMCOUNT_TO_FUNCTION |
443 | select log(); |
444 | --- error ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT |
445 | +-- error ER_WRONG_PARAMCOUNT_TO_FUNCTION |
446 | select log(1, 2, 3); |
447 | |
448 | --- error ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT |
449 | +-- error ER_WRONG_PARAMCOUNT_TO_FUNCTION |
450 | select make_set(); |
451 | --- error ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT |
452 | +-- error ER_WRONG_PARAMCOUNT_TO_FUNCTION |
453 | select make_set(1); |
454 | |
455 | --- error ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT |
456 | +-- error ER_WRONG_PARAMCOUNT_TO_FUNCTION |
457 | select rand(1, 2, 3); |
458 | |
459 | --- error ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT |
460 | +-- error ER_WRONG_PARAMCOUNT_TO_FUNCTION |
461 | select round(1, 2, 3); |
462 | |
463 | # |
UDF plugin functions and built-in function use the same error message when they both receive an incorrect number of parameters.
See https:/ /blueprints. launchpad. net/drizzle/ +spec/functions -plugins- consistent- errors for more information.