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
