| Summary: | Add ability to use OFFSET in SQL reports | ||
|---|---|---|---|
| Product: | Koha | Reporter: | Joe Sikowitz <joe> |
| Component: | Reports | Assignee: | Bugs List <koha-bugs> |
| Status: | CLOSED INVALID | QA Contact: | Testopia <testopia> |
| Severity: | trivial | ||
| Priority: | P5 - low | CC: | wizzyrea |
| Version: | Main | ||
| Hardware: | All | ||
| OS: | All | ||
| GIT URL: | Initiative type: | --- | |
| Sponsorship status: | --- | Comma delimited list of Sponsors: | |
| Crowdfunding goal: | 0 | Crowdfunding committed: | 0 |
| Crowdfunding contact: | Patch complexity: | --- | |
| Documentation contact: | Documentation submission: | ||
| Text to go in the release notes: | Version(s) released in: | ||
| Circulation function: | |||
|
Description
Joe Sikowitz
2021-03-23 18:53:19 UTC
Noting this feature is available as of mariadb 10.6. It looks like the MariaDB version on ktd is too old to test this: 10.5.19-MariaDB-1:10.5.19+maria~ubu2004 The error I get indicates that the SQL statement was used as I entered it, but that the DBMS doesn't support it. So I think a change in Koha might not be needed: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '10 Joe, can you verify you were testing with 10.6 or later? MariaDB: https://mariadb.com/kb/en/select-offset-fetch/ MySQL seems to have had it for a while: https://dev.mysql.com/doc/refman/8.0/en/select.html https://dev.mysql.com/doc/refman/5.7/en/select.html I believe this was a DBMS version related problem. |