Informix Error -26532: ON clause of LEFT OUTER refers to more than two tables
Cause and resolution
ON clause of LEFT OUTER refers to more than two tables
This query was not accelerated because it contains a LEFT OUTER join with an ON clause that refers to more than two tables.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-26532 fires when a query isn't accelerated because a LEFT OUTER join's ON clause
references more than two tables — per the official guidance.
- A
LEFT OUTERjoin'sONclause spans more than two tables, per the official guidance — the direct, only cause.
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 LEFT OUTER ON clause
spanning more than two tables.
Diagnostic Checks
- This is an informational offload-diagnostic, not an error to fix.
Related Errors / Related Topics
- -26537 — "INNER join refers to more than two tables" The same class of
join-table-count restriction, for
INNERjoins rather thanLEFT OUTER.
A LEFT OUTER join's ON clause spanned more than two tables — such queries run on the
database server instead.