Bryan Pendleton wrote:
My problems came from a simple query containing an IN clause with 5000
items in it. I went over this easily by increasing the stack size
limit to 1024 KB.
Thanks Robert! That definitely sounds like DERBY-47. If you have the time,
it'd be great to have some help in working on improving this part of Derby.
I don't think this is DERBY-47. DERBY-47 is the issue that the plan
generated by an IN query is inefficient.
This issue is that a query with a large number of IN parameters fails to
compile due to a stack overflow error.
Dan.