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

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=35746 --- Comment #19 from Caroline Cyr La Rose <caroline.cyr-la-rose@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.