Thanks Mike. I'll try it out next week.
~ Daniel
Michael Bayer wrote:
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
