Use logical description only instead of DDL while reading database history [DBZ-3536]
- 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
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