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

Add support for information_schema namespace

    Details

    • Type: Bug
    • Status: Open (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: 10.2
    • Component/s: ODBC, Query Engine
    • Labels:
      None
    • Steps to Reproduce:
      Hide

      Execute following queries

      SELECT table_catalog, table_schema, table_name, table_type FROM information_schema.tables

      SELECT table_catalog, table_schema, table_name, column_name, ordinal_position, column_default,
      is_nullable, udt_name AS data_type, character_maximum_length, character_octet_length,
      numeric_precision, numeric_precision_radix, numeric_scale, datetime_precision, character_set_catalog,
      character_set_schema, character_set_name, collation_catalog
      FROM information_schema.columns

      SELECT table_catalog, table_schema, table_name, check_option, is_updatable FROM information_schema.views

      Show
      Execute following queries SELECT table_catalog, table_schema, table_name, table_type FROM information_schema.tables SELECT table_catalog, table_schema, table_name, column_name, ordinal_position, column_default, is_nullable, udt_name AS data_type, character_maximum_length, character_octet_length, numeric_precision, numeric_precision_radix, numeric_scale, datetime_precision, character_set_catalog, character_set_schema, character_set_name, collation_catalog FROM information_schema.columns SELECT table_catalog, table_schema, table_name, check_option, is_updatable FROM information_schema.views

      Description

      The npgsql provider uses the the infomation_schema namespace to query meta information for tables and views.

      Add support for information_schema.tables (
      https://www.postgresql.org/docs/10/static/infoschema-tables.html) to teiid

      Add support for information_schema.views (
      https://www.postgresql.org/docs/10/static/infoschema-views.html) to teiid

      Add support for information_schema.columns (
      https://www.postgresql.org/docs/10/static/infoschema-columns.html) to teiid

        Gliffy Diagrams

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  shawkins Steven Hawkins
                  Reporter:
                  dvallabh_doi Divyesh Vallabh
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  1 Start watching this issue

                  Dates

                  • Created:
                    Updated: