[teiid-issues] [JBoss JIRA] (TEIID-2098) Caching does not interact well with Statement.setMaxRows

Wed Jul 11 16:05:12 EDT 2012

Steven Hawkins created TEIID-2098:
-------------------------------------

             Summary: Caching does not interact well with Statement.setMaxRows
                 Key: TEIID-2098
                 URL: https://issues.jboss.org/browse/TEIID-2098
             Project: Teiid
          Issue Type: Feature Request
          Components: Query Engine
    Affects Versions: 7.0
            Reporter: Steven Hawkins
            Assignee: Steven Hawkins
             Fix For: 8.1

Most of the time setting maxRows will cause the plan to not be cachable and the results will be cached/reused regardless of what subsequent maxRows are set to.

Finally a general issue is that if the query cannot have maxRows set as a limit (if there is already a limit or it's a procedure call) then the maxRows is ignored.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira