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
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to