https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26567
Chris Cormack <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #26 from Chris Cormack <[email protected]> --- (In reply to Marcel de Rooy from comment #24) > (In reply to Katrin Fischer from comment #16) > > (In reply to Marcel de Rooy from comment #15) > > > (In reply to Katrin Fischer from comment #14) > > > > Isn't in Discussion a bit harsh for a question? ;) > > > > > > > > Can you explain why the group or limit 1 is better than using a > > > > distinct? > > > > > > Isnt Failed QA a bit hard too? lol. Had no reason to fail here. > > > > > > Counter question: > > > q| INNER JOIN (SELECT DISTINCT subscriptionid FROM > > > subscriptionroutinglist) > > > srl ON srl.subscriptionid = subscription.subscriptionid|; > > > > > > Doesnt this looks a bit odd? Joining a subselect. Probably we c/should > > > compare performance on the various constructs. But I gladly get a response > > > from the author of doing that all by myself ;) > > > > You will have to deal with me I am afraid. Our sponsorship for this has run > > out. > > Still do not really like the construct, but have no formal argument. > Running out of sponsorship as a reason for not replying does not sound good > to me btw. The author has a moral obligation too. Welcome to open source. This comment was unnecessary. -- 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/
