[teiid-issues] [JBoss JIRA] Created: (TEIID-1023) Chanage "MaxResultRows" Connector Property to default to "unlimited"

[Ramesh Reddy (JIRA)]

Chanage "MaxResultRows" Connector Property to default to "unlimited"
--------------------------------------------------------------------

                 Key: TEIID-1023
                 URL: https://jira.jboss.org/jira/browse/TEIID-1023
             Project: Teiid
          Issue Type: Task
          Components: Connector API
            Reporter: Ramesh Reddy
             Fix For: 7.0


Teiid supports a property called "MaxResultRows" in Connector
properties, which defaults to 10,000 rows. The expected behavior of this
is to throw an exception when user queries more than 10,000 rows through
this connector.

However, this default behavior seems like a exceptional condition than
normal behavior expected by user any time. This *was* designed more for
the development time aid than the runtime.

Here is an example of community user tripping over it.
http://community.jboss.org/message/532560#532560

I propose, we change the default value of this property to "-1" that
means the "MaxResultRows" will be set to "unlimited" in the default
scenario. If user requires to restrict max rows they can *explicitly*
set a value that they are comfortable with.

Note the default "unlimited" is value changed from "0" to "-1".

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira