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/11/27 07:02:32 UTC

[GitHub] [shardingsphere] huangpang opened a new issue #8374: Shrdingsphere 4.1.1 cannot be paged

huangpang opened a new issue #8374:
URL: https://github.com/apache/shardingsphere/issues/8374


   I upgraded from 4.0.0-rc1 to 4.1.1
   
   After upgrading to 4.1.1, it is found that the normal business function (paging query) cannot be used
   
   Because we operate on mybatis-plus, we will count first and then perform paging query
   
   Observe the log, and find that count has normal table splitting
   
   The SQL statement is: select count (*) from t_ Xx_ 202011 hundred and two thousand and eleven
   
   However, when querying data, there is no correct sub table, or the previous table is queried, resulting in the data can not be found out
   
   After continuous debugging and tracking, it is found that the SQL parser engine logic in 4.1.1 has rewritten?
   
   Test SQL :   Cannot resolve get condition
   `
   SELECT * FROM ( SELECT TMP.*, ROWNUM ROW_ID FROM ( SELECT  *  FROM T_LOG_FWRZ 
    WHERE id = ? AND kssj BETWEEN ? AND ? ORDER BY kssj DESC ) TMP WHERE ROWNUM <=?) WHERE ROW_ID > ?
   `
   ![image](https://user-images.githubusercontent.com/31001984/100420295-26a37500-30c1-11eb-81c9-4a424fcf7e9f.png)
   
   -----
   Test SQL:   OK
   `SELECT  *  FROM T_LOG_FWRZ     WHERE id = ? AND kssj BETWEEN ? AND ? ORDER BY kssj DESC`
   
   ![image](https://user-images.githubusercontent.com/31001984/100420315-30c57380-30c1-11eb-89ae-7280b3b96547.png)
   
   ------
   
   What can I do now? Thank you
   
   


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

[GitHub] [shardingsphere] huangpang closed issue #8374: Shrdingsphere 4.1.1 cannot be paged

Posted by GitBox <gi...@apache.org>.
huangpang closed issue #8374:
URL: https://github.com/apache/shardingsphere/issues/8374


   


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