Hi, > Drop table and drop view will also drop all views that depend on this > table / view. I will document that. However there may be a bug in that > area. I think you want to change a view, right? Could you explain what > is your use case? > Simply modify a view that has others views that depend (use) this one.
Drop all dependents is a little drastic / dangerous. If this is the case we can't trust in database as storage of sql source for views. Why don't invalidate that views in place of drop ? > The ALTER VIEW RECOMPILE command is used for views created using > CREATE FORCE VIEW. > What's the difference between a view created forced and a invalidated view ? >> I lost view 'bbb' , the view 'ccc' was invalidated >> > I can't reproduce this sorry. Could you change my test case so I also > get an invalidated view? Or maybe I didn't look correctly yet: > > I never had this problem with simple views or when depends has no more than 2 levels. Only now with version 1.2.136 , with complex views in more than 3 levels. I can't even reproce this case in others databases, but with this I can reproduce it always. > drop table test; > create table test(id int, name varchar(255)); > insert into test values(1, 'Hello'); > create view test1 as select * from test; > create view test2 as select * from test1; > create view test3 as select * from test2; > select * from test2; > drop view test1; > select * from test2; > select * from test3; > create view test1 as select 'b', * from test; > alter view test2 recompile; > select * from test2; > drop table test; Regards, Dario -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
