ClickHouse / ClickHouse/walshadow

Replica identity full with no primary key

Open
#114 1 comment 0 reactions 0 assignees View on GitHub
Dominant language
Rust
Stars
118
Forks
5
Avg merge
1d 19h
Merged PRs (30d)
38

Description

Duplicate rows are not replicated to clickhouse. Updates are not propogated.

```
┌────────────────────────────────────────────────┬────────────────┬───────────────────────────────┬────────────────────┐
│ Operation (Postgres) │ Postgres state │ ClickHouse FINAL live │ Correct? │
├────────────────────────────────────────────────┼────────────────┼───────────────────────────────┼────────────────────┤
│ INSERT (1,'x'), (1,'x') — separate txns │ 2 rows │ 2 rows │ ✅ │
├────────────────────────────────────────────────┼────────────────┼───────────────────────────────┼────────────────────┤
│ INSERT (1,'x'), (1,'x') — same txn / bootstrap │ 2 rows │ 1 row │ ❌ collapse │
├────────────────────────────────────────────────┼────────────────┼───────────────────────────────┼────────────────────┤
│ UPDATE both → (1,'y') │ 2 rows │ 4 rows (1,x ×2 + 1,y ×2) │ ❌ duplicates │
├────────────────────────────────────────────────┼────────────────┼───────────────────────────────┼────────────────────┤
│ DELETE both │ 0 rows │ 4 rows (2 tombstones ignored) │ ❌ nothing removed │
└────────────────────────────────────────────────┴────────────────┴───────────────────────────────┴────────────────────┘

```

Contributor guide

No contributing guide indexed for this repository

Research direction

No files, tests, or entry points are identified in the issue. Start by reproducing the listed duplicate-row, update, and delete cases for PostgreSQL replica identity full with ClickHouse, then trace the replication path that handles these changes. Done means duplicate rows remain distinct and both updates and deletes produce the expected ClickHouse state.

Written by the indexing model from the issue text.

Assessment

Tech stack
clickhouse, postgresql, rust
Domain
backend, databases
Issue type
Bug
Difficulty
5/5
Estimated time
Over a week
Activity status
Active
Clarity
Needs clarification
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.