Hi, This is a correct behavior. The view actually doesn't contain wildcards, it contains all table columns for the moment of creation. So if you want to add the column to the view too you have to explicitly recreate it.
On 5 окт, 10:04, "[email protected]" <[email protected]> wrote: > Hi, > > I wonder if followings is a correct behavior or a bug. > > sql> CREATE TABLE t (a INT,c INT); > sql> CREATE VIEW tv AS SELECT * FROM t; > sql> SELECT * FROM tv; > A |C > > sql> ALTER TABLE t ADD COLUMN b INT BEFORE c; > sql> SELECT * FROM t; > A |B |C > sql> SELECT * FROM tv; > A |C > > "ALTER TABLE" query to the table that has views is successful, > but the view's column (as determined by asterisk) are not changed. > I've used version 1.2.141. > > Thank you. -- 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.
