Fixed groupLimit functionality

singlestore-labs / singlestoredb-laravel-driver

The official SingleStore Laravel driver.

https://github.com/singlestore-labs/singlestore-laravel-driver

Apache License 2.0

223 stars 22 forks source link

Fixed groupLimit functionality #87

Closed AdalbertMemSQL closed 2 months ago

AdalbertMemSQL commented 2 months ago

This functionality was added in Laravel 11. MySQL driver checks the version of the database and if it is less than 8 then generates a query with unsupported syntax for UDV. It seems that functionality for MySQL >= 8 works well with SingleStore. Added test that checks this.