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 2019/09/25 06:42:15 UTC

[GitHub] [incubator-shardingsphere] ianqiu850 commented on issue #3111: single table query limit bug

ianqiu850 commented on issue #3111: single table query limit bug 
URL: https://github.com/apache/incubator-shardingsphere/issues/3111#issuecomment-534878179
 
 
   single table query （such as ）, always starts at 0
   SQL : ds_0 ::: SELECT act_cmnt_2.*, user_info.info_name, user_info.info_photo FROM act_cmnt_2 INNER JOIN user_info ON act_cmnt_2.user_id = user_info.user_id WHERE ac_fkid = ? AND ac_type = ? AND ac_mark = ? ORDER BY ac_utime DESC LIMIT ?, ? ::: [[ 22, 1, 1, 0, 3 ]]
   
   act_cmnt_${ac_fkid % 10}

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