Informix Error -26534: INNER join must be on first level of joins
Cause and resolution
INNER join must be on first level of joins
This query was not accelerated because it contains an INNER join that is not on the first level of joins. Query acceleration on INNER joins is only possible if the INNER join in on the first join level.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-26534 fires when a query isn't accelerated because it contains an INNER join that
isn't on the first join level — per the official guidance.
- An
INNERjoin not on the first level of joins, per the official guidance — the direct, only cause; acceleration forINNERjoins only works at the first join level.
Solutions / Resolution
- No action needed to "fix" this — per the official guidance, such a query runs on the database server instead; restructuring the join order may help if acceleration is desired.
Examples
N/A
No specific triggering statement is documented beyond a non-first-level INNER join.
Diagnostic Checks
- Check the join structure for an
INNERjoin below the first level, and restructure if acceleration is desired.
Related Errors / Related Topics
- -26536 — "INNER join contains a non-equality join between columns" A related
INNER-join restriction, on the predicate type rather than join level. - -26537 — "INNER join refers to more than two tables" A related
INNER-join restriction, on table count rather than join level.
An INNER join wasn't on the first join level — such queries run on the database server
instead.