https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=35746
--- Comment #19 from Caroline Cyr La Rose <[email protected]> --- (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. _______________________________________________ Koha-bugs mailing list [email protected] https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
