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

["Alice Chen (JIRA)" <ji...@apache.org>]

Alice Chen created TRAFODION-976:
------------------------------------

             Summary: 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: Bug
          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)