]
Tom Johnston commented on TEIIDDES-3038:
----------------------------------------
I just tested JBDS Version: 10.3.0.GA
Build id: GA-v20170218-1636-B94
Build date: 20170218-1636
With Teiid
Designer 11.0.1.Final-v20170208-2046-B4143 org.teiid.designer.feature.feature.group JBoss
by Red Hat
And still the error:
Designer is not aware of the system schema "SYSADMIN"
-----------------------------------------------------
Key: TEIIDDES-3038
URL:
https://issues.jboss.org/browse/TEIIDDES-3038
Project: Teiid Designer
Issue Type: Bug
Affects Versions: 10.0.2
Environment: Teiid
Designer 10.0.2.Final-v20161108-1636-B72 org.teiid.designer.feature.feature.group JBoss by
Red Hat
Reporter: Tom Johnston
Assignee: Barry LaFond
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