How can I implement an optional input parameter for a virtual procedure in DV
Issue
- Stored procedures not properly handling nullable inputs
- Error: org.teiid.jdbc.TeiidSQLException: Remote org.teiid.api.exception.query.QueryPlannerException: No valid criteria specified for procedure parameter myModel.inputParameter, SQL State: 50000, Error Code: 0
- Virtual procedure requiring a value in the input parameter, even though it is modeled as NULLABLE
- Error: org.teiid.jdbc.TeiidSQLException: Remote org.teiid.api.exception.query.QueryPlannerException: Join region with unsatisfied access patterns cannot be satisfied by the join criteria, Access patterns: [Access Pattern: Unsatisfied [...] History [[...]]] , SQL State: 50000, Error Code: 0"
Environment
- Red Hat JBoss Data Virtualization (DV) 6.3
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.