Hi, > I wish to know about what's expected to happens when a view that is used > in some others views is recreated. > > I suppose that all dependent views become invalid (not dropped) , ok ? > > Then, what's the best way to re-validate invalid views ? >
On a database was properly migrated to 1.2.136 and was in use from weeks. I have a problem and a question, about doing something like this: create view aaa as select ... create view bbb as select * from aaa ... create view ccc as select * from bbb ... create view ddd as select * from ccc, aaa ... ... SET AUTOCOMMIT OFF; DROP VIEW aaa ; CREATE VIEW aaa AS ...; COMMIT; Doing that I lost view 'bbb' , the view 'ccc' was invalidated but 'ddd' does not. Then I try to revalidate this view using: ALTER VIEW ccc RECOMPILE; that end without errors but the view remain invalid. I will try to do a reproducible test case. 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.
