search

oibo8x / subsonicproject

Automatically exported from code.google.com/p/subsonicproject
0 stars 0 forks source link

Patch: SqlQuery ExecuteJoinedDataSet does not support paging #83

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago 
What steps will reproduce the problem?
DB.Select().From<Product>().Paged(1,25).ExecuteJoinedDataSet(); (where the
Product table contains foreign keys)

What is the expected output? What do you see instead?
You would expect to just get back the first page of results, but it returns
the full result set. ExecutedJoinedDataSet completely ignores the paging
feature. I've added it in as well as overloading the BuildPagedSqlStatement
method in the SqlGenerators. I've tested it in Sql2005 but not the others
(ANSI, Oracle, or MySql).

What version of the product are you using? On what operating system?
current revision after patches for issues 61, 68, 77, 78, 76. Win XP. SQL
Server 2005

Original issue reported on code.google.com by JonWynv...@gmail.com on 1 May 2009 at 2:34

Attachments:

GoogleCodeExporter commented 9 years ago 
Had to update/cleanup some of my changes that I forgot to do before making the 
patch.
Here is the up-to-date patch.

Original comment by JonWynv...@gmail.com on 1 May 2009 at 3:00

Attachments:

GoogleCodeExporter commented 9 years ago 
I know the source isn't here anymore, but I was really excited to see this 
patch all
the same. However, this is not the right patch for the issue you described.

Original comment by dave.nee...@gmail.com on 21 Sep 2009 at 3:31