[GitHub] [shardingsphere] dmbj commented on issue #6604: sharding scaling&proxy sync realtimedata in mysql with fieldtype text occur exception

[GitBox <gi...@apache.org>]

dmbj commented on issue #6604:
URL: https://github.com/apache/shardingsphere/issues/6604#issuecomment-668906188


   > I think the sql is wrong whit `extra = ''' ` , it should be `extra = '\'' `?
   > 
   > > INSERT INTO t_qrcode_consume_details_1(order_no,user_id,code_type,channel,update_time,amount,scene,extra,paid_charge_id,init_status,status,gmt_create,gmt_modify,rev,pay_channel,pay_order_no) VALUES('00028361564047575000010272479377', '1', '00', '02', '2019-07-25 17:39:35', 200, '正常乘车扣费', ''', null, '01', '01', '2019-07-25 17:39:44', '2019-07-25 17:39:44', null, '00', 'ch_17itblm9nkaehv9jc27277')
   
   ths for answer the issue,As you can see,trigger scaling exception is that SQL.but why proxy execute that SQL statement,then you will find the Logic SQL log:`Logic SQL: INSERT INTOt_qrcode_consume_details(order_no,user_id,code_type,channel,update_time,amount,scene,extra,paid_charge_id,init_status,status,gmt_create,gmt_modify,rev,pay_channel,pay_order_no) VALUES('00028361564047575000010272479377','1','00','02','2019-07-25 17:39:35',200,'正常乘车扣费',x'',null,'01','01','2019-07-25 17:39:44','2019-07-25 17:39:44',null,'00','ch_17itblm9nkaehv9jc27277')`
   
   appeal an 'x' in it.
   So I guess binlog explain postion SQL wrong,this feildtype in mysql is text,i have already test this field value with NULL & notempty val,i found if the val is NULL, realtime sync work fine, if not got an exception. the reason i thind should be fieldtype text surpport not well in binlog explain SQL statement, you can test it


----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org