Ruby on Rails

On Wednesday, August 24, 2016 at 1:11:42 PM UTC+1, Bazley wrote:

This rails/sql code...

    @new_relationships = User.select('*')
                             .from("(#{@rels_unordered.to_sql}) AS rels_unordered")
                             .joins("
                        INNER JOIN  relationships
                        ON          rels_unordered.id = relationships.character_id
                        ORDER BY    relationships.created_at DESC
                        ")

produces a query that begins like this:

    SELECT COUNT(*) FROM (SELECT .....

Why is it counting the records?? I haven't asked for a count. I simply want to select all columns after the join:

The code you posted above doesn't actually run any query - queries are executed lazily. What are you doing with @new_relationships? 

Fred