Skip to content

Self-referencing MATERIALIZED is not forbidden #24910

@filimonov

Description

@filimonov
CREATE TABLE a
(
    `number` UInt64,
    `x` MATERIALIZED x
)
ENGINE = MergeTree
ORDER BY number;
-- that should fail!

insert into a values (1);
Received exception from server (version 21.7.1):
Code: 47. DB::Exception: Received from localhost:9000. DB::Exception: Missing columns: 'x' while processing query: 'CAST(x, 'UInt8') AS x', required columns: 'x' 'x'. 

Metadata

Metadata

Assignees

No one assigned

    Labels

    easy taskGood for first contributorsunexpected behaviourResult is unexpected, but not entirely wrong at the same time.usability

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions