Different outer join results in 7.5 and 7.6 2007-02-21 - By Alexander Schmidt
Back
Hi,
we have upgraded from Maxdb 7.5 to 7.6.00.34 and get different
results using the same (outer join) query.
The following simple example can be used to reproduce the behaviour:
create table T1 ( ID int, FK_T2 fixed(32,0), primary key (ID) );
create table T2 ( ID int, FK_T3 fixed(32,0), primary key (ID) );
create table T3 ( ID int, primary key (ID) );
--
insert into T1 values( 1, 20);
insert into T1 values( 2, 21);
insert into T2 values( 20, 30);
insert into T3 values( 30);
--
select a1.ID, a2.ID, a3.ID
from T1 a1, T2 a2, T3 a3
where a1.FK_T2 = a2.ID (+)
and a2.FK_T3 = a3.ID (+)
and a3.id >0;
Result in 7.5:
ID | ID | ID
-- ---- ---- ---- --
1 | 20 | 30
Result in 7.6
ID | ID | ID
-- ---- ---- ---- --
1 | 20 | 30
2 | null | 30
How do we manage to obtain a single result row in 7.6 (without changing the
query)?
Which params can be changed?
Thanks in advance
Alexander
__ ____ ____ ____ ____ ____ ____ ____ ____ ____ ____ ____ ____ ______
Der WEB.DE SmartSurfer hilft bis zu 70% Ihrer Onlinekosten zu sparen!
http://smartsurfer.web.de/?mc=100071&distributionid=000000000066
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/maxdb?unsub=mysql@(protected)
|
|
