[jira] [Resolved] (TRAFODION-1793) GET commands that report usage information should return 3 or 2 part ansi object names

["Anoop Sharma (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/TRAFODION-1793?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Anoop Sharma resolved TRAFODION-1793.
-------------------------------------
       Resolution: Fixed
    Fix Version/s: 2.0-incubating

Fixed:

>>create view v as select * from seabase.t, sch.t;

--- SQL operation complete.
>>get tables in view v;

Tables in View SCH.V
====================

SCH.T
SEABASE.T

--- SQL operation complete.
>>


> GET commands that report usage information should return 3 or 2 part ansi object names
> --------------------------------------------------------------------------------------
>
>                 Key: TRAFODION-1793
>                 URL: https://issues.apache.org/jira/browse/TRAFODION-1793
>             Project: Apache Trafodion
>          Issue Type: Bug
>            Reporter: Venkat Muthuswamy
>            Assignee: Anoop Sharma
>             Fix For: 2.0-incubating
>
>
> Let's see we create a view that joins 2 tables from different schemas.
> CREATE VIEW TRAFODION.SCH.V1 AS
>   SELECT 1 AS Z FROM TRAFODION.SCH.T, TRAFODION.SEABASE.T ;
> Now if we try to get the tables used by V1 using this command, it just returns the object names and it is difficult to say which object is which since the schema information is missing.
> get tables in view v1;
> It returns :
> >>get tables in view v1;
> Tables in View SCH.V1
> =====================
> T
> T
> It would be good if the GET commands can return the 3 or 2 part ansi name of the object.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)