You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "Atanu Mishra (JIRA)" <ji...@apache.org> on 2015/08/25 07:59:45 UTC

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

    [ https://issues.apache.org/jira/browse/TRAFODION-153?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14710647#comment-14710647 ] 

Atanu Mishra commented on TRAFODION-153:
----------------------------------------

Suresh Subbiah (suresh-subbiah) wrote on 2013-11-19:	#2
This is now fixed in v35740. INITIALIZE_SEABASE is no longer a compound token and therefore SEABASE is not a token that can occur as part of compund token. I had to make INITIALIZE_SQL a compound token instead. This should be OK since SQL is already a reserved word and we cannot have a catalog called SQL.

Changed in trafodion:
status:	New → Fix Committed
Weishiun Tsai (wei-shiun-tsai) wrote on 2013-12-03:	#3
Verified on a build from 12/02/2013, this problem has been fixed:

>>set schema trafodion.mytest;

--- SQL operation complete.
>>create table t (a int);

--- SQL operation complete.
>>showddl t;

CREATE TABLE TRAFODION.MYTEST.T
  (
    A INT DEFAULT NULL
  )
;

--- SQL operation complete.
>>showddl mytest.t;

CREATE TABLE TRAFODION.MYTEST.T
  (
    A INT DEFAULT NULL
  )
;

--- SQL operation complete.
>>showddl trafodion.mytest.t;

CREATE TABLE TRAFODION.MYTEST.T
  (
    A INT DEFAULT NULL
  )
;

--- SQL operation complete.

Changed in trafodion:
status:	Fix Committed → Fix Released


> 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
>            Assignee: Suresh Subbiah
>             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)