You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2020/03/20 06:30:29 UTC

[GitHub] [incubator-shardingsphere] wangjing112 edited a comment on issue #4707: proxy-4.0.1 return wrong result when use varchar type in hibernate.

wangjing112 edited a comment on issue #4707: proxy-4.0.1 return wrong result when use varchar type in hibernate.
URL: https://github.com/apache/incubator-shardingsphere/issues/4707#issuecomment-601554717
 
 
   > You think the parameters of SQL got wrong, right? I want to make sure that the incorrect parameters you mentioned are which hibernate sent or proxy returned?
   
   hibernate->sharding-jdbc->mysql work fine
   hibernate->proxool->mysql work fine
   hibernate->proxool->sharding-proxy->mysql wrong
   
   the wrong query use:Query org.hibernate.Query.setParameterList(String arg0, Collection arg1)
   from hibernate-3.5.6
   
   look this,16:23 progress B query result exist 11:42 progress A's Sql.
   so i think the proxy process parameter query then result string out of buffer bounds.
   
   > a query on 16:23
   > in mysql this data is "[]" in table1 but now is wrong
   > ![image](https://user-images.githubusercontent.com/51982240/76396658-90091980-63b4-11ea-90a5-acd4390602ba.png)
   > is find in proxy log at 11:42 have a data like as:
   > ![image](https://user-images.githubusercontent.com/51982240/76396708-a6af7080-63b4-11ea-9fe7-5620282e84e9.png)
   > 
   > even not a same table!
   
   

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