I see this behavior when using the H2 Shell, if I describe a table that exists in multiple schemas I see an aggregate list of their columns. For example:
CREATE TABLE bar(id BIGINT, data VARCHAR); CREATE SCHEMA foo; CREATE TABLE foo.bar(id BIGINT, data2 VARCHAR); SET SCHEMA foo; DESCRIBE bar; The describe will show four columns: ID, ID, DATA, and DATA2. Not sure if this is a bug, but I sure didn't expect what I saw. -- 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.
