Re: [jira] Commented: (DERBY-7) Bug in NULLIF Function

27 Dec 2004 23:26:33 -0000

But it should work even without the cast... Derby compiler should be able to cast the untyped NULL to the other operand type.

Satheesh

Christian d'Heureuse (JIRA) wrote: 
     [ http://nagoya.apache.org/jira/browse/DERBY-7?page=comments#action_57077 ]
     
Christian d'Heureuse commented on DERBY-7:
------------------------------------------

I think this is the same problem, because NULLIF() and CASE (whenThenExpression) both are implemented using CONDITIONAL_NODE.

But for CASE, the error can be avoided by using "CAST(NULL as INT)" instead of an untyped NULL:

  values (case when 1.0=1.0 then cast(null as int) else 10 end);

For NULLIF() this is not possible.

  
Bug in NULLIF Function
----------------------

         Key: DERBY-7
         URL: http://nagoya.apache.org/jira/browse/DERBY-7
     Project: Derby
        Type: Bug
  Components: SQL
    Versions: 10.0.2.0
    Reporter: Tulika Agrawal
    Priority: Minor
    

  
Reporting for Christian d'Heureuse, filed on derby-dev list.
The NULLIF built-in function of Cloudscape 10.0.1.0 beta seems to accept
only string values.
Examples:
 values nullif('a','b');
 --> OK
 values nullif(1,2);
 --> Error message: "ERROR 42X89: Types 'CHAR' and
     'INTEGER' are not type compatible. (Neither type
     is assignable to the other type.)"

Reply via email to