db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Don Smith (JIRA)" <j...@apache.org>
Subject [jira] Created: (DERBY-2386) timestampdiff function fails when using SQL_TSI_FRAC_SECOND for datepart parameter, except for very small intervals
Date Thu, 01 Mar 2007 17:21:50 GMT
timestampdiff function fails when using SQL_TSI_FRAC_SECOND for datepart parameter, except
for very small intervals
-------------------------------------------------------------------------------------------------------------------

                 Key: DERBY-2386
                 URL: https://issues.apache.org/jira/browse/DERBY-2386
             Project: Derby
          Issue Type: Bug
          Components: SQL
    Affects Versions: 10.2.2.0
         Environment: SUSE Linux Enterprise Desktop 10
            Reporter: Don Smith


Using the timestampdiff function produces and integer overflow except for very small intervals.
Error message is:

[Error Code: -1, SQL State: 22003]  The resulting value is outside the range for the data
type INTEGER.

I inserted the following row into my test table:

insert into datetest (ID, 
startdate, 
enddate) values (
5, 
'2006-11-20 04:20:00.0', 
'2006-11-20 04:20:00.2');

This test row works:

select {fn timestampdiff(SQL_TSI_FRAC_SECOND, startdate, enddate)} as diff from datetest where
id = 5

DIFF
200000000

The value also looks too large, which could be exacerbating the problem.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


Mime
View raw message