Informix Error -25848: The functional key argument is invalid.
Cause and resolution
The functional key argument is invalid.
The error occurred due to one or more of the following reasons:
The first argument to functional index needs to table column. If other arguments are constant, it needs to be string type of length less than 128 bytes.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-25848 fires when a functional index's key arguments are invalid — per the official guidance, the first argument must be a table column, and any other constant argument must be a string shorter than 128 bytes.
- The functional index's first argument not being a table column, per the official guidance — the first named case.
- A constant argument that isn't a string, or is 128 bytes or longer, per the official guidance — the second named case.
Solutions / Resolution
- Use a table column as the first argument, per the official guidance.
- Keep any constant argument as a string under 128 bytes, per the official guidance.
Examples
N/A
No specific triggering statement is documented beyond an invalid functional-key argument.
Diagnostic Checks
- Check the functional index's first argument (must be a column) and any constant arguments (must be strings under 128 bytes), and correct them.
Related Errors / Related Topics
- -25849 — "The indexkey size exceeds the catalog column size." A related functional index error, on the encoded key size rather than argument validity.
A functional index's key argument was invalid (not a column first, or a too-long constant) — correct the argument.