[
https://issues.apache.org/jira/browse/TRAFODION-36?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14626415#comment-14626415
]
ASF GitHub Bot commented on TRAFODION-36:
-----------------------------------------
GitHub user anoopsharma00 opened a pull request:
https://github.com/apache/incubator-trafodion/pull/27
[TRAFODION-36] showddl does not show delimited names in ON subclause of
SALT clause
see JIRA for details.
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/anoopsharma00/incubator-trafodion fix1
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/incubator-trafodion/pull/27.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #27
----
commit a539c023ce8fa12ab5518defc1c21eb7974b1f4c
Author: Anoop Sharma <[email protected]>
Date: 2015-07-14T14:45:24Z
[TRAFODION-36] showddl does not correctly displays delimited names in SALT
clause
----
> showddl does not show delimited names in ON subclause of SALT clause
> --------------------------------------------------------------------
>
> Key: TRAFODION-36
> URL: https://issues.apache.org/jira/browse/TRAFODION-36
> Project: Apache Trafodion
> Issue Type: Bug
> Reporter: Anoop Sharma
> Assignee: Anoop Sharma
>
> showddl command shows details about a table. Generated
> create statement could be used to recreate the table.
> It currently does not put double quotes around columns in
> the ON clause of SALT expression.
> That results in CREATE LIKE, which internally uses showddl output,
> to fail if the specified column name is invalid without quotes.
> Here is an example to reproduce this issue:
> >>create table t ("a.a" int not null, b int not null, primary key("a.a", b))
> +>salt using 4 partitions on ("a.a");
> --- SQL operation complete.
> >>showddl t;
> CREATE TABLE TRAFODION.SEABASE.T
> (
> "a.a" INT NO DEFAULT NOT NULL NOT DROPPABLE
> , B INT NO DEFAULT NOT NULL NOT DROPPABLE
> , PRIMARY KEY ("a.a" ASC, B ASC)
> )
> SALT USING 4 PARTITIONS
> ON (a.a)
> ;
> --- SQL operation complete.
> >>create table tt like t;
> *** ERROR[15001] A syntax error occurred at or before:
> create table TRAFODION.SEABASE.TT ( "a.a"
> INT
> NO DEFAULT NOT NULL NOT DROPPABLE NOT
> SERIALIZED , "B" INT NO DEFAULT NOT NULL
> NO
> T DROPPABLE NOT
> SERIALIZED , PRIMARY KEY ("a.a" ASC, B ASC) ) SALT USING 4
> PARTITIONS
> ON (a.a);
> ^ (304 characters from start of SQL statement)
> *** ERROR[8822] The statement was not prepared.
> --- SQL operation failed with errors.
> >>
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
