Bug 21940 - Query parameters of the form <<in "foo">> return no results.
Summary: Query parameters of the form <<in "foo">> return no results.
Status: CLOSED FIXED
Alias: None
Product: Koha
Classification: Unclassified
Component: Reports (show other bugs)
Version: 18.05
Hardware: All All
: P5 - low enhancement (vote)
Assignee: Bugs List
QA Contact: Testopia
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2018-12-03 23:55 UTC by Barton Chittenden
Modified: 2020-01-06 20:15 UTC (History)
2 users (show)

See Also:
Change sponsored?: ---
Patch complexity: ---
Documentation contact:
Documentation submission:
Text to go in the release notes:
Version(s) released in:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
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.