You are viewing a plain text version of this content. The canonical link for it is here.

Posted to derby-dev@db.apache.org by Christian d'Heureuse <ch...@inventec.ch> on 2004/08/27 00:00:00 UTC

Bug in NULLIF Function

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.)"

Christian

Re: Bug in NULLIF Function

Posted by Satheesh Bandaram <sa...@Sourcery.Org>.

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

I believe this is a known defect.. We will try to address this soon.

Satheesh

Christian d'Heureuse wrote:
| 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.)"
|
| Christian
|
|

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.5 (MingW32)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQFBLpDAENVNIY6DZ7ERAi2DAJ9vStt+C0RMI6WhK2q0xwBhgc6hfgCgsBXn
7rRzdACikdaXRaVUp4TVWiw=
=5v8l
-----END PGP SIGNATURE-----