Re: setFetchOffset & setFetchLimit issue

2011-07-26 Thread Andrus Adamchik
Yes please. This needs to be investigated. On Jul 26, 2011, at 2:25 PM, Gary Jarrel wrote: > Should I still lodge a Jira? > > Gary > > On Mon, Jul 25, 2011 at 8:02 PM, Gary Jarrel wrote: >> I am not sure if this would fix it. I've just checked out the 3.0 >> source code, applied the patch, bui

Re: setFetchOffset & setFetchLimit issue

2011-07-26 Thread Gary Jarrel
Should I still lodge a Jira? Gary On Mon, Jul 25, 2011 at 8:02 PM, Gary Jarrel wrote: > I am not sure if this would fix it. I've just checked out the 3.0 > source code, applied the patch, built Cayenne and and ran my code > against it, and am having the same problem. > > Could it perhaps be beca

Re: setFetchOffset & setFetchLimit issue

2011-07-25 Thread Gary Jarrel
I am not sure if this would fix it. I've just checked out the 3.0 source code, applied the patch, built Cayenne and and ran my code against it, and am having the same problem. Could it perhaps be because SQL Server 2008 does not have the offset feature? Well at least not until SQL Server 2011 (bas

Re: setFetchOffset & setFetchLimit issue

2011-07-24 Thread Andrus Adamchik
I just found the Jira that I had in mind when answering your email: https://issues.apache.org/jira/browse/CAY-1539 I just committed the patch to trunk. Still suspect your case may be related somehow. Andrus On Jul 23, 2011, at 10:56 AM, Gary Jarrel wrote: > I will do some more research to t

Re: setFetchOffset & setFetchLimit issue

2011-07-23 Thread Gary Jarrel
I will do some more research to try to narrow down why this is happening tomorrow and then post a Jira. I also removed DISTINCT and any ordering and query parameters and the result is still the same. Gary On Thu, Jul 21, 2011 at 9:48 PM, Andrus Adamchik wrote: > Hi Gary, > > the use of the API

Re: setFetchOffset & setFetchLimit issue

2011-07-21 Thread Andrus Adamchik
Hi Gary, the use of the API seems correct. Not sure what's the deal here. Could be a bug. (wonder if DISTINCT combination with offset/limit is causing this, as there is some in-memory processing involved). Could you please open a Jira and include the contents of the prototype query. Andrus O

setFetchOffset & setFetchLimit issue

2011-07-20 Thread Gary Jarrel
Hi Guys, I have an issue with using setFetchOffset & setFetchLimit together with SQL Server 2008 R2. Basically the code looks something like this: SelectQuery query = getPrototypeQuery().queryWithParameters(params, true); query.setFetchOffset(offset); query.setFetchLimit(limit); List result = ge