On 7/12/2013 12:30 PM, James K. Lowden wrote:
The documented behavior is - if you modify the data as you iterate
over that same data, the results are unpredictable.
Where does it say that?
You got me here. The behavior doesn't appear to be documented, and it
probably should. The closest I could find to the official word is this
post by Dr. Hipp from 2009:
http://sqlite.1065341.n5.nabble.com/Python-sqlite-binding-commit-inside-select-loop-td51927.html#a51941
"The official policy is that if you modify a table (via INSERT, UPDATE,
or DELETE) in the middle of a SELECT, then what you get from the
remainder of the SELECT is undefined."
--
Igor Tandetnik
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
