forked from ClickHouse/ClickHouse
-
Notifications
You must be signed in to change notification settings - Fork 16
Open
Description
Setup as in this issue #1208
IN should be fixed together with JOINS #1209.
SELECT * FROM hybrid_table_64293f1a_0cba_11f1_876b_de7b9eea3490 WHERE string_col IN (SELECT DISTINCT string_col FROM merge_tree_table_640a9b6e_0cba_11f1_876b_de7b9eea3490 WHERE long_col > 1500);In output there are some rows from the table along with exception:
Code: 60. DB::Exception: Received from localhost:9000. DB::Exception: Received from clickhouse2:9000. DB::Exception: Unknown table expression identifier 'default.merge_tree_table_640a9b6e_0cba_11f1_876b_de7b9eea3490' in scope (SELECT DISTINCT __table1.string_col AS string_col FROM default.merge_tree_table_640a9b6e_0cba_11f1_876b_de7b9eea3490 AS __table1 WHERE __table1.long_col > 1500). (UNKNOWN_TABLE)
Reactions are currently unavailable