search

querymx / querym

Querym is free, open-source and cross-platform MySQL and PostgreSQL GUI client.
https://querym.net/
GNU General Public License v3.0
94 stars 28 forks source link

[Bug]: Postgres syntax error, when click on next page #156

Closed RathanakSreang closed 1 year ago

RathanakSreang commented 1 year ago

👟 Reproduction steps

When my table have more than 200 records, and I want to navigate to next page by click on next page button. It should syntax error.

👍 Expected behavior

It should show me record of next page (page 2).

👎 Actual Behavior

It pop up error "Error invoking remote method 'query': error: LIMIT #,# syntax is not supported. Screenshot from 2023-10-05 18-40-22 "

invisal commented 1 year ago

Thanks for report the bug. I believe because PostgreSQL is using LIMIT n OFFSET m; instead of LIMIT n,m. We are working on the fix.

invisal commented 1 year ago

This has been fixed and will be released in next week release,