[Monetdb-developers] Prepared Statement Error

Sjoerd Mullender sjoerd at acm.org
Mon Jul 23 15:56:12 CEST 2007


Bharani wrote:
> Thanks for the reply. I have posted a bug in sourceforge. Upon further
> investigation it looks like MAL does maintain the correct order by it
> expects the where cluase values first and then the values for the update
> from left to right.
> 
> Is this the expect behaviour? I am testing with hibernate dialect
> (postgresql) and this clearly breaks the way the batches are handled.

I saw the bug report.  Thanks.

I would expect the parameters to be used in strict left-to-right order,
and this would break that.  So I think it's a bug, but we'll have to
wait until our SQL expert is back from vacation.

> -Bharani
> 
> 
> Sjoerd Mullender-2 wrote:
>> Bharani wrote:
>>> Hi,
>>>
>>> I am trying to execute this sql as prepared statement
>>>
>>> update reason set failurereason=? where ID=? 
>>>
>>> reason is a table with two columns
>>> ID is integer
>>> failurereason is a string
>>>
>>> During the batch execution i see
>>>
>>> exec 3('whatever',2);
>>>
>>> in the batch and then i get
>>>
>>> MALException:(unknown):wrong argument for prepared statement (expected
>>> int
>>> instead of char)
>>>
>>> Looks like expected types are getting swapped. 
>>>
>>> Thanks
>>> Bharani
>>>
>> Looks like you're right.  Can you submit a bug report in sourceforge
>> (https://sourceforge.net/tracker/?group_id=56967&atid=482468)?
>> Thanks.
>>
>> -- 
>> Sjoerd Mullender
>>
>>
>>  
>> -------------------------------------------------------------------------
>> This SF.net email is sponsored by: Microsoft
>> Defy all challenges. Microsoft(R) Visual Studio 2005.
>> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
>> _______________________________________________
>> Monetdb-developers mailing list
>> Monetdb-developers at lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/monetdb-developers
>>
>>
> 


-- 
Sjoerd Mullender

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 370 bytes
Desc: OpenPGP digital signature
URL: <http://www.monetdb.org/pipermail/developers-list/attachments/20070723/ca952c3d/attachment.sig>


More information about the developers-list mailing list