5.10.2010 21:15, Sergi Vladykin kirjoitti:
I think the more important thing that view_defenition should always be
consistent with real view structure (query from view_defenition should
return the same result that query from the view), so if it will
contain wildcards then it should be rebuilded automatically each time
underlying table changes with respect to this changes. But for many
real applications it is undesirable behavior because views are
frequently targeted to be a stable interface to evolving underlying
table structure and changes in tables should not propagate on views.
I do agree on the view stability issue.
But then again someone who wants his views to stay stable could always
create it by explicitly naming the columns in the definition.
And someone who wants his view to be dynamic could use the star notation.
All in all this is still a convenience feature because even now one can
always recreate the view when the underlying table changes.
- Rami
--
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.
