Thinking about it some more, I think what I'm trying to accomplish can be accomplished with using association_join, will let you know if I experience any weirdness due to self referential + many_through_many....
On Friday, July 28, 2017 at 3:06:30 PM UTC-7, Jeremy Evans wrote: > > On Friday, July 28, 2017 at 11:37:10 AM UTC-7, Aryk Grosz wrote: >> >> Hi Jeremy, it seems like it's working, but why is that it essentially >> plugins in the associations twice if you opt in >> for dataset_associations_join? >> >> What if I just want the joins but not the subselect in the where clause? >> > > My recollection is you need both for correct behavior (the subselect does > the correct filtering). The joins added by dataset_associations_join > outside the subselect are if you want to also filter/order by the joined > tables . I'll certainly consider optimization patches, as long as they are > accompanied by an analysis showing the same behavior results in all cases. > > Thanks, > Jeremy > -- You received this message because you are subscribed to the Google Groups "sequel-talk" 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 https://groups.google.com/group/sequel-talk. For more options, visit https://groups.google.com/d/optout.
