RE: a problem with left join

Abaco Informática S.A. wrote:

> look at this scripts:
> 
> CREATE TABLE T1 (COD_1 FIXED(4), VAL_1 FIXED(4))
> CREATE TABLE T2 (COD_2 FIXED(4), VAL_2 FIXED(4))
> CREATE TABLE T3 (COD_3 FIXED(4), VAL_3 FIXED(4))
> INSERT INTO T1 VALUES (1,1)
> INSERT INTO T1 VALUES (2,2)
> INSERT INTO T1 VALUES (3,3)
> 
> INSERT INTO T2 VALUES (1,1)
> INSERT INTO T2 VALUES (2,2)
> 
> nothing for T3.
> 
> SELECT * FROM T1 LEFT JOIN T2 ON (VAL_1 = COD_2)           
> 
> result 3 rows (third row null in val_2,cod_2, it's work fine)
> 
> SELECT * FROM T1 LEFT JOIN T2 ON (VAL_1 = COD_2)  LEFT JOIN T3 ON (VAL_2 = COD_3)
> 
> result 2 rows  !!???
> 
> 
> i think find 3 row with nulls in the columns of 3rd. table but the row with nulls in T2 disappear, what i doing wrong.

This is a known bug and already fixed within 
release >= 7.3.0.36 and >= 7.4.3.24

Thanks for reporting.

Best regards,
Holger
SAP Labs Berlin