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.
