Andrew wrote: > > This is very confusing; I have an ORM generated SQL statement that is > joining on a specific id. However, when I run it, for some reason, > the specific id (that was joined on) is occasionally None! However, > when I run the generated SQL copied from the server's debug log in > SQLDeveloper, I get all the IDs correctly. > > To top it off, on those liens where the id is missing, there are > several other values missing. > > Since this runs correctly in SQLDeveloper, could this be a problem > with SQLAlchemy? If so, why does it work for most of the rows in a > single query?
no idea. I don't understand what you mean by "the specific id that is joined on is occasionally None", you're joining on it *and* returning it ? is the join an outer join ? in short, there's no way for us to know where the problem lies without many more specifics. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---