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

Support is [not] null for where_predicate #347

Closed
ghost opened this issue Nov 5, 2018 · 1 comment
Closed

Support is [not] null for where_predicate #347

ghost opened this issue Nov 5, 2018 · 1 comment
Labels
Milestone

Comments

@ghost
Copy link

ghost commented Nov 5, 2018

No description provided.

@ghost ghost added the feature/where label Dec 10, 2018
@ghost ghost modified the milestones: next, 3.21.12.0 Jan 11, 2022
ghost pushed a commit that referenced this issue Jan 13, 2022
@ghost ghost closed this as completed Jan 13, 2022
@asiroliu
Copy link
Collaborator

验证:
version:

9.9.9.9-master-05c9de5
  1. create dtle job, set where is c_int is not null
  2. src prepare data
create table `tb1`(id int(11) not null primary key auto_increment, c_int int)ENGINE=InnoDB DEFAULT CHARSET=utf8;
insert into `test`.`tb1` values (null,-2147483648);
insert into `test`.`tb1` values (null,NULL);
  1. check results
# src mysql
mysql> select * from tb1;
+----+-------------+
| id | c_int       |
+----+-------------+
|  1 | -2147483648 |
|  2 |        NULL |
+----+-------------+
2 rows in set (0.00 sec)
# dest mysql
mysql> select * from tb1;
+----+-------------+
| id | c_int       |
+----+-------------+
|  1 | -2147483648 |
+----+-------------+
1 row in set (0.00 sec)

@asiroliu asiroliu added the VERIFIED verified issue label Jan 17, 2022
This issue was closed.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

1 participant