Fixed
Details
Details
Assignee
Unassigned
UnassignedReporter
Aaron Reicher
Aaron ReicherComponents
Fix versions
Affects versions
Priority
Who's Looking?
Open Who's Looking?
Created June 26, 2012 at 10:09 PM
Updated September 21, 2014 at 12:40 PM
Resolved September 6, 2012 at 8:15 PM
Using the SQLAnywhere12 Dialect (.NET 4)
A query with a Skip in the form of:
QueryOver<TestClass>().Take(1).Skip(1)
Results in: select top 1 /* 0 / start at 1 / 1 */ this_.id as id102_0_,... FROM test.thetable this_
where the starting position should be 2.
The dialect appropriately sets the Dialect.OffsetStartsAtOne property to true. However, this is a parameter, and at bind time the QuerySkipParameterSpecification uses the RowSelection.FirstRow intead of the dialect-specific offset, Comparing it to the (similar) QueryTakeParameterSpecification implementation, it should probably used the Loader.GetOffsetUsingDialect method.