Kevin, > Anyone else noticed this strangeness with GROUP BY and ORDER BY being > included for all association retrievals? Any tips where to look in > the source?
That's just the default behaviour to make the RDBMS act more consistent with other datastores. The explicit grouping is to remove duplicate records from the results, which is consistent with relational algebra, where all results are sets (all records are unique). You can disable this behaviour by supplying two options to the finder: group.users(:unique => false, :order => nil) This should remove the GROUP BY as well as the ORDER BY. -- Dan -- You received this message because you are subscribed to the Google Groups "DataMapper" 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/datamapper?hl=en.
