-
Notifications
You must be signed in to change notification settings - Fork 8.3k
Column identifier __table1.a is already registered. (LOGICAL_ERROR) #85469
Copy link
Copy link
Closed
Labels
comp-query-analyzerSemantic analysis + logical/physical planning + rewrites (Analyzer and Planner modules).Semantic analysis + logical/physical planning + rewrites (Analyzer and Planner modules).testingSpecial issue with list of bugs found by CISpecial issue with list of bugs found by CI
Description
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
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
comp-query-analyzerSemantic analysis + logical/physical planning + rewrites (Analyzer and Planner modules).Semantic analysis + logical/physical planning + rewrites (Analyzer and Planner modules).testingSpecial issue with list of bugs found by CISpecial issue with list of bugs found by CI