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

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions