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/11 06:17:56 UTC
[GitHub] [incubator-shardingsphere] wangjing112 commented on issue #4707:
proxy-4.0.1 return error varchar in use hibernate.
wangjing112 commented on issue #4707: proxy-4.0.1 return error varchar in use hibernate.
URL: https://github.com/apache/incubator-shardingsphere/issues/4707#issuecomment-597463002
same 3 times querys from mysql return:
query1 table 1:
[{"chapterId":1,"gold":0,"id":36030446286411906,"openData":"[{\"id\":1,\"lv\":0}]","overData":"[]","roleId":36030446286411906,"status":0},{"chapterId":101,"gold":0,"id":36030446286411906,"openData":"[{\"id\":10101,\"lv\":0}]","overData":"[]","roleId":36030446286411906,"status":0},{"chapterId":102,"gold":0,"id":36030446286411906,"openData":"[{\"id\":10201,\"lv\":0}]","overData":"[]","roleId":36030446286411906,"status":0}]
query2 table 2:
[{"extData":"","id":36030446286411906,"packetData":"[{\"id\":10001,\"no\":1,\"st\":1,\"talent\":{\"groups\":[{\"args\":[],\"id\":101},{\"args\":[],\"id\":201},{\"args\":[],\"id\":301}]}},{\"id\":10002,\"no\":2,\"st\":1,\"talent\":{\"groups\":[{\"args\":[],\"id\":101},{\"args\":[],\"id\":202},{\"args\":[],\"id\":301}]}},{\"id\":10003,\"no\":3,\"st\":1,\"talent\":{\"groups\":[{\"args\":[],\"id\":102},{\"args\":[],\"id\":201},{\"args\":[],\"id\":302}]}},{\"id\":10006,\"no\":4,\"st\":1,\"talent\":{\"groups\":[{\"args\":[],\"id\":101},{\"args\":[],\"id\":201},{\"args\":[],\"id\":301}]}},{\"id\":10007,\"no\":5,\"st\":1,\"talent\":{\"groups\":[{\"args\":[],\"id\":101},{\"args\":[],\"id\":201},{\"args\":[],\"id\":301}]}},{\"id\":10008,\"no\":6,\"st\":1,\"talent\":{\"groups\":[{\"args\":[],\"id\":101},{\"args\":[],\"id\":201},{\"args\":[],\"id\":301}]}},{\"id\":10009,\"no\":7,\"st\":1,\"talent\":{\"groups\":[{\"args\":[],\"id\":101},{\"args\":[],\"id\":201},{\"args\":[],\"id\":301}]}},{\"id\":10014,\"no\":8,\"st\":1,\"talent\":{\"groups\":[{\"args\":[],\"id\":101},{\"args\":[],\"id\":201},{\"args\":[],\"id\":301}]}},{\"id\":10015,\"no\":9,\"st\":1,\"talent\":{\"groups\":[{\"args\":[],\"id\":101},{\"args\":[],\"id\":201},{\"args\":[],\"id\":301}]}},{\"id\":10016,\"no\":10,\"st\":1,\"talent\":{\"groups\":[{\"args\":[],\"id\":101},{\"args\":[],\"id\":201},{\"args\":[],\"id\":301}]}},{\"id\":10017,\"no\":11,\"st\":1,\"talent\":{\"groups\":[{\"args\":[],\"id\":101},{\"args\":[],\"id\":201},{\"args\":[],\"id\":301}]}},{\"id\":10018,\"no\":12,\"st\":1,\"talent\":{\"groups\":[{\"args\":[],\"id\":101},{\"args\":[],\"id\":201},{\"args\":[],\"id\":301}]}},{\"id\":10019,\"no\":13,\"st\":1,\"talent\":{\"groups\":[{\"args\":[],\"id\":101},{\"args\":[],\"id\":201},{\"args\":[],\"id\":301}]}},{\"id\":20001,\"no\":14,\"st\":1,\"talent\":{\"groups\":[{\"args\":[],\"id\":101},{\"args\":[],\"id\":201},{\"args\":[],\"id\":301}]}},{\"id\":20002,\"no\":15,\"st\":1,\"talent\":{\"groups\":[{\"args\":[],\"id\":101},{\"args\":[],\"id\":201},{\"args\":[],\"id\":301}]}},{\"id\":20003,\"no\":16,\"st\":1,\"talent\":{\"groups\":[{\"args\":[],\"id\":101},{\"args\":[],\"id\":201},{\"args\":[],\"id\":301}]}},{\"id\":20004,\"no\":17,\"st\":1,\"talent\":{\"groups\":[{\"args\":[],\"id\":101},{\"args\":[],\"id\":201},{\"args\":[],\"id\":301}]}},{\"id\":20005,\"no\":18,\"st\":1,\"talent\":{\"groups\":[{\"args\":[],\"id\":101},{\"args\":[],\"id\":201},{\"args\":[],\"id\":301}]}},{\"id\":20006,\"no\":19,\"st\":1,\"talent\":{\"groups\":[{\"args\":[],\"id\":101},{\"args\":[],\"id\":201},{\"args\":[],\"id\":301}]}},{\"id\":20007,\"no\":20,\"st\":1,\"talent\":{\"groups\":[{\"args\":[],\"id\":101},{\"args\":[],\"id\":201},{\"args\":[],\"id\":301}]}},{\"id\":20008,\"no\":21,\"st\":1,\"talent\":{\"groups\":[{\"args\":[],\"id\":101},{\"args\":[],\"id\":201},{\"args\":[],\"id\":301}]}},{\"id\":20009,\"no\":22,\"st\":1,\"talent\":{\"groups\":[{\"args\":[],\"id\":101},{\"args\":[],\"id\":201},{\"args\":[],\"id\":301}]}},{\"id\":20010,\"no\":23,\"st\":1,\"talent\":{\"groups\":[{\"args\":[],\"id\":101},{\"args\":[],\"id\":201},{\"args\":[],\"id\":301}]}},{\"id\":20011,\"no\":24,\"st\":1,\"talent\":{\"groups\":[{\"args\":[],\"id\":101},{\"args\":[],\"id\":201},{\"args\":[],\"id\":301}]}},{\"id\":20012,\"no\":25,\"st\":1,\"talent\":{\"groups\":[{\"args\":[],\"id\":101},{\"args\":[],\"id\":201},{\"args\":[],\"id\":301}]}},{\"id\":20013,\"no\":26,\"st\":1,\"talent\":{\"groups\":[{\"args\":[],\"id\":101},{\"args\":[],\"id\":201},{\"args\":[],\"id\":301}]}}]","roleId":36030446286411906,"size":0,"type":0},{"extData":"","id":36030446286411906,"packetData":"[{\"c\":10,\"i\":100},{\"c\":10,\"i\":101}]","roleId":36030446286411906,"size":0,"type":1},{"extData":"","id":36030446286411906,"packetData":"[{\"a\":\"2:2|4:4|3:2|5:2\",\"c\":1,\"i\":20001,\"ma\":\"1:1\",\"no\":1,\"set\":3},{\"a\":\"3:4|5:2|1:4|4:2\",\"c\":1,\"i\":20002,\"ma\":\"1:2\",\"no\":2,\"set\":3},{\"a\":\"1:3|2:4|3:2|4:2\",\"c\":1,\"i\":20003,\"ma\":\"1:3\",\"no\":3,\"set\":2},{\"a\":\"3:4|1:3|4:2|2:2\",\"c\":1,\"i\":20004,\"ma\":\"1:4\",\"no\":4,\"set\":1},{\"a\":\"1:3|4:3|5:2|3:3\",\"c\":1,\"i\":20005,\"ma\":\"1:5\",\"no\":5,\"set\":3},{\"a\":\"1:2|2:4|3:4|4:3\",\"c\":1,\"i\":20006,\"ma\":\"1:6\",\"no\":6,\"set\":1}]","roleId":36030446286411906,"size":0,"type":2},{"extData":"","id":36030446286411906,"packetData":"[]","roleId":36030446286411906,"size":0,"type":3}]
query3 table 1:
[{"chapterId":1,"gold":0,"id":36030446286411906,"openData":"[{\"id\":1,\"lv\":0}]","overData":"[]","roleId":36030446286411906,"status":0},{"chapterId":101,"gold":0,"id":36030446286411906,"openData":"[{\"id\":10101,\"lv\":0}]","overData":"[]","roleId":36030446286411906,"status":0},{"chapterId":102,"gold":0,"id":36030446286411906,"openData":"[{\"id\":10201,\"lv\":0}]","overData":"[]","roleId":36030446286411906,"status":0}]
----------------------------------------------------------------
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