Describe the bug
If you make a query to MySQL Engine Table with joined MergeTree Engine Table, you use any columns of the latter.
How to reproduce
- ClickHouse server 20.8.2
- ClickHouse client version 20.8.2.3 (official build).
CREATE TABLE mysql_table
(
`id` UInt64,
`name` Nullable(String),
)
ENGINE = MySQL('test:3306', 'test', 'test', 'test', 'test');CREATE TABLE ch_table
(
`id` UInt64,
`mysql_item_id` UInt64,
`d` DateTime
)
ENGINE = MergeTree()
PARTITION BY toYYYYMM(d)
ORDER BY d;Query
SELECT *
FROM mysql_table AS t_mysql_table
LEFT JOIN ch_table AS t_ch_table
ON t_ch_table.mysql_item_id = t_mysql_table.id
WHERE t_ch_table.id > 100Expected behavior
Returns empty result without errors.
Error message and/or stacktrace
Code: 47. DB::Exception: Received from test:9000. DB::Exception: Missing columns: 't_ch_table.id' while processing query: 't_ch_table.id > 100', required columns: 't_ch_table.id', source columns: 'id', 'name'.
Describe the bug
If you make a query to MySQL Engine Table with joined MergeTree Engine Table, you use any columns of the latter.
How to reproduce
Query
Expected behavior
Returns empty result without errors.
Error message and/or stacktrace