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
-~----------~----~----~----~------~----~------~--~---
