debezium / debezium/dbz

Use logical description only instead of DDL while reading database history [DBZ-3536]

Open
#461 0 comments 0 reactions 0 assignees View on GitHub
component/core-library migrated-from-jira type/task
Dominant language
HTML
Stars
6
Forks
8
Avg merge
2d 19h
Merged PRs (30d)
1

Description

Migrated from [DBZ-3536](https://issues.redhat.com/browse/DBZ-3536)

When Debezium stores the database history it stores the logical representation of schema changes and DDL. But for recovery DDL is used insted of the logical changes.

We should move from DDL re-parsing to relaying on logical changes. To achive this task we need to

 
* support storing and reading of defualt values (DBZ-3279)
* make sure that the logical change format supports renaming tables
* make sure that the logical change format supports changin the table and renaming it in a single step
* decide how to handle mutliple table changes in on DDL - like multiple renames
* provide an *internal* config option that would allow to fall back to the DDL parsing

Contributor guide

Open the contributing guide

Research direction

Start by reviewing DBZ-3279 and the listed logical-change requirements for default values, table renames, combined changes, and multiple renames. Done means database-history recovery relies on logical changes rather than DDL re-parsing, with an internal DDL fallback option; the issue does not name files or tests to run.

Written by the indexing model from the issue text.

Assessment

Tech stack
sql
Domain
databases
Issue type
Feature
Difficulty
5/5
Estimated time
Over a week
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
25/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.