[
https://issues.jboss.org/browse/TEIIDDES-2213?page=com.atlassian.jira.plu...
]
Mark Drilling resolved TEIIDDES-2213.
-------------------------------------
Release Notes Docs Status: Documented as Known Issue
Release Notes Text:
Known Issue:
- For PostgreSQL drivers prior to 9.3, a bug exists for import of the described
procedures. For pre-9.3 drivers, the resultset params are erroneously all returned as IN
parameters. The workaround is to manually edit the imported procedure for pre-9.3 driver
import
Resolution: Done
- Adds code fix to account for PostgreSQL 9.3 driver bug. For certain procedure types
described above, the 9.3 driver will return multiple return parameters. The code change
in the importer will detect if multiple return params exist and if so will put them in a
resultSet.
https://github.com/Teiid-Designer/teiid-designer/pull/421
Known Issue:
- For PostgreSQL drivers prior to 9.3, a bug also exists for same type of procedures. For
pre-9.3 drivers, the params are erroneously all returned as IN parameters. We should have
a known issue for that.
JDBC Importer with PostgreSQL function that returns table imports
parameters incorrectly
----------------------------------------------------------------------------------------
Key: TEIIDDES-2213
URL:
https://issues.jboss.org/browse/TEIIDDES-2213
Project: Teiid Designer
Issue Type: Bug
Components: Import/Export
Affects Versions: 8.3.2
Reporter: Debbie Steigner
Assignee: Mark Drilling
Fix For: 8.6.1, 9.0.1, 9.0
Using the JDBC Importer on a PostgreSQL Function that RETURNS TABLE the columns that are
returned when running the function are imported as input parameters not as resultset.
--
This message was sent by Atlassian JIRA
(v6.3.8#6338)