Uploaded image for project: 'Teiid Designer'
  1. Teiid Designer
  2. TEIIDDES-923

Passing NULL into a Procedure in Preview Causes Exception

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Major Major
    • 7.7
    • 7.4
    • Data Preview
    • None

      I have a virtual procedure that accepts one parameter that may be null. When I pass a value in it works fine but when I check the NULL checkbox fir the input variable I get the following exception, "Remote org.teiid.api.exception.query.QueryValidatorException: Bind variables (represented as "?") were found but are allowed only in prepared or callable statements."

      Here is the generated query from preview: select * from ( exec RestfulBooks.getBooks ) AS X_X

              mdrillin1@redhat.com Mark Drilling (Inactive)
              rhn-engineering-tejones Edwin Jones
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Created:
                Updated:
                Resolved: