[Koha-bugs] [Bug 1707] Search for patron '%' returns all results

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

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

--- Comment #5 from Petter Goksøyr Åsen <boutrosboutrosboutros at gmail.com> ---
I have put a limit on the query as you suggested:
http://paste.koha-community.org/135 
It's not in production yet, but testing in staging so far seems good.

The result is probably not accurate, as you said, but I think it's only
potentially wrong if you have a very wide search (i.e few numbers which matches
lots of borrowernumbers). If the result list is long, say tens of thousands, it
does not matter that its not accurate.

If you search for full fields (in our case its social security number as
extended patron attribute), the returned result is always correct

In my mind, it's quite dangerous that Koha allows to generate SQL-queries which
are several MB of text, which generated huge loads on our server, so I'd prefer
safety to accuracy here.

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