Hi,
Thanks a lot for the quick solution! I tried with your fixes today and
it's working now.
Btw, as I'm using many queries with 'IN (...)', updating to this
version improved the execution times by almost 50%! Thanks a lot for
the great product and support!
Regards,
Prashant
On Oct 14, 3:16 am, "Thomas Mueller" <[EMAIL PROTECTED]>
wrote:
> Hi,
>
> Thanks a lot for your test case! I found the problem (actually there
> were two) and I found a solution. The workaround is (as you know) to
> use version 1.0.79 (2008-09-26). Another workaround is to disable the
> system property h2.optimizeInJoin. I tried to run your test case,
> unfortunately 'mvn' didn't work for me... I got this exception:
> Missing: 1) org.apache.geronimo.specs:geronimo-jpa_3.0_spec:jar:1.1 -
> but I am quite sure it works now.
>
> I also found a simpler test case:
>
> create table test(a int, b int, c int, d int)
> as select 1, 1, 1, 1 from dual;
> SELECT 2 FROM TEST A
> INNER JOIN (SELECT DISTINCT B.C AS X FROM TEST B
> WHERE B.D = ?2) V ON 1=1 WHERE (A = ?1) AND (B = V.X) {1: 1, 2: 1};
> drop table test;
>
> Unfortunately this doesn't work with 1.0.79.
>
> I am still testing the fix, but I am almost sure this problem will be
> solved in the next release.
>
> Regards,
> Thomas
>
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
