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

EDS ODBC query on a namespace ending in 'e' fails

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Obsolete
    • Icon: Major Major
    • None
    • 7.1.1
    • ODBC
    • None
    • Hide

      You can use LIKE 'select nspname from pg_catalog.pg_namespace where nspname LIKE 'LOOKHERE%'

      Show
      You can use LIKE 'select nspname from pg_catalog.pg_namespace where nspname LIKE 'LOOKHERE%'

      The attached testing vdb contains the following namespaces:
      LOOKHERE TestPG LOOKAGAIN

      If you run the following query via ODBC (JDBC works ):
      select nspname from pg_catalog.pg_namespace where nspname = 'LOOKHERE'

      It returns zero rows, but if you run the same query with 'LOOKAGAIN' in your criteria you get the one row, It seems that any namespace ending in an E doesn't match via ODBC.

            rhn-engineering-shawkins Steven Hawkins
            rhn-support-dsteigner Deborah Steigner (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: