[GitHub] [shardingsphere] duzhanfei commented on issue #7940: 【sharding-proxy】Actual SQL execution results are incorrect (data should have been returned, but no data was returned),

[GitBox]

duzhanfei commented on issue #7940:
URL: https://github.com/apache/shardingsphere/issues/7940#issuecomment-718330878


   @Lucas-307 
   I change my MyBatis select sql to Actual Sql and change url to 
jdbc:mysql://19.111.4.11:3306/db1?serverTimezone=UTC&useSSL=false ,the result 
is correct, data  been returned;
   
   <img width="564" alt="图片10" 
src="https://user-images.githubusercontent.com/46663706/97520796-00fa5180-19d7-11eb-8042-1f9b1a002dcd.png";>
   <img width="797" alt="图片11" 
src="https://user-images.githubusercontent.com/46663706/97520808-08215f80-19d7-11eb-8da0-2b0ea8ce2bf1.png";>
   <img width="894" alt="图片12" 
src="https://user-images.githubusercontent.com/46663706/97520817-0d7eaa00-19d7-11eb-9a59-313bd18b0269.png";>
   
   By the way,
   When I switched the data source from mysql to ShardingProxy, I just changed 
the datesouce configuration,
   Is there anything else 1  need to do, like import the corresponding 
dependencies


----------------------------------------------------------------
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:
us...@infra.apache.org