[jira] [Resolved] (TRAFODION-3237) Incorrect results for INTERVAL addition in an uncommon case

["David Wayne Birdsall (JIRA)" <ji...@apache.org>]

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

David Wayne Birdsall resolved TRAFODION-3237.
---------------------------------------------
       Resolution: Fixed
    Fix Version/s: 2.4

> Incorrect results for INTERVAL addition in an uncommon case
> -----------------------------------------------------------
>
>                 Key: TRAFODION-3237
>                 URL: https://issues.apache.org/jira/browse/TRAFODION-3237
>             Project: Apache Trafodion
>          Issue Type: Bug
>          Components: sql-cmp
>    Affects Versions: 2.4
>            Reporter: David Wayne Birdsall
>            Assignee: David Wayne Birdsall
>            Priority: Major
>             Fix For: 2.4
>
>
> The following script illustrates the problem:
> {quote}?section ddl
> drop table if exists mytableF_base;
> create table mytableF_base (
> val int,
> "c9" interval day(7) to second default NULL,
> "c10" interval day(13) to second(0) default NULL,
> "key c10" interval day(13) to second(0) not null default interval '1111111111111:01:11:11' day(13) to second(0),
> unique ("key c10")
> );
> ?section populateit
> insert into mytableF_base values (
> 0,
> interval '0 00:00:00' day(7) to second,
> interval '0 00:00:00' day(13) to second(0),
> interval '0 00:00:00' day(13) to second(0));
> insert into mytableF_base 
> select 1, 
> "c9" + interval '1' day,
> "c10" + interval '1' day, -- gives incorrect result 
> "key c10" + interval '1' day -- gives incorrect result 
> from mytableF_base
> where val = 0;
> insert into mytableF_base 
> select 23, 
> "c9" + interval '1' day,
> "c10" + interval '2' day, -- gives correct result
> "key c10" + interval '3' day -- gives correct result
> from mytableF_base
> where val = 0;
> select "c10","key c10" from mytableF_base;
> {quote}
> When run, the last SELECT gives:
> {quote}>>select "c10","key c10" from mytableF_base;
> c10 key c10 
> ----------------------- -----------------------
> 0 00:00:00 0 00:00:00
>  1000000 00:00:00 1000000 00:00:00
>  2 00:00:00 3 00:00:00
> --- 3 row(s) selected.
> >>exit;
> {quote}
> The second line is incorrect; the values are off by a factor of one million.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)