Qilin Chen created TRAFODION-2804:
-------------------------------------
Summary: add "LIMIT" clause support for statements
create-as-select and load-into-select
Key: TRAFODION-2804
URL: https://issues.apache.org/jira/browse/TRAFODION-2804
Project: Apache Trafodion
Issue Type: Bug
Components: sql-cmp
Affects Versions: 2.1-incubating
Reporter: Qilin Chen
Priority: Minor
We don't support "LIMIT" clause in statements CREATE-AS-SELECT and
LOAD-INTO-SELECT, see below for details:
--01 : CREATE-AS-SELECT
SQL>create table comment_table_02 as select * from comment_table limit 100;
*** ERROR[15001] A syntax error occurred at or before:
create table comment_table_02 as select * from comment_table limit 100;
^ (66
characters from start of SQL statement) [2017-11-13 15:42:01]
--02 : LOAD-INTO-SELECT
SQL>load into comment_table_02 select * from comment_table limit 100;
*** ERROR[15001] A syntax error occurred at or before:
load into comment_table_02 select * from comment_table limit 100;
^ (60 characters
from start of SQL statement) [2017-11-13 15:45:31]
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
