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

Selecting from SYS model throws exception

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Done
    • Affects Version/s: 7.4
    • Fix Version/s: 8.4
    • Component/s: None
    • Labels:
      None
    • Environment:

      Teiid 8.3 running in JBoss EAP 6.0 RPM install

      java version "1.7.0_09-icedtea"
      OpenJDK Runtime Environment (rhel-2.3.8.0.el6_4-x86_64)
      OpenJDK 64-Bit Server VM (build 23.7-b01, mixed mode)

    • Workaround:
      Workaround Exists
    • Workaround Description:
      Hide

      If possible do not include the source pg catalogs (filter/exlcude them via the import settings).

      Show
      If possible do not include the source pg catalogs (filter/exlcude them via the import settings).

      Description

      We have a dynamic vdb deployed into our Teiid 8.3 environment, but whenever we connect to the vdb via the pgsql emulation socket using the standard postgresql tools, and attempt to select any value from any tables in the SYS scheama, we are given an error

      TestVDB=> select * from sys.keys;
      ERROR:  Group specified is ambiguous, resubmit the query by fully qualifying the group name: pg_attribute
      DETAIL:  org.teiid.jdbc.TeiidSQLException: Group specified is ambiguous, resubmit the query by fully qualifying the group name: pg_attribute
      TestVDB=> select * from sys.columns;
      ERROR:  Group specified is ambiguous, resubmit the query by fully qualifying the group name: pg_attribute
      DETAIL:  org.teiid.jdbc.TeiidSQLException: Group specified is ambiguous, resubmit the query by fully qualifying the group name: pg_attribute
      TestVDB=> select * from sys.tables;
      ERROR:  Group specified is ambiguous, resubmit the query by fully qualifying the group name: pg_attribute
      DETAIL:  org.teiid.jdbc.TeiidSQLException: Group specified is ambiguous, resubmit the query by fully qualifying the group name: pg_attribute
      TestVDB=>
      

      It looks like the teiid parser is getting confused somehow with multiple pg_attribute fields on those tables or something.

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                shawkins Steven Hawkins
                Reporter:
                graeme.gillies Graeme Gillies
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: