Re: Peculiar sorting behaviour?

2013-04-03 Thread John English
On 03/04/2013 04:11, Bryan Pendleton wrote: it's worth reporting the problem, together with whatever information you have. OK, I'll prepare something and submit it. 2) I agree with Knut Anders's hunch that this seems like a sort avoidance bug. Yes, that sounds right to me too. 3) I see

Re: Peculiar sorting behaviour?

2013-04-03 Thread John English
On 02/04/2013 22:13, Mike Matrigali wrote: need ddl for both item_usage (i think you posted this in 1st posting) and tests (don't see this one) tables, to read the query plan. ITEM_USAGE is indeed in the first post. Here is the TESTS table: CREATE TABLE tests ( id INTEGER

Re: Peculiar sorting behaviour?

2013-04-03 Thread John English
On 03/04/2013 04:11, Bryan Pendleton wrote: it's worth reporting the problem, together with whatever information you have. I've submitted what I have reported so far as: https://issues.apache.org/jira/browse/DERBY-6148 I'm still trying to come up with a suitable test case and will add it to