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

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

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

--- Comment #19 from Caroline Cyr La Rose <caroline.cyr-la-rose at inlibro.com> ---
(In reply to Caroline Cyr La Rose from comment #18)
> 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.

I saw that it was the parentheses. My local Koha adds parentheses, but KTD does
not.
(In reply to Caroline Cyr La Rose from comment #18)
> 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.

Nevermind, I restarted KTD and it's fine! Sorry about that!

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