[
https://issues.jboss.org/browse/TEIID-4238?page=com.atlassian.jira.plugin...
]
Steven Hawkins commented on TEIID-4238:
---------------------------------------
The quotes should be optional
That is correct, but this is not a but in that the current code is based upon the pg odbc
client, which always quotes. Is this to support a different client or just a general
request?
Remove need for quotes around cursor name declarations/fetches
--------------------------------------------------------------
Key: TEIID-4238
URL:
https://issues.jboss.org/browse/TEIID-4238
Project: Teiid
Issue Type: Bug
Reporter: Marc Shirley
Assignee: Steven Hawkins
Attempting to declare a cursor without quotes results in an error similar to[1]. The
quotes should be optional except in special cases, as this seems to match later standards
(SQL2003). Performing fetch operations against the cursor have the same issue, where if
the cursorname is not quoted, parsing errors occur.
[1] Caused by: org.teiid.api.exception.query.QueryParserException: TEIID31100 Parsing
error: Encountered "[*]DECLARE[*] cursorname CURSOR" 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)