[teiid-issues] [JBoss JIRA] (TEIID-4238) Remove need for quotes around cursor name declarations/fetches

[Steven Hawkins (JIRA)]

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

Steven Hawkins edited comment on TEIID-4238 at 6/1/16 3:01 PM:
---------------------------------------------------------------

>  The quotes should be optional

That is correct, but this is not a bug 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?


was (Author: shawkins):
>  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: Enhancement
>          Components: ODBC
>            Reporter: Marc Shirley
>            Assignee: Steven Hawkins
>             Fix For: 9.1
>
>
> 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)