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

[Mamta Satoor]

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 <[EMAIL PROTECTED]> 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
                                 [EMAIL PROTECTED]
                                Check out Swazoo Koolak's Web Jukebox at
                                http://swazoo.com/