Thank you for the analzyis, but our problem is that the statement is
generated by JPA, so we can't control how the statements are generated. For
workaround we are using Postgresql for testing, but it is a very
unconfortable for our developers, we like the simplicity of H2.
Regards,
Robert
2015. szeptember 10., csütörtök 7:42:19 UTC+2 időpontban Thomas Mueller a
következőt írta:
>
> 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]
> <javascript:>> 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.
