3190
MariaDBERRORNotableQuery SyntaxHIGH confidence
Invalid number of arguments
Production Risk
Low — caught at parse time.
Why it happens
- 1Calling a function with too many or too few arguments.
- 2Function signature mismatch between called arity and expected arity.
How to reproduce
trigger — this will error
trigger — this will error
SELECT SUBSTR('hello');expected output
ERROR 3190 (HY000): Incorrect number of arguments for function.
Fix
Provide the correct number of arguments
Provide the correct number of arguments
SELECT SUBSTR('hello', 1, 3);Why this works
Check the function signature and supply all required parameters.
What not to do
✕
Sources
Official documentation ↗
MySQL 8.0 — 3190 ER_INVALID_NO_OF_ARGS
Content generated with AI assistance and reviewed for accuracy. Found an error? hello@errcodes.dev