Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-1023

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

    Details

    • Type: Task
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: 7.0
    • Component/s: Connector API
    • Labels:
      None
    • Affects:
      Documentation (Ref Guide, User Guide, etc.)
    • Estimated Difficulty:
      Low

      Description

      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".

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                shawkins Steven Hawkins
                Reporter:
                rareddy Ramesh Reddy
              • Votes:
                0 Vote for this issue
                Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: