[
https://issues.apache.org/jira/browse/TRAFODION-976?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Hans Zeller updated TRAFODION-976:
----------------------------------
Issue Type: Sub-task (was: Bug)
Parent: TRAFODION-13
> 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)
