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.