[Koha-bugs] [Bug 35746] Multiple selections for parameters used in the IN function

bugzilla-daemon at bugs.koha-community.org bugzilla-daemon at bugs.koha-community.org
Tue Feb 20 18:16:27 CET 2024


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

--- Comment #18 from Caroline Cyr La Rose <caroline.cyr-la-rose at inlibro.com> ---
I just tested it again on KTD and it gives me a weird error.

For the same report, my local installation returns

SELECT
    i.homebranch,
    count(*)
    FROM items i
    WHERE i.homebranch in ('CPL','MPL')
    GROUP BY i.homebranch /* saved_sql.id: 16 */

And KTD returns

SELECT
    i.homebranch,
    count(*)
    FROM items i
    WHERE i.homebranch in 'CPL\r\nMPL'
    GROUP BY i.homebranch /* saved_sql.id: 1 */

I'm not used to KTD yet, so I don't know what causes the difference. But it
definitely works on my local Koha.

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


More information about the Koha-bugs mailing list