[Koha-bugs] [Bug 28029] Add ability to use OFFSET in SQL reports

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28029

Katrin Fischer <katrin.fischer at bsz-bw.de> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
           Severity|minor                       |trivial
            Version|20.05                       |master

--- Comment #2 from Katrin Fischer <katrin.fischer at bsz-bw.de> ---
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

-- 
You are receiving this mail because:
You are watching all bug changes.
You are the assignee for the bug.