Database Query Builder cannot do paged query on MySQL

Hi there Wappler support,

I recently found an issue with the simple query builder. When I want to do a paged record it creates this query:

SELECT *
FROM aansluitingen
FETCH NEXT 5 ROWS ONLY

But I get this error:
errorsyntax

If I do custom query and change the FETCH NEXT 5 ROWS ONLY
to LIMIT 5 I get no error and it just works.

This is using the latest Wappler version and connected to a DO managed db. MySQL, using a legacy user account for the db.

Happy to provide with more details, but I suspect this is easily reproducable.

Thanks for your support!

bg Jelle

Community Page
Last updated: