Skip to content

Unexpected hint when one of segments in hybrid table dropped #1336

@alsugiliazova

Description

@alsugiliazova

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 right

And try to select from hybrid table:

SELECT *
FROM hybrid_without_col_def
Query 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?

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions