Informix Error -26361: Invalid 'hash on' list specified for FOT index.
Cause and resolution
Invalid 'hash on' list specified for FOT index.
The 'hash on' list for the forest of trees (FOT) index must be a prefix list of the index columns.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-26361 fires when a forest-of-trees (FOT) index's HASH ON column list isn't a prefix of
the index's columns — per the official guidance.
- The
HASH ONlist isn't a prefix list of the index columns, per the official guidance — the direct, only cause.
Solutions / Resolution
- Specify a
HASH ONlist that's a prefix of the index's own column list, per the official guidance.
Examples
N/A
No specific triggering statement is documented beyond a non-prefix HASH ON list.
Diagnostic Checks
- Compare the
HASH ONcolumn list against the index's column order, and confirm it's a prefix.
Related Errors / Related Topics
- -26360 — "Invalid bucket size specified for FOT index." A related FOT-index definition error, on the bucket size rather than the hash-on column list.
- -26362 — "Invalid data type for 'hash on' columns specified for FOT index." A related FOT-index definition error, on hash-on column data types rather than the list's prefix requirement.
An FOT index's HASH ON list wasn't a prefix of the index columns — correct it.