ClickHouse / ClickHouse/ClickHouse

Can't create non persistent Join table with join_any_take_last_row flag

Open
#28,701 0 comments 0 reactions 0 assignees View on GitHub
comp-simple-engines external unexpected behaviour
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

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.