groupLimit throwing an error

[sydney-d]

Hello,

With adonis 6 I have this error when trying to use groupLimit.
Here the request :

boats = await Boat.query().preload('positions', (positionsQuery) => {
   positionsQuery.orderBy('id', 'desc').groupLimit(1) 
})

And the error :

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(PARTITION BY boat_id ORDER BY id desc) as adonis_group_limit_counter from `posi' at line 1

select * from (select *, row_number() over (PARTITION BY boat_id ORDER BY id desc) as adonis_group_limit_counter from `positions` where `boat_id` in (1, 2) order by `id` desc) as `adonis_temp` where `adonis_group_limit_counter` <= 1

Seems pretty basic, what am I doing wrong ?

Thanks

[thetutlage]

Use groupOrderBy('id', 'desc') instead