[jira] [Closed] (TRAFODION-272) LP Bug: 1320023 - Create table .. like .. store by () does not recognize column

["Atanu Mishra (JIRA)" <ji...@apache.org>]

     [ 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)