return SqlString |
|
SqlString insertSql |
|
string identityColumn |
|
string tableName |
return string |
|
LockMode lockMode |
|
string tableName |
return CaseFragment |
return JoinFragment |
return bool |
|
object obj |
return string |
|
string constraintName |
|
String[] foreignKey |
|
string referencedTable |
|
String[] primaryKey |
return string |
|
string constraintName |
return string |
|
SqlType sqlType |
return string |
|
string sequenceName |
return string |
|
string constraintName |
return string |
|
string constraintName |
return string |
|
string constraintName |
return string |
|
string sequenceName |
return string |
|
string tableName |
return string |
|
string aliases |
return string |
|
string aliases |
return string |
|
LockMode lockMode |
return int |
return string |
|
string identityColumn |
|
string tableName |
LIMIT
clause to the given SQL SELECT
TheLIMIT
SQL will look likeSELECT TOP last (columns) FROM ( SELECT ROW_NUMBER() OVER(ORDER BY __hibernate_sort_expr_1__ {sort direction 1} [, __hibernate_sort_expr_2__ {sort direction 2}, ...]) as row, (query.columns) FROM ( {original select query part}, {sort field 1} as __hibernate_sort_expr_1__ [, {sort field 2} as __hibernate_sort_expr_2__, ...] {remainder of original query minus the order by clause} ) query ) page WHERE page.row > offset
Note that we need to add explicitly specify the columns, because we need to be able to use them in a paged subselect. NH-1155
return SqlString |
A new SqlString with the LIMIT clause applied. |
SqlString querySqlString |
The SqlString to base the limit query off of. |
int offset |
Offset of the first row to be returned by the query (zero-based) |
int last |
Maximum number of rows to be returned by the query |
return string |
|
string sequenceName |
return Type |
return string |
|
SqlType sqlType |
|
int length |
return string |
|
SqlType sqlType |
return bool |
|
string name |
return string |
|
string aliasName |
return string |
|
string columnName |
return string |
|
string schemaName |
return string |
|
string tableName |
return string |
return String[] |
|
String[] quoted |
return string |
|
string quoted |
return string
|
return bool
|
return bool
|
return Char
|
return IDictionary
|
return bool
|
return string
|
return bool
|
return string
|
return IDictionary
|
return bool
|
return bool
|
return string
|
return string
|
return string
|
return int
|
return string
|
return string
|
return string
|
return Char
|
return bool
|
return bool
|
LIMIT
functionality.
return bool
|
LIMIT
functionality with an offset.
return bool
|
return bool
|
return bool
|
return bool
|
return bool
|
return long
|
LIMIT
functionality with an offset.
return bool
|