[GitHub] [incubator-shardingsphere] KomachiSion commented on issue #3024: proxy-4.0.0-RC2 process blob data error

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

KomachiSion commented on issue #3024: proxy-4.0.0-RC2 process blob data error
URL: https://github.com/apache/incubator-shardingsphere/issues/3024#issuecomment-584969392
 
 
   > ShardingProxy decodes MySQL Query request package, and transform sql to String, which will be used to parse.
   > But due to the charset, the Blob(binary) type can't transform to String. So some of special byte will be changed while the decode step.
   > 
   > I also add `useServerPrepStmts=true` and `cachePrepStmts=true` to jdbc url, but it will cause new exception: `Cause: java.sql.SQLException: 1Unsupported command: [COM_STMT_SEND_LONG_DATA]`
   > 
   > So, I think the problem need more investigation and discuss for the solutions.
   > 
   > Does any body have idea how mysql deal with the binary type protocol?
   
   pending reason: No find enough good solution.

----------------------------------------------------------------
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


With regards,
Apache Git Services