Informix Error -26520: ON clause contains a non-equality join between columns
Cause and resolution
ON clause contains a non-equality join between columns
This query was not accelerated because it contains an OUTER 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
-26520 fires when a query isn't accelerated because it has an outer join with a non-equality predicate between two columns — per the official guidance.
- An
OUTERjoin'sONclause uses a non-equality predicate between two columns, per the official guidance — the direct, only cause; acceleration only supports equality join predicates between columns.
Solutions / Resolution
- No action needed to "fix" this — per the official guidance, such a query runs on the database server instead; rewriting the join as an equality predicate may help if acceleration is desired.
Examples
N/A
No specific triggering statement is documented beyond a non-equality outer-join predicate.
Diagnostic Checks
- Check the
OUTERjoin'sONclause for a non-equality column-to-column predicate, and rewrite as equality if acceleration is desired.
Related Errors / Related Topics
No closely related error codes are cross-referenced for -26520 in this set yet.
An outer join's ON clause used a non-equality predicate between columns — such queries
run on the database server instead.