Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-4238

Remove need for quotes around cursor name declarations/fetches

    XMLWordPrintable

Details

    • Enhancement
    • Resolution: Done
    • Major
    • 9.1, 8.7.8.6_2, 8.12.6.6_3
    • None
    • ODBC
    • None

    Description

      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" ...

      Attachments

        Activity

          People

            rhn-engineering-shawkins Steven Hawkins
            rhn-support-mshirley Marc Shirley (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: