Re: DERBY-6301 - In list predicate not getting moved down to store for a subset of in list queries

2014-02-10 Thread msatoorPotter .
Dag, thanks for sharing the reverse scenario you had to deal with. Just want to write down my understanding of what is happening for my specific case. Spend some time in code generation and run time code to see what happens for the query below select * from t1 where c11 in (1,2,3,4,5,6,7,8,9,10,1

Re: DERBY-6301 - In list predicate not getting moved down to store for a subset of in list queries

2014-02-11 Thread msatoorPotter .
ta On Tue, Feb 11, 2014 at 2:02 PM, Dag H. Wanvik wrote: > Yes, this looks about right to me. I believe your understanding is > correct. > Thanks for detailing it for others. > > Dag > > > On 11. feb. 2014 08:57, msatoorPotter . wrote: > > Dag, thanks for sharing th