missingFromClauseEntry¶

Group typecheck · Recommended · Needs a database connection · Since 0.27.0
Diagnostic lint/missingFromClauseEntry · Postgres error 42P01

Description¶

A column is qualified with a name that is not in the FROM clause.

The qualifier must be the name or alias of a relation in scope. After aliasing a table, its original name can't be used anymore.

Postgres raises 42P01 undefined_table for these statements.

Examples¶

Invalid¶

create table users (id int8);
select users.id from users u;

code-block.sql:2:8 lint/missingFromClauseEntry ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

  × Missing FROM-clause entry for users.

    1 │ create table users (id int8);
  > 2 │ select users.id from users u;
      │        ^^^^^^^^
    3 │ 

Valid¶

create table users (id int8);
select u.id from users u;

How to configure¶

{
  "linter": {
    "rules": {
      "missingFromClauseEntry": "error"
    }
  }
}

How to suppress¶

Suppress this diagnostic with a comment:

-- pgls-ignore missingFromClauseEntry