[
https://issues.apache.org/jira/browse/TRAFODION-272?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Atanu Mishra closed TRAFODION-272.
----------------------------------
Resolution: Fixed
Assignee: (was: Anoop Sharma)
Fix Version/s: 0.8 (pre-incubation)
> 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
> 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)
