Skip to content

Derived tables should require aliases #178

@ssandler

Description

@ssandler
./bin/lint-query --query "SELECT * FROM table1 JOIN (select * from table2) ON some_column = some_other_column"

This passes the linter, but should fail because the subquery does not have an alias. Running this query in MySQL will return the error Every derived table must have its own alias.

Metadata

Metadata

Assignees

No one assigned

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions