On 4/17/2014 3:43 AM, Tyumentsev Alexander wrote:
CREATE VIEW v2 as select id1 from test where id1;
CREATE VIEW v1 as select t1.id2 from test as t1 LEFT JOIN v2 ON
t1.id2=v2.id1;
DROP VIEW v2;
Is it the user responsibility to follow all dependencies and recreate
"VIEW" tree ?
I'd say it's the user's responsibility to not drop a view that is being
referred to elsewhere. If there's a bug anywhere in this, I'd say it's
the fact that SQLite allowed "DROP VIEW v2" statement to proceed.
--
Igor Tandetnik
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users