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

["Alice Chen (JIRA)" <ji...@apache.org>]

Alice Chen created TRAFODION-272:
------------------------------------

             Summary: 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


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)