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)