Unknown identifier when a column is referenced in subquery · Issue #26 · ClickHouse/ClickHouse · GitHub
Skip to content

Unknown identifier when a column is referenced in subquery #26

Description

@buremba

The following query doesn't work and complains that t used in subquery is an unknown identifier.

select (select t), (select dummy), t from system.one array join([1,2] as t)

I guess the problem is that t comes from ARRAY JOIN and the subqueries can only reference columns from the table system.one. I think that this is a consistency problem, however; if it's a technical restriction, the documentation should state it.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Fields

    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions