https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26567 --- Comment #16 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- (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. -- You are receiving this mail because: You are watching all bug changes.