Pavel,
What will happen if you had an index on the other_column for the
select/update you mentioned below? Is it just that your tree will be
unbalanced every time you change the other_column? Could there be any other
consequences like unpredictable behavior and such?
Thanks
> Exactly this sequence is safe. Things can go nuts in case if you have
> index on other_column and you do something like this:
>
> for value in "SELECT main_column IN mytable WHERE
> other_column='something'":
> UPDATE mytable SET other_column='foobar' WHERE main_column=value
>
> Pavel
>
--
View this message in context:
http://old.nabble.com/UPDATE-during-SELECT-tp30253771p30284918.html
Sent from the SQLite mailing list archive at Nabble.com.
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
