[jira] [Created] (TRAFODION-136) LP Bug: 1244845 - CREATE TABLE ... SALT_BUCKETS=... returns error 15001

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

Alice Chen created TRAFODION-136:
------------------------------------

             Summary: LP Bug: 1244845 - CREATE TABLE ... SALT_BUCKETS=... returns error 15001
                 Key: TRAFODION-136
                 URL: https://issues.apache.org/jira/browse/TRAFODION-136
             Project: Apache Trafodion
          Issue Type: Bug
          Components: sql-general
            Reporter: Weishiun Tsai
            Assignee: Hans Zeller
            Priority: Critical


SALT_BUCKETS=<num> syntax is targeted to be supported for the CREATE TABLE statement, but it returns error 15001 right now.



>>set schema seabase.phoenix;



--- SQL operation complete.

>>create table t (a int not null not droppable primary key) salt_buckets=4;



*** ERROR[15001] A syntax error occurred at or before:

create table t (a int not null not droppable primary key) salt_buckets=4;

                                                                     ^ (70 chara

cters from start of SQL statement)



*** ERROR[8822] The statement was not prepared.



>>



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)