ClickHouse / ClickHouse/ClickHouse

prefer_global_in_and_join=1 DB::Exception: Unknown table function tuple

Open
#30,724 4 comments 0 reactions 0 assignees View on GitHub
comp-query-analyzer external unexpected behaviour
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

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.