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/[EMAIL PROTECTED]
