[
https://issues.jboss.org/browse/TEIID-4245?page=com.atlassian.jira.plugin...
]
Debbie Steigner commented on TEIID-4245:
----------------------------------------
Steve - Can I make that 1 JIRA or do you want 1 for each first, last, absolute and
relative?
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)