Is there any way I can control what tables are listed in the FROM clause and exactly what is put in the GROUP BY?
I'm trying to use : has "COUNT(non_referenced_table.col)" but it doesn't work because the table is not listed in the FROM. When I put in this shim to try to force the table in the FROM: indexes non_referenced_table(:col), :as => shim the new column and new GROUP BY cause the COUNT to be wrong. What I need is proper control over the FROM and GROUP BY (I realize I can add to the group_by, but I want to set it explicily). Unfortunately, without this ability, I'm afraid TS just isn't very useful to me. Any way to do this, or perhaps is there another solution? -- You received this message because you are subscribed to the Google Groups "Thinking Sphinx" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/thinking-sphinx?hl=en.
