Hi,
I didn't have time yet to analyze the problem, but I could simplify the
test:
private void testCases2() throws Exception {
Connection conn = getConnection("nestedJoins");
Statement stat = conn.createStatement();
stat.execute("create table a(id int primary key)");
stat.execute("create table b(id int primary key)");
stat.execute("create table c(id int primary key)");
stat.execute("insert into a(id) values(1)");
stat.execute("insert into c(id) values(1)");
stat.execute("insert into b(id) values(1)");
stat.executeQuery("select 1 from a left outer join " +
"(a t0 join b t1 on 1 = 1) on t1.id = 1, c");
conn.close();
deleteDb("nestedJoins");
}
I noticed the problem goes away if I replace the last part, ", c", with
"inner join c". So I think the problem is related to using "join ... on
..." in combination with old-style "from table1, table2 where table1.x =
table2.x".
Regards,
Thomas
On Tuesday, September 8, 2015, Noel Grandin <[email protected]> wrote:
> I have cleaned this up a little and added to our test case code (in
> TestNestedJoins)
> Hopefully Thomas will have a chance to debug it, I'm not sure what is
> going on there.
>
> --
> 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.
>
--
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.
