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

[Debbie Steigner (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-4245?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13262949#comment-13262949 ] 

Debbie Steigner commented on TEIID-4245:
----------------------------------------

Customer requested all of the below syntax be supported, can these be added as well?

FETCH LAST FROM cursor_name

FETCH ABSOLUTE fetch_when FROM cursor_name

FETCH RELATIVE fetch_when FROM cursor_name

FETCH cursor_name

FETCH FIRST FROM cursor_name

> 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
>             Fix For: 9.1, 8.7.8.6_2
>
>
> 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)