Hi, > I wish to know about what's expected to happens when a view that is used > in some others views is recreated.
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? The ALTER VIEW RECOMPILE command is used for views created using CREATE FORCE 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: 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, Thomas -- 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.
