Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

drainer: process empty string from tidb in update/delete statement on oracle #1162

Open
cartersz opened this issue May 25, 2022 · 0 comments

Comments

@cartersz
Copy link
Contributor

Bug Report

Please answer these questions before submitting your issue. Thanks!

  1. What did you do?
    if binlog hava empty string value in column, drainer will generate " col='' " in where clause in sql.
    but oracle treate empty string as null, oracle need "col is null" to match column.

  2. What did you expect to see?
    if col value is empty string, drainer will generate "col is null" in update/delete statement.

  3. What did you see instead?

  4. Please provide the relate downstream type and version of drainer.
    we need bug fix release 6.1

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants