db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Saurabh Vyas <Saurabh.V...@Sun.COM>
Subject Re: [jira] Updated: (DERBY-827) Performance can be improved by re-using language ResultSets across Activation executions.
Date Thu, 29 Mar 2007 10:54:25 GMT
Sorry for not being clear in previous reply, I haven't applied you patch 
before running the repro!!!!!!!!!! but still I got "0 rows selected"

Saurabh Vyas wrote:
> Dyre Tjeldvoll (JIRA) wrote:
>> Here is the repro (test_inbetween.sql) requested by AB as well as a snapshot patch
of
>> my sandbox (includes Dan's changes and my fixups) (derby-827.snapshot.diff). Feel
free to
>> comment on the patch, but please note that it is work in
>> progress, (that means I will ignore any comments about missing
>> comments and/or poor indentation).
>>   
> Hi Dyre, I tried the repro it works as expected for me!!!!!!!!!!!!!!!
>
> ---<snip>-----------
> ij> -- Only parameter markers (no constants).
> prepare p1 as 'select * from bt1 where i in (?, ?)';
> ij> execute p1 using 'values (2, 4)';
> I          |C    |DE
> ------------------------
> 2          |two  |22.2
>
> 1 row selected
> ij> execute p1 using 'values (-2, -4)';
> I          |C    |DE
> ------------------------
>
> 0 rows selected
> -------------<end snip>---------------
>
> I had tried this repro on the development trunk only (10.3) Updated to 
> revision 523546. Am I missing any thing ?
>
> Saurabh


Mime
View raw message