> 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
