Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-4123

Issues with odbc metadata

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Major
    • 9.0, 8.12.5, 8.13.4
    • 8.7
    • Query Engine
    • None

    Description

      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.

      Attachments

        Activity

          People

            rhn-engineering-shawkins Steven Hawkins
            rhn-engineering-shawkins Steven Hawkins
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: