Hello, I have encountered a strange behaviour within SA, but since I seem to be making silly questions lately, I'm not attaching a full test case - I will if a bug is suspected.
session = create_session() #1st block form = session.query(Formato).get_by(id=7).reparti print form #2nd block ed = session.query(Editore).get_by(id=1).reparti print ed "reparti" is a property returning the list of object for a many-to-many relationship. there're three tables ( reparti, editori, formati ) and two association tables ( editori_reparti, formati_reparti ); they're both eager; the three tables have their corresponding classes mapped. Now, the matter. If I try commenting out either the first or second block, I get the correct results. But if I run the code as written above, the second query (this happens even switching their order) returns an empty list. I have enabled the echo, and both queries seem to get actually executed, and they look the same when commenting out the code and when having all the code run. -- Alan Franzoni <[EMAIL PROTECTED]> - Togli .xyz dalla mia email per contattarmi. Remove .xyz from my address in order to contact me. - GPG Key Fingerprint (Key ID = FE068F3E): 5C77 9DC3 BD5B 3A28 E7BC 921A 0255 42AA FE06 8F3E --~--~---------~--~----~------------~-------~--~----~ 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 [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---