Skip to content

Column identifier __table1.a is already registered. (LOGICAL_ERROR) #85469

@nickitat

Description

@nickitat

Describe the bug

LOGICAL_ERROR

How to reproduce

set allow_experimental_correlated_subqueries=1;

SELECT t.a, u.a FROM (SELECT 1 AS a) AS t, (SELECT DISTINCT *, *, 27, '======Before Truncate======', materialize(27), 27, *, isZeroOrNull(27), 27, materialize(27), *, * IS NOT NULL, *, 27, *, toFixedString('======Before Truncate======', 27), 27, 27, 27, 27, toLowCardinality(27), toNullable(materialize(27)), * IS NOT NULL, 1 AS a QUALIFY ((*, 27, materialize(27), 27, '======Before Truncate======', 27, 27, (27 IS NOT NULL), * IS NOT NULL) IS NULL) = (t.a AS alias668)) AS u;

Error message and/or stacktrace

No response

Metadata

Metadata

Assignees

Labels

comp-query-analyzerSemantic analysis + logical/physical planning + rewrites (Analyzer and Planner modules).testingSpecial issue with list of bugs found by CI

Type

No type
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