[teiid-issues] [JBoss JIRA] (TEIID-4123) Issues with odbc metadata

[Steven Hawkins (JIRA)]

Steven Hawkins created TEIID-4123:
-------------------------------------

             Summary: Issues with odbc metadata
                 Key: TEIID-4123
                 URL: https://issues.jboss.org/browse/TEIID-4123
             Project: Teiid
          Issue Type: Bug
          Components: Query Engine
    Affects Versions: 8.7
            Reporter: Steven Hawkins
            Assignee: Steven Hawkins
             Fix For: 9.0, 8.12.5, 8.13.4


The values that we are sending the client for atttypmod in the column when using cursoring results in the pg odbc client reissuing the column metadata query for most column types.  Since the column metadata query is not that performant - TEIID-4122 - this results in significant overhead for wide selects.

We also don't have a pg_type entry for varbinary and may need to add more array types.



--
This message was sent by Atlassian JIRA
(v6.4.11#64026)