BeeKun opened a new issue #11616:
URL: https://github.com/apache/shardingsphere/issues/11616


   ## Question
   
   i use pageHelper count pageSize,my sql use group by at last.
   
   exception :
   
   ### SQL: SELECT count(0) FROM (SELECT `user_wid` FROM 
t_scrm_call_record_statistics WHERE is_delete = 0 AND device_type != 0 AND pid 
= ? AND statistics_date >= ? AND statistics_date <= ? AND user_wid IN (?) GROUP 
BY user_wid) table_count
   ### Cause: java.lang.IllegalStateException: Must have sharding column with 
subquery.
   
   pom maven version  4.0.1
   
   
   


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

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


Reply via email to