[teiid-issues] [JBoss JIRA] (TEIID-4753) Designer is not aware of the system schema "SYSADMIN"

[Tom Johnston (JIRA)]

Tom Johnston created TEIID-4753:
-----------------------------------

             Summary: Designer is not aware of the system schema "SYSADMIN"
                 Key: TEIID-4753
                 URL: https://issues.jboss.org/browse/TEIID-4753
             Project: Teiid
          Issue Type: Bug
         Environment:   Teiid Designer	10.0.2.Final-v20161108-1636-B72	org.teiid.designer.feature.feature.group	JBoss by Red Hat
            Reporter: Tom Johnston
            Assignee: Steven Hawkins


SELECT
                        a.*, b.TablesUsed, b.isPhysical
            FROM
                        (SELECT DISTINCT ((x.SchemaName || '.') || x.Name) AS FQN_Object, ((x.Uses_schemaName || '.') || x.Uses_Name) AS tablesUsed, y.isPhysical FROM SYSADMIN.Usage AS x, SYS.Schemas AS y WHERE (y.name = x.SchemaName) AND (x.schemaName NOT IN ('SYS', 'SYSADMIN')) ORDER BY ((x.SchemaName || '.') || x.Name)) AS a LEFT OUTER JOIN (SELECT DISTINCT ((x.SchemaName || '.') || x.Name) AS FQN_Object, ((x.Uses_schemaName || '.') || x.Uses_Name) AS tablesUsed, y.isPhysical FROM SYSADMIN.Usage AS x, SYS.Schemas AS y WHERE (y.Name = x.SchemaName) AND (x.schemaName NOT IN ('SYS', 'SYSADMIN')) ORDER BY ((x.SchemaName || '.') || x.Name)) AS B ON a.TablesUsed = b.FQN_Object

Results in

ERROR: Group does not exist: SYSADMIN.Usage AS x




--
This message was sent by Atlassian JIRA
(v7.2.3#72005)