You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "Qilin Chen (JIRA)" <ji...@apache.org> on 2017/12/11 02:28:01 UTC
[jira] [Updated] (TRAFODION-2804) add "LIMIT" clause support for
statements create-as-select and load-into-select
[ https://issues.apache.org/jira/browse/TRAFODION-2804?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Qilin Chen updated TRAFODION-2804:
----------------------------------
Affects Version/s: (was: 2.1-incubating)
Description:
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]
--03 : INSERT-INTO-SELECT
SQL>insert into test003 select * from test002 limit 4;
*** ERROR[15001] A syntax error occurred at or before:
insert into test003 select * from test002 limit 4;
^ (47 characters from start of SQL statement) [2017-12-11 10:27:03]
was:
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]
> 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
> 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]
> --03 : INSERT-INTO-SELECT
> SQL>insert into test003 select * from test002 limit 4;
> *** ERROR[15001] A syntax error occurred at or before:
> insert into test003 select * from test002 limit 4;
> ^ (47 characters from start of SQL statement) [2017-12-11 10:27:03]
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)