Skip to content

[Feature] check support output revise sql for manual revise #425

@caiq1nyu

Description

@caiq1nyu

Motivations

In most cases, the business is more sensitive to the repair of differential data and prefers manual repair based on repair SQL.

Solution

  • add configuration to control whether to output revise SQL
  • the revise SQL like:
// diff when have pk or uk
update xxx where pk_or_uk = xxx
// diff when no pk or uk, or configured to output full field matching
update xxx where col1 = xxx and col2 = xxx and ... and coln=xxx
// miss in target
insert into xxx

Metadata

Metadata

Assignees

Labels

EnhancementNew feature or request

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions