You are viewing a plain text version of this content. The canonical link for it is here.

Posted to notifications@shardingsphere.apache.org by "wjtien (via GitHub)" <gi...@apache.org> on 2023/03/24 08:58:24 UTC

[GitHub] [shardingsphere] wjtien commented on issue #24460: SQLServer 2012 page query java.lang.IndexOutOfBoundsException: Index: 2, Size: 2

wjtien commented on issue #24460:
URL: https://github.com/apache/shardingsphere/issues/24460#issuecomment-1482460723

   https://shardingsphere.apache.org/document/current/cn/features/sharding/limitation/
   
   分页查询
   Oracle 和 SQLServer 由于分页查询较为复杂，目前有部分分页查询不支持，具体如下：
   
   Oracle
   目前不支持 rownum + BETWEEN 的分页方式。
   
   SQLServer
   目前不支持使用 WITH xxx AS (SELECT …) 的方式进行分页。由于 Hibernate 自动生成的 SQLServer 分页语句使用了 WITH 语句，因此目前并不支持基于 Hibernate 的 SQLServer 分页。 目前也不支持使用两个 TOP + 子查询的方式实现分页。
   
   不知道是不是，但是你也没有with啊。。


-- 
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: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org