Thanks Pat for your reply! Ok, I understand that something internally changed in thinking sphinx but I can't understand why in my particular example GROUP BY is needed. It is just simple SQL query with LEFT JOIN clause. There are used no aggregate functions so why GROUP BY is needed?
On Monday, July 1, 2013 1:25:25 PM UTC+2, Pat Allan wrote: > > Hi Radosław > > There was something in older versions of Thinking Sphinx that checked > whether MySQL was being used, and then checked if that MySQL server had a > particular flag set (to see whether GROUP BY clauses must be complete, or > could be missing/incomplete). If the latter was true, then the GROUP BY > clause was not included. > > I'm not particularly keen with having the special behaviour for one > database, but I understand it's not ideal from a speed perspective for > MySQL users. I'd be open to a patch that adding this behaviour in, but I'd > much prefer a solution that offered appropriate hooks for other devs to > extend the SQL generation themselves directly. I've no idea what that would > look like, though, so even just the simpler patch would be a good start. > > Kind regards, > > -- > Pat > > -- You received this message because you are subscribed to the Google Groups "Thinking Sphinx" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/thinking-sphinx. For more options, visit https://groups.google.com/groups/opt_out.
