[jira] [Closed] (TRAFODION-153) LP Bug: 1251091 - showddl does not take catalog in the qualified name

["Atanu Mishra (JIRA)" <ji...@apache.org>]

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

Atanu Mishra closed TRAFODION-153.
----------------------------------
       Resolution: Fixed
         Assignee:     (was: Suresh Subbiah)
    Fix Version/s: 0.8 (pre-incubation)

> LP Bug: 1251091 - showddl does not take catalog in the qualified name
> ---------------------------------------------------------------------
>
>                 Key: TRAFODION-153
>                 URL: https://issues.apache.org/jira/browse/TRAFODION-153
>             Project: Apache Trafodion
>          Issue Type: Bug
>          Components: sql-general
>            Reporter: Weishiun Tsai
>             Fix For: 0.8 (pre-incubation)
>
>
> Showddl does not take catalog name as part of the qualified name.  It returns 15001 syntax error, as shown in the following example:
> >>set schema seabase.mytest;
> --- SQL operation complete.
> >>create table t (a int);
> --- SQL operation complete.
> >>showddl t;
> CREATE TABLE SEABASE.MYTEST.T
>   (
>     A                                INT DEFAULT NULL
>   )
> ;
> --- SQL operation complete.
> >>showddl mytest.t;
> CREATE TABLE SEABASE.MYTEST.T
>   (
>     A                                INT DEFAULT NULL
>   )
> ;
> --- SQL operation complete.
> >>showddl seabase.mytest.t;
> *** ERROR[15001] A syntax error occurred at or before:
> showddl seabase.mytest.t;
>               ^ (15 characters from start of SQL statement)
> *** ERROR[8822] The statement was not prepared.



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