subashz
10/26/2021, 4:33 PMAndreas Scheja
10/26/2021, 4:55 PMSQL_CALC_FOUND_ROWS
and FOUND_ROWS()
are deprecated, see https://dev.mysql.com/doc/refman/8.0/en/information-functions.html#function_found-rows
i assume something like
transaction {
val condition = with(SqlExpressionBuilder) {
<some-condition>
}
val results = YourTable.select { condition and id > 100 }.limit(100)
val totalCount = YourTable.select { condition }.count()
}
should do the trick