You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "Suresh Subbiah (JIRA)" <ji...@apache.org> on 2015/10/05 17:54:26 UTC
[jira] [Closed] (TRAFODION-1029) LP Bug: 1427527 -
Multi-temperature data: create-table-like-with-constrains-without-division
table should not be divisioned
[ https://issues.apache.org/jira/browse/TRAFODION-1029?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Suresh Subbiah closed TRAFODION-1029.
-------------------------------------
> LP Bug: 1427527 - Multi-temperature data: create-table-like-with-constrains-without-division table should not be divisioned
> ---------------------------------------------------------------------------------------------------------------------------
>
> Key: TRAFODION-1029
> URL: https://issues.apache.org/jira/browse/TRAFODION-1029
> Project: Apache Trafodion
> Issue Type: Sub-task
> Components: sql-cmp
> Reporter: zhang yan
> Assignee: Hans Zeller
>
> create schema trafodion.multitempdata_mtd_table;
> SET SCHEMA trafodion.multitempdata_mtd_table;
> CREATE TABLE mtd_int(cust_id smallint not null,
> order_num int not null,
> widgets_ordered int not null,
> back_order int not null,
> next_order int not null,
> PRIMARY KEY (cust_id, widgets_ordered desc, back_order desc))
> DIVISION BY ((widgets_ordered + 5)/20, (back_order + 0)/20 desc);
> CREATE TABLE mtd_int_like1 LIKE mtd_int WITH CONSTRAINTS WITHOUT DIVISION;
> showddl mtd_int_like1;
> #show table mtd_int_like1 ,it contains division by
> CREATE TABLE TRAFODION.MULTITEMPDATA_MTD_TABLE.MTD_INT_LIKE1
> (
> CUST_ID SMALLINT NO DEFAULT NOT NULL NOT DROPPABLE
> , ORDER_NUM INT NO DEFAULT NOT NULL NOT DROPPABLE
> , WIDGETS_ORDERED INT NO DEFAULT NOT NULL NOT DROPPABLE
> , BACK_ORDER INT NO DEFAULT NOT NULL NOT DROPPABLE
> , NEXT_ORDER INT NO DEFAULT NOT NULL NOT DROPPABLE
> , PRIMARY KEY (CUST_ID ASC, WIDGETS_ORDERED DESC, BACK_ORDER DESC)
> )
> DIVISION BY (((WIDGETS_ORDERED + 5) / 20), ((BACK_ORDER + 0) / 20)
> NAMED AS ("_DIVISION_1_", "_DIVISION_2_"))
> ;
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)