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

[Steven Hawkins (JIRA)]

     [ https://issues.jboss.org/browse/TEIID-4245?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steven Hawkins resolved TEIID-4245.
-----------------------------------
    Resolution: Done


Added support for just fetch cursor name and added better handling for exceptions in the odbc layer (such as parsing errors with the regex).  Will work the unquoted cursor names as part of TEIID-4238

> 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
>
>
> 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)