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.

        Gliffy Diagrams

          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: