Hi, select * from table(a int = (1,2,3)), table(b int = (3,4,5)) >
In this case, both tables have the name "table", and H2 gets confused. I consider that a bug. A similar case is: drop table table_a; drop table table_b; create table table_a(a int); insert into table_a values(1); create table table_b(b int); insert into table_b values(2); select * from table_a as x, table_b as x; Some other databases throw an exception (PostgreSQL: "table name "x" specified more than once", MySQL, Apache Derby), for some it works (HSQLDB, SQLite). I think both is fine. Regards, Thomas -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
