Hi, This is now fixed (in the trunk).
Regards, Thomas On Thursday, July 3, 2014, Thomas Mueller <[email protected]> wrote: > 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.
