[teiid-issues] [JBoss JIRA] (TEIID-4245) Add support for fetch syntax "FETCH cursorname"

[Marc Shirley (JIRA)]

Marc Shirley created TEIID-4245:
-----------------------------------

             Summary: Add support for fetch syntax "FETCH cursorname"
                 Key: TEIID-4245
                 URL: https://issues.jboss.org/browse/TEIID-4245
             Project: Teiid
          Issue Type: Feature Request
          Components: ODBC
            Reporter: Marc Shirley
            Assignee: Steven Hawkins


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



--
This message was sent by Atlassian JIRA
(v6.4.11#64026)