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

[Steven Hawkins (JIRA)]

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

Steven Hawkins commented on TEIID-4207:
---------------------------------------

Yes, you want to remove the supportsRowLimit or return false with a comment on why.

In the sql string logic we can still set the SimpleDB limit, but as Ramesh says it would be based upon the batch size instead.  It looks like SimpleDB has some limitations in how large the limit can be, so we may only want to use up to 2500 - http://docs.aws.amazon.com/AmazonSimpleDB/latest/DeveloperGuide/UsingSelect.html

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