Update screws up order_by on has_many prefetched results
I wonder if someone can help me: I have a table of "matches", under which there will be a has_many relationship with a number of "games" (relationship: "league_team_match_games"), which has two different types of game number: actual_game_number and scheduled_game_number; the scheduled_game_number forms part of the primary key,
though I don't see that that makes a difference, except perhaps that by
default the database engine will return columns in that order. When retrieving a given match, I'm doing something like the following to retrieve the games in the order they were played:
Does anyone know why this would be? I've checked what I think would be the relevant parts of the documentation and can't see anything - though it's entirely possible, if not probable that I'm being completely stupid. The DB is MySQL if that makes a difference.