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

Add support for fetch syntax "FETCH cursorname"

    XMLWordPrintable

Details

    • Feature Request
    • Resolution: Done
    • Major
    • 9.1, 8.7.8.6_2, 8.12.6.6_3
    • None
    • ODBC
    • None

    Description

      Executing syntax "FETCH cursorname" results in parsing error like [1]. Instead, syntax like "FETCH 1 IN cursorname" has been used as a workaround.

      [1]
      org.teiid.api.exception.query.QueryParserException: TEIID31100 Parsing error: Encountered "[*]FETCH[*] mycursor" at line 1, column 1.
      Was expecting: "alter" | "begin" | "call" | "create" | "delete" | "drop" | "exec" | "execute" | "insert" | "merge" ...

      Attachments

        Activity

          People

            rhn-engineering-shawkins Steven Hawkins
            rhn-support-mshirley Marc Shirley (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: