db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mamta Satoor <msat...@gmail.com>
Subject Re: [PATCH] (DERBY-582) Dynamic parameter should be allowed to be the operand of unary operator "-". Derby throws exception 42X36: The '-' operator is not allowed to take a ? parameter as an operand."
Date Thu, 29 Sep 2005 18:34:57 GMT
Same as what happens for where t1.int_column + ? = -? ie the type of
parameter in -? will be int no matter which side of equal operator it
appears in the 2 ways of writing this where clause.

On 9/29/05, Jeffrey Lichtman <swazoo@rcn.com> wrote:
>
>
> > where t1.int_column + ? = - ?
> >The first parameter gets bound to the type of t1.int_column and then
> >second parameter gets bound to the same type too.
>
> OK, then how about:
>
> where - ? = t1.int_column + ?
>
>
> - Jeff Lichtman
> swazoo@rcn.com
> Check out Swazoo Koolak's Web Jukebox at
> http://swazoo.com/
>
>

Mime
View raw message