[teiid-issues] [JBoss JIRA] (TEIID-4207) Limit pushdown is incorrect for simpledb

[Tugba Dogan (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-4207?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13242467#comment-13242467 ] 

Tugba Dogan commented on TEIID-4207:
------------------------------------

I checked the connector's source code.There are 2 options to solve this issue:
* We can remove the limit support by removing the following lines. 
{code:java}
@Override
public boolean supportsRowLimit() {
    return true;
}
{code}

{code:java}
if (!useSelectLimit() && obj.getLimit() != null) {
    buffer.append(Tokens.SPACE);
    append(obj.getLimit());
}
{code}

* We don't know how many rows will be in each page so we can count the retrieved rows and we can return limited rows. 

> Limit pushdown is incorrect for simpledb
> ----------------------------------------
>
>                 Key: TEIID-4207
>                 URL: https://issues.jboss.org/browse/TEIID-4207
>             Project: Teiid
>          Issue Type: Bug
>          Components: Misc. Connectors
>    Affects Versions: 8.7
>            Reporter: Steven Hawkins
>            Assignee: Tugba Dogan
>             Fix For: 9.0, 8.12.5, 8.13.5
>
>
> The limit clause for simpledb sets a page size rather than fully limiting results, thus our pushdown is incorrect.



--
This message was sent by Atlassian JIRA
(v6.4.11#64026)