Bug 21940

Summary: Query parameters of the form <<in "foo">> return no results.
Product: Koha Reporter: Barton Chittenden <barton>
Component: ReportsAssignee: Bugs List <koha-bugs>
Status: CLOSED FIXED QA Contact: Testopia <testopia>
Severity: enhancement    
Priority: P5 - low CC: jonathan.druart, katrin.fischer
Version: 18.05   
Hardware: All   
OS: All   
Change sponsored?: --- Patch complexity: ---
Documentation contact: Documentation submission:
Text to go in the release notes:
Version(s) released in:

Description Barton Chittenden 2018-12-03 23:55:39 UTC
Running the following report

select
    cardnumber,
    firstname,
    surname,
    categorycode
from borrowers
where categorycode = <<in "s">>

returns no results. Inspecting 'Show SQL' reveals

select
    cardnumber,
    firstname,
    surname,
    categorycode
from borrowers
where categorycode = NULL

however

where categorycode = <<in s>>

and

where categorycode = <<"s">>

both work.
Comment 1 Jonathan Druart 2019-05-11 15:30:22 UTC
It seems to have been fixed, works for me. Can you confirm?
Comment 2 Katrin Fischer 2019-05-11 21:44:13 UTC
Confirmed.