You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@nifi.apache.org by "wanglei2@geekplus.com.cn" <wa...@geekplus.com.cn> on 2019/09/03 09:18:03 UTC

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

Anybody has any insight on this? 


wanglei2@geekplus.com.cn
 
发件人： wanglei2@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


wanglei2@geekplus.com.cn