[Koha-devel] limit in subquery causing issues with SQL report?

[dcook at prosentient.com.au]

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

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.koha-community.org/pipermail/koha-devel/attachments/20200508/ecbcb1af/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 484 bytes
Desc: not available
URL: <http://lists.koha-community.org/pipermail/koha-devel/attachments/20200508/ecbcb1af/attachment.sig>