That is clear of course.
But what is the standard sql behaviour?
According to Dario DB2 respects the meaning of star in the select clause
(or did I understand it right?)
And I would say that DB2 is as sql compliant as a database gets.
Maybe because IBM has been the key player in defining the sql standard.
What does sql say about this?
Anyone?
I am too lazy to start diggin' :-)
Especially because most of the time sql gets it wrong :-D
I am a little bit skeptical about there being a solid standard in the world
about these kind of corner cases. My experience with databases is that
they are not very compatible, but they are similar.
- Rami
5.10.2010 21:50, Sergi Vladykin kirjoitti:
All in all this is still a convenience feature because even now one can
always recreate the view when the underlying table changes.
Yes, but for real behavior should match sql standard or at least other
popular databases to be predictable for users. Otherwise it will
become a quirk instead of a feature.
regards,
S.Vladykin
--
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.
