> Hash/merge algorithms are not supported for outer joins (yet).
> 
> 
> Dmitry
> 

This is somewhere in tracker or this should not go to the tracker?
And when this is planned to be supported - in FB3 Beta 2 or after FB3 release?


PS.
in Interbase for query
SELECT
        *
FROM
        RDB$RELATION_FIELDS RF
        left join RDB$RELATIONS R on R.RDB$SYSTEM_FLAG = RF.RDB$FIELD_POSITION
WHERE 
RF.RDB$RELATION_NAME BETWEEN 'RDB$RELATIONS' AND 'RDB$RELATIONS2'

not the hash but sort - but eliminate unnecessary full scan
PLAN MERGE (SORT (RF INDEX (RDB$INDEX_4)),SORT (R NATURAL))


regards,
Karol Bieniaszewski
 





------------------------------------------------------------------------------
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Reply via email to