[jira] [Closed] (TRAFODION-976) LP Bug: 1417741 - multi-temperature data: divisioning on (date_part('year', add_months(...)) fails with ERROR[3044], ERROR[1135]

["Suresh Subbiah (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/TRAFODION-976?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Suresh Subbiah closed TRAFODION-976.
------------------------------------

> LP Bug: 1417741 - multi-temperature data: divisioning on (date_part('year', add_months(...)) fails with ERROR[3044], ERROR[1135]
> --------------------------------------------------------------------------------------------------------------------------------
>
>                 Key: TRAFODION-976
>                 URL: https://issues.apache.org/jira/browse/TRAFODION-976
>             Project: Apache Trafodion
>          Issue Type: Sub-task
>          Components: sql-cmp
>            Reporter: Julie Thai
>            Assignee: Hans Zeller
>
> >>create  table mtdworks1(col_si smallint unsigned not null,
> +>        col_int integer signed not null,
> +>        col_lint largeint signed not null,
> +>        col_flt float(8) not null,
> +>        col_num numeric not null,
> +>        col_real real not null,
> +>        col_dp double precision not null,
> +>        col_dec decimal(9,2) not null,
> +>        col_date date default date '2011-09-05' not null,
> +>        col_time time default time '12:34:56' not null,
> +>        col_ts timestamp default timestamp '2011-09-05 12:34:56' not null,
> +>        col_intrvl interval year to month not null,
> +>        primary key (col_int, col_date))	
> +>        division by (date_part('year', add_months(col_date, 2, 0)));
> *** ERROR[3044] The interval YEAR(0) TO MONTH is not valid.
> *** ERROR[1135] Clustering key column _DIVISION_1_ must be assigned a NOT NULL NOT DROPPABLE constraint.
> --- SQL operation failed with errors.



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