-
Notifications
You must be signed in to change notification settings - Fork 7.6k
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
MySQL驱动包支持Boolean类型,canal不支持boolean类型转换 #631
Comments
没有专门针对tinyint(1)做过特殊处理,目前统一按照了tinyint类型-6 |
有计划支持吗? |
可以考虑提交一个PR给我 |
nbqyqx
added a commit
to nbqyqx/canal
that referenced
this issue
Jun 7, 2018
@agapple please assign the issue to me :) |
The fix still have some problem when sync data with tinyint(1) type. If not specify tinyInt1isBit in your jdbc url,the return java type is integer. Reference doc is https://dev.mysql.com/doc/connector-j/8.0/en/connector-j-reference-type-conversions.html |
KaimingWan
added a commit
that referenced
this issue
Feb 28, 2020
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
MySQL的驱动包中对tinyint的长度为1,对应sqlType=-7,转化为Java布尔类型,参考MySQL驱动源码
而Canal对对tinyint的长度为1,对应sqlType=-6,无法处理为Java的布尔类型
The text was updated successfully, but these errors were encountered: