dan - changeset 1278 contains the fix for this bug. the "batching" code in the dependency sort doesnt really work correctly so I took it out.
the only negative implication of this change is that an adjacency list tree is not "batched" when it deletes (i.e. it deletes A, B, C, D, E, F, G in separate DELETE statements instead of "A,B,C", "D,E", "F", "G", for example). If I can figure out how to "batch" it correctly then itll be back. Daniel Miller wrote: > Michael Bayer wrote: >> >> The only way I could have the slightest idea whats going wrong would be >> to >> run it (well, to see the output of the UOW dump also but thats never >> enough)....and since I am short on time this week it would be massively >> helpful if you could provide a complete working example of the problem, >> since otherwise I have to resurrect such an example myself (or if anyone >> else on the list thinks they have an idea.) > > No worries, I've come up with a test that fails (attached). I also > included a very similar test that passes (this highlights one of the > strange quirks of the bug). > > Note, this test only fails on a database that enforces referential > integrity (i.e. not sqlite). However, when running it on sqlite you can > see that the "d" row is deleted before it's parent "c" row, which should > throw a referential integrity error. > > This is a very strange bug. I believe it may even be intermittent. The > test I have attached seems to fail every single time on my machine, but > when I added doc strings to the tests they both passed...very odd. > However, it is encouraging to me that I was able to reproduce this bug at > home since I originally discovered it at work with a totally different > setup. Let me know if you need anything else. > > ~ Daniel > ------------------------------------------------------- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642 _______________________________________________ Sqlalchemy-users mailing list Sqlalchemy-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
