ClickHouse / ClickHouse/ClickHouse
Can't create non persistent Join table with join_any_take_last_row flag
- Dominant language
- C++
- Stars
- 49.9k
- Forks
- 9k
- Avg merge
- 21h 32m
- Merged PRs (30d)
- 515
Description
**Describe the unexpected behaviour**
Creating Join table is impossible if `join_any_take_last_row` and `persistent` provided at same time.
**How to reproduce**
Version: 21.3.15, 21.9.1.7803
Create table with Join Engine:
```
create table test (id UInt64, val String) ENGINE = Join(ANY, LEFT, id) SETTINGS join_any_take_last_row=1, persistent=0
```
**Expected behavior**
```
CREATE TABLE test
(
`id` UInt64,
`val` String
)
ENGINE = Join(ANY, LEFT, id)
SETTINGS join_any_take_last_row = 1, persistent = 0
Query id: 0b50d73f-20e4-4aff-b039-84f42a11acb0
Ok.
0 rows in set. Elapsed: 0.003 sec.
```
**Error message and/or stacktrace**
```
Received exception from server (version 21.9.1):
Code: 115. DB::Exception: Received from localhost:9000. DB::Exception: Unknown setting join_any_take_last_row: for storage Join. (UNKNOWN_SETTING)
```
**Additional context**
Both flags works ok if provided separately.
Contributor guide
Assessment
This issue has not been assessed yet.