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

jdbc native query issues

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Done
    • Affects Version/s: 7.7
    • Fix Version/s: 8.2
    • Component/s: None
    • Labels:
      None

      Description

      A non-prepared procedure only works if the procedure has no parameters. It should be allowed to work even with parameters through literal substitution.

      Also the parsing loop incorrectly increments the parsing position after a match. This means that the character after a positional reference is lost. The workaround for typical scenarios would be to use extra whitespace. i.e.

      instead of

      select * from tbl where x = $1 and y = $2

      use

      select * from tbl where x = $1  and y = $2

      Note the extra space after $1.

        Attachments

          Activity

            People

            Assignee:
            shawkins Steven Hawkins
            Reporter:
            shawkins Steven Hawkins
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: