Pagination doesn't work properly with with sorting

[juanyunis]

The built in pagination method for a Lucid model doesn't work properly when someone try to use it with orderBy.

Example:

const devices = yield Device.query().orderBy('name', 'desc').paginate(1, 10)

Exception:

select count(*) as "total" from "devices" order by "name" desc - column "devices.name" must appear in the GROUP BY clause or be used in an aggregate function

This problem doesn't happen with other method forPage().

[thetutlage]

Which database client are you using? For example: Mysql, PostgreSQL

[juanyunis]

PostgreSQL.

[thetutlage]

Works great with Mysql and other clients except Postgres. I will push a patch for the same soon.

[juanyunis]

Awesome

[juhguu]

I have the same error using SQL Server database.