回复: CaptureChangeMySQL bit(1) type field is parsed to '{}'

[wangl...@geekplus.com.cn]

Anybody has any insight on this? 


wangl...@geekplus.com.cn
 
发件人： wangl...@geekplus.com.cn
发送时间： 2019-08-22 19:31
收件人： users
主题： CaptureChangeMySQL bit(1) type field is parsed to '{}'

CaptureChangeMySQL -> ConvertJSONToSQL -> ExecuteSQL to replicate my database.
But when the field type is bit, there will be error.  Because teh value is 
parsed to '{}'

`is_cancel` bit(1) DEFAULT b'0' COMMENT 'canceled',

[ {
  "id" : 6173148,
  "task_id" : 6173148,
  "charger_id" : 1,
  "is_cancel" : "{}",
  "priority" : 0,
  "business_sequence" : 0
} ]

Is this a bug？ 
Or there‘s some method i can avoid this?

Thanks,
Lei


wangl...@geekplus.com.cn