ClickHouse / ClickHouse/ClickHouse
prefer_global_in_and_join=1 DB::Exception: Unknown table function tuple
- Dominant language
- C++
- Stars
- 49.9k
- Forks
- 9k
- Avg merge
- 21h 32m
- Merged PRs (30d)
- 515
Description
when
```
set prefer_global_in_and_join=1;
set distributed_product_mode='global';
```
execute sql(date_dim is a distributed table)
```
select count(*) from date_dim where d_year in (1999, 1999 + 1, 1999 + 2, 1999 + 3);
```
got this:
```
Received exception from server (version 21.8.5):
Code: 46. DB::Exception: Received from localhost:9000. DB::Exception: Unknown table function tuple: While processing d_year IN (1999, 1999 + 1, 1999 + 2, 1999 + 3).
```
however, use `d_year in (1999, 2000, 2001, 2002)` is ok, for example:
```
select count(*) from date_dim where d_year in (1999, 2000, 2001, 2002);
```
**How to reproduce**
* ClickHouse server version 21.8.5
Contributor guide
Assessment
This issue has not been assessed yet.