alibaba / alibaba/DataX

请问mysqlwriter支持update语句吗,update多条件

Open
#1,887 1 comment 0 reactions 0 assignees View on GitHub
Dominant language
Java
Stars
17.4k
Forks
5.7k
PR merge metrics
No merged PRs in 30d

Description

场景是这样的,需要同步表A到表B,反过来也需要同步,也就是双向同步,如果仅仅一个id的话会导致死循环,因为select是根据更新字段查询数据的,这样被更新后马上就会被查出来,比如A查询出数据去更新B,此时B也会被查询出来,然后又去更新A,导致死循环问题,我是想在update的时候加一个更新时间判断,但是发现mysqlwriter是insert into on update,不支持update的where条件

Contributor guide

No contributing guide indexed for this repository

Research direction

Start with the mysqlwriter implementation and its handling of INSERT ... ON DUPLICATE KEY UPDATE. Determine how update conditions would be configured and applied for bidirectional synchronization, then add coverage for multi-condition updates and verify that the resulting behavior avoids the reported loop.

Written by the indexing model from the issue text.

Assessment

Tech stack
java, mysql
Domain
databases
Issue type
Feature
Difficulty
5/5
Estimated time
Over a week
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
25/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.