forked from ClickHouse/ClickHouse
-
Notifications
You must be signed in to change notification settings - Fork 13
Open
Description
Describe the bug
CREATE TABLE left
(
`id` Int32,
`value` Int32,
`date_col` Date,
`value_minus` ALIAS value - 1
)
ENGINE = MergeTree
PARTITION BY toYYYYMM(date_col)
ORDER BY (date_col, id);
CREATE TABLE right
(
`id` Int32,
`value` Int32,
`date_col` Date,
`value_minus` ALIAS value - 1
)
ENGINE = MergeTree
PARTITION BY toYYYYMM(date_col)
ORDER BY (date_col, id);
CREATE TABLE hybrid_without_col_def
ENGINE = Hybrid(remote('localhost', currentDatabase(), 'left'), id < 4, remote('localhost', currentDatabase(), 'right'), id >= 4);Then I drop right table:
DROP TABLE rightAnd try to select from hybrid table:
SELECT *
FROM hybrid_without_col_defQuery id: 5735075f-21b1-40aa-8aaa-41992fe18405
Elapsed: 0.010 sec.
Received exception from server (version 25.8.14):
Code: 60. DB::Exception: Received from localhost:9000. DB::Exception: Table default.right does not exist. Maybe you meant default.right?. (UNKNOWN_TABLE)
Why is it suggesting dropped table?