[GitHub] [shardingsphere] DongJigong commented on issue #6219: spring boot mybatis pageHelper query with a string date-time occur error

2020-06-30 Thread GitBox 


DongJigong commented on issue #6219:
URL: https://github.com/apache/shardingsphere/issues/6219#issuecomment-652202311


   > @DongJigong Hi thanks for your feedback. :-)
   > 
   > Since I can not check your images well (Maybe due to my internet, not 
sure.), I can not settle the conclusion.
   > So
   > Q1 Could ShardingSphere and page helper work together?
   > Q2 Do the users need to modify SQL? Such as `# and $`?
   > 
   > > 
![image](https://user-images.githubusercontent.com/8855265/86102922-b6330080-baee-11ea-9fe7-faa3245e999b.png)
   > > If I change to this way below it works fine.
   > > 
![image](https://user-images.githubusercontent.com/8855265/86103114-eda1ad00-baee-11ea-909d-611b314501a3.png)
   > > `# and $`
   
   Yes, if I change the symbol '#' to '$', it works fine. I guess maybe a 
sharding bug, but I am not sure.



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

[GitHub] [shardingsphere] DongJigong commented on issue #6219: spring boot mybatis pageHelper query with a string date-time occur error

2020-06-30 Thread GitBox 


DongJigong commented on issue #6219:
URL: https://github.com/apache/shardingsphere/issues/6219#issuecomment-651642260


   
![image](https://user-images.githubusercontent.com/8855265/86102922-b6330080-baee-11ea-9fe7-faa3245e999b.png)
   If I change to this way below it works fine.
   
![image](https://user-images.githubusercontent.com/8855265/86103114-eda1ad00-baee-11ea-909d-611b314501a3.png)
   # and $ 



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