On 24 Nov 2010, at 3:08am, Pavel Ivanov wrote: > Probably SQLite's implementation allows some other types of behavior, > but in any case behavior would be "erroneous" and unpredictable, so > you better avoid changing table that is currently being selected, or > at very least avoid changing indexed fields if their index is used in > the query.
Also, since the behaviour is undocumented and weird, it can change between different versions of SQLite. So you might write your application depending on one behaviour, then find it doesn't work when you upgrade to a newer version. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
