Comments (5)
源库有not null限制,怎么插入的null值?
from otter.
源库插入了空字符,绕过了not null限制,但是在otter解析的时候空值被解析成了null值,目前仅在blob not null字段上出现了这种情况,不知道其他字段类型是否也有这种情况,等会儿我测试一下,给个反馈
from otter.
经过测试,所有binary类型的字段都有这个问题,其他类型字段无此问题:
BINARY(M)
VARBINARY(M)
TINYBLOB
BLOB[(M)]
MEDIUMBLOB
LONGBLOB
from otter.
是的,你看我修复的代码就知道,所有非字符串类型的都有这风险. 之前mysql->oracle有个逻辑,如果是空字符可等价于NULL进行处理,而mysql中NULL,空字符是不等价,isEmptyStringNulled=false.
from otter.
看到你代码了,非常感谢!
from otter.
Related Issues (20)
- 多zookeeper集群如何配置 HOT 1
- 主备配置数据源验证失败 HOT 1
- java: 程序包org.jtester.module.spring不存在
- docker启动后,点击页面内容跳转至0.0.0.0 HOT 1
- 官方的otter-all镜像貌似无法使用mysql8 HOT 4
- DbLoadMerger类中未考虑update-update场景下第二次update有修改主键的情况 HOT 2
- 阿里巴巴
- 有没有一个环境清单呢? HOT 1
- 匿名访问太危险了,谷歌上搜了下,一大堆裸奔的公网机器。。。。 HOT 2
- pid:1 nid:2 exception:setl:com.alibaba.otter.node.etl.select.exceptions.SelectException: java.lang.NullPointerException
- otter 同步aws-RDS-MYSQL 时报错
- spring-core版本升到5.3.18没编译吗?ibatis不能用了! HOT 3
- mysql怎么解决ssl问题 HOT 1
- 3个数据库实例进行数据同步的问题
- 如何监控同步的数据一致性 HOT 1
- 交流群
- docker一键部署发现zk无法启动,
- 关于提升Load批量处理问题
- 官方wiki长时间无人维护,有没有一个比较友好的初始化方式,对待新手可以马上上手?
- node 使用内存加载不出来,https://www.google.com/uds/?file=visualization&v=1.0&packages=corechart
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from otter.