db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Tomohito Nakayama (JIRA)" <derby-...@db.apache.org>
Subject [jira] Commented: (DERBY-1942) There exists difference between behavior of setNull(Types.TIME) and setTiime(null).
Date Wed, 11 Oct 2006 12:08:22 GMT
    [ http://issues.apache.org/jira/browse/DERBY-1942?page=comments#action_12441434 ] 
            
Tomohito Nakayama commented on DERBY-1942:
------------------------------------------

This modification would affect DATETIMEDIFF scalar function.

Now DATETIMEDIFF function accept java.sql.TIME as type compatible for parameters.
However modification in this patch would take it as error.
I think new behavior would proper behavior but a little strict....

In the JDBC spec, signature for TIMESTAMPDIFF function was described as next.

TIMESTAMPDIFF(interval, An integer representing the number of interval
timestamp1, timestamp2)

I think this description is implicit definition that the parameter should be timestamp.

Well ... I will take strict way, means to regard java.sql.TIME as incompatible type for parameters
in DATETIMEDIFF function.


> There exists difference between behavior of  setNull(Types.TIME) and setTiime(null).
> ------------------------------------------------------------------------------------
>
>                 Key: DERBY-1942
>                 URL: http://issues.apache.org/jira/browse/DERBY-1942
>             Project: Derby
>          Issue Type: Bug
>          Components: JDBC
>            Reporter: Tomohito Nakayama
>         Assigned To: Tomohito Nakayama
>
> The result of setNull(java.sql.Types.TIME) for TIMESTAMP typed variable is regarded as
error.
> However, the result of setTime(null) for TIMESTAMP typed variable is not regarded as
error . 
> see http://issues.apache.org/jira/browse/DERBY-1610#action_12436554

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

Mime
View raw message