]
Steven Hawkins resolved TEIID-4123.
-----------------------------------
Resolution: Done
Updated the logic to be more selective in setting the typmod and added types for varbinary
and its array type.
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.