Skip to content

Logical Error: Error occurred while querying with parallel replicas #76925

@wudidapaopao

Description

@wudidapaopao

Company or project name

No response

Describe what's wrong

Error occurred while querying alias column with parallel replicas.

Does it reproduce on the most recent release?

Yes

How to reproduce

SET parallel_replicas_for_non_replicated_merge_tree = 1;
SET allow_experimental_parallel_reading_from_replicas = 1;
SET cluster_for_parallel_replicas = 'test_cluster';
DROP TABLE IF EXISTS test_table;
CREATE TABLE test_table (a UInt64, b UInt64, c UInt64, d UInt64, n Nested(x String))
ENGINE MergeTree() PARTITION BY b ORDER BY a;
INSERT INTO test_table SELECT number, number % 2, number, number % 3, ['a', 'b', 'c'] FROM numbers(0, 100);
ALTER TABLE test_table ADD COLUMN n.y Array(String) ALIAS ['qwqw'] AFTER n.x;
SELECT a, b, c, d, n.x, n.y FROM test_table ORDER BY c;

Expected behavior

No response

Error message and/or stacktrace

`Code: 8. DB::Exception: Received from localhost:9000. DB::Exception: Cannot find column `__table1.n.y` in source stream, there are only columns: [__table1.c, __table1.a, __table1.b, __table1.d, __table1.n.x]. (THERE_IS_NO_COLUMN)`

Additional context

No response

Metadata

Metadata

Labels

analyzerIssues and pull-requests related to new analyzerbugConfirmed user-visible misbehaviour in official release

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions