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

Posted to issues@metamodel.apache.org by "longxin (JIRA)" <ji...@apache.org> on 2018/11/12 07:32:00 UTC

[jira] [Closed] (METAMODEL-1202) Bad Query use limit and offset methods with Oracle.(oracle数据库分页查询返回结果错误)

     [ https://issues.apache.org/jira/browse/METAMODEL-1202?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

longxin closed METAMODEL-1202.
------------------------------
    Resolution: Not A Problem

> Bad Query use limit and offset methods with Oracle.(oracle数据库分页查询返回结果错误)
> ------------------------------------------------------------------------
>
>                 Key: METAMODEL-1202
>                 URL: https://issues.apache.org/jira/browse/METAMODEL-1202
>             Project: Apache MetaModel
>          Issue Type: Bug
>    Affects Versions: 5.1.0
>            Reporter: longxin
>            Priority: Critical
>
> 1) My database table :TEST_TEST
>  
> ||ID||NAME||
> |6|name6|
> |5|name5|
> |4|name4|
> |3|name3|
> |2|name2|
> |1|name1|
> 2)Query builder as:
> Schema defaultSchema = context.getDefaultSchema();
>  SatisfiedSelectBuilder<?> dataSelect = context.query()
>  .from("TEST_TEST")
>  .select("ID","NAME");
> SatisfiedQueryBuilder<?> limitQuery =
>           dataSelect.offset(2).limit(2);
> DataSet dataSet = limitQuery.excute();
> 3)Problem:
> expect to get row(ID：4) and row(ID:3), but get row(ID:2) and row(ID:1)



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)