Informix Error -522: Table table-name not selected in query.

Reasons / Common Causes

-522 fires when a correlation name (table alias) is used to qualify a column in a GROUP BY clause or a trigger's SET clause — those clauses specifically don't accept correlation-name qualification, per the official guidance.

1. A correlation name used to qualify a GROUP BY column — the column reference itself may be valid, but qualifying it with the query's table alias isn't accepted in that clause.
2. A trigger's SET clause referencing a column through a correlation name (for instance, the NEW/OLD correlation names in an SPL trigger action), where the official guidance points specifically at rewriting the triggered action as an SPL routine instead.
3. Copy-pasted SQL from a SELECT's column list, where correlation-qualified references are normal, into a GROUP BY or SET clause where they aren't accepted.

Solutions / Resolution

1. Rewrite the statement without a correlation name in the GROUP BY clause or the SET clause, per the official guidance — this is required in every case, not just a suggestion.
2. For a trigger's triggered action needing correlation-qualified values, per the official guidance, consider rewriting it as an SPL routine invoked as the triggered action, passing the column value as an argument instead of qualifying it inline.

Examples

The disallowed qualification in GROUP BY

SELECT o.status, COUNT(*) FROM orders o GROUP BY o.status;
-- -522: correlation name 'o' not accepted qualifying a GROUP BY column

Corrected — no correlation qualifier in GROUP BY

SELECT o.status, COUNT(*) FROM orders o GROUP BY status;

A trigger SET clause, rewritten as an SPL routine

-- Instead of qualifying a correlation name directly in the triggered SET clause,
-- call an SPL routine as the triggered action, passing the value as an argument:
CREATE TRIGGER trg_orders_update UPDATE OF status ON orders
  REFERENCING NEW AS post FOR EACH ROW
  (EXECUTE PROCEDURE log_status_change(post.status));

Diagnostic Checks

1. Scan GROUP BY and trigger SET clauses for correlation-name-qualified columns, since those are the two contexts this restriction applies to.

Related Errors / Related Topics

No closely related error codes are cross-referenced for -522 in this set yet.

Correlation names aren't accepted in GROUP BY or trigger SET clauses — drop the qualifier, or for triggers, move the logic into an SPL routine passed the value as an argument.