Informix Error -26536: INNER join contains a non-equality join between columns
Cause and resolution
INNER join contains a non-equality join between columns
This query was not accelerated because it contains an INNER join with a non-equality join predicate between two columns. Query acceleration is only possible on equality join predicates of two columns.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-26536 fires when a query isn't accelerated because an INNER join has a non-equality
predicate between two columns — per the official guidance.
- An
INNERjoin's predicate is non-equality between two columns, per the official guidance — the direct, only cause; acceleration only supports equality join predicates.
Solutions / Resolution
- No action needed to "fix" this — per the official guidance, such a query runs on the database server instead.
Examples
N/A
No specific triggering statement is documented beyond a non-equality INNER join
predicate.
Diagnostic Checks
- This is an informational offload-diagnostic, not an error to fix.
Related Errors / Related Topics
- -26520 — "ON clause contains a non-equality join between columns" The same class
of equality-join-only restriction, for outer joins rather than
INNER. - -26534 — "INNER join must be on first level of joins" A related
INNER-join restriction, on join level rather than predicate type. - -26537 — "INNER join refers to more than two tables" A related
INNER-join restriction, on table count rather than predicate type.
An INNER join had a non-equality predicate between columns — such queries run on the
database server instead.