Hi all,

I haven’t investigated this deep enough to open a Bugzilla report, but has anyone else had the experience of a limit in a subquery causing issues with the surrounding SQL query?

I had a subquery in the select statement with a limit of 1, and it was causing my output to only display 1 row, and broke the paging.

This was on an older version of Koha. Haven’t tried with a newer one yet…

David Cook

Systems Librarian

Prosentient Systems

72/330 Wattle St

Ultimo, NSW 2007

Australia

Office: 02 9212 0899

Online: 02 8005 0595