On Sun, 30 Jun 2013 23:27:23 -0400
Igor Tandetnik <[email protected]> wrote:
> On 6/30/2013 11:13 PM, Igor Korot wrote:
> > Well I will use another statement variable as in the sample code.
> > My questions was: if I call delete on the record that was just
> > retrieved in another query will this delete affects it?
>
> If you change data that a live SELECT statement is iterating over,
> the outcome is unpredictable. It may appear to work, it may skip
> rows, it may return some rows more than once
Really? That's not what SERIALIZABLE means.
If I have 10-row table T and issue
select * from T;
and from a different process issue
delete * from T;
you're saying the SELECT statement may fetch any number of rows
between 0 and 10?
--jkl
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
