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

jdbc native query issues

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Major
    • 8.2
    • 7.7
    • None
    • 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

            rhn-engineering-shawkins Steven Hawkins
            rhn-engineering-shawkins Steven Hawkins
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: