Re: Different outer join results in 7.5 and 7.6

Since you are doing an outer join 7.6 is correct while your 7.5
results are wrong. As it stands you're asking for the reintroduction
of a bug. :-)

If you want only one row don't use an outer join.

Kind regards

robert

2007/2/21, Alexander Schmidt <[email protected]>:
> 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]
>
>


-- 
Have a look: http://www.flickr.com/photos/fussel-foto/

-- 
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/[email protected]