MsSql2005Dialect uses paging query when no offset specified
Description
Environment
None
Attachments
1
Activity
Show:
Jesse May 21, 2009 at 3:27 PM
Adding patch to fix this. Its actually pretty simple. Just call the base dialect if there is not offset since paging wasnt db side in the 2000 dialect.
Fixed
Details
Details
Assignee
Unassigned
UnassignedReporter
JesseComponents
Fix versions
Affects versions
Priority
MinorWho's Looking?
Open Who's Looking?
Created May 21, 2009 at 11:43 AM
Updated July 22, 2009 at 7:21 AM
Resolved May 22, 2009 at 9:32 PM
Who's Looking?
When SetMaxResults is used without an offset(SetFirstResult) a paging query is constructed which is much more verbose then a simple "Select top X" and less efficient.