Hi,
This is a bug, and I will try to fix it in the next release. However I
also suggest that you use the ANSI join syntax if possible. I think
this would be:
select distinct a.col_a1,
a.col_a2,
b.col_b1,
b.col_b2
from a a
left outer join b b on a.col_a1 = b.col_b1(+)
and a.col_a2 = b.col_b2(+);
Regards,
Thomas
On Fri, Feb 13, 2009 at 9:28 AM, contentcode <[email protected]> wrote:
>
> The query below results in an ArrayIndexOutOfBoundException (Oracle
> compatibility mode). When changing the query to perform the left outer
> join on a single column, it works fine.
>
>
> create table a (
> col_a1 number not null,
> col_a2 number not null
> );
> insert into a (col_a1, col_a2) values (1,1);
> insert into a (col_a1, col_a2) values (2,2);
>
> create table b(
> col_b1 number not null,
> col_b2 number not null
> );
>
> insert into b(col_b1, col_b2) values (1,1);
>
> select distinct a.col_a1,
> a.col_a2,
> b.col_b1,
> b.col_b2
> from a a,
> b b
> where a.col_a1 = b.col_b1(+)
> and a.col_a2 = b.col_b2(+);
>
> Pls advice.
>
> Best regards,
>
> Chris.
>
> >
>
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
