-
Notifications
You must be signed in to change notification settings - Fork 8.3k
Self-referencing MATERIALIZED is not forbidden #24910
Copy link
Copy link
Closed
Labels
easy taskGood for first contributorsGood for first contributorsunexpected behaviourResult is unexpected, but not entirely wrong at the same time.Result is unexpected, but not entirely wrong at the same time.usability
Description
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'.
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
easy taskGood for first contributorsGood for first contributorsunexpected behaviourResult is unexpected, but not entirely wrong at the same time.Result is unexpected, but not entirely wrong at the same time.usability