[
https://issues.apache.org/jira/browse/TRAFODION-272?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14708646#comment-14708646
]
Atanu Mishra commented on TRAFODION-272:
----------------------------------------
Anoop Sharma (anoop-sharma) on 2014-05-30
Changed in trafodion:
status: In Progress → Fix Committed
Weishiun Tsai (wei-shiun-tsai) wrote on 2014-05-30: #1
Verified on the GIT 0529_1530 build. This problem has been fixed:
-bash-4.1$ sqlci
Trafodion Conversational Interface 0.7.0
(c) Copyright 2014 Hewlett-Packard Development Company, LP.
>>create table t (a int not null not droppable primary key, b int);
--- SQL operation complete.
>>create table t1 like t store by (a);
--- SQL operation complete.
Changed in trafodion:
status: Fix Committed → Fix Released
> LP Bug: 1320023 - Create table .. like .. store by () does not recognize
> column
> -------------------------------------------------------------------------------
>
> Key: TRAFODION-272
> URL: https://issues.apache.org/jira/browse/TRAFODION-272
> Project: Apache Trafodion
> Issue Type: Bug
> Components: sql-exe
> Reporter: Weishiun Tsai
> Assignee: Anoop Sharma
> Priority: Critical
> Fix For: 0.8 (pre-incubation)
>
>
> Create table .. like .. store by () does not recognize column names from the
> first table. As shown in the following output, when specifying column a in
> the store by clause, it returns error 1009.
> This is seen on the datalake v40535 build.
> >>create table t (a int not null not droppable primary key, b int);
> --- SQL operation complete.
> >>create table t1 like t store by (a);
> *** ERROR[1009] Column A does not exist in the specified table.
> --- SQL operation failed with errors.
> Here is the same sequence of statements run on SQ:
> >>create table t (a int not null not droppable primary key, b int);
> --- SQL operation complete.
> >>create table t1 like t store by (a);
> --- SQL operation complete.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
