[HACKERS] Why NESTED LOOP Not Allowed for FULL and RIGHT Join.

[Rushabh Lathia]

Hi,

can anyone let me know that why Nested Loop path is not allowed if jointype
are JOIN_RIGHT or JOIN_FULL?


At match_unsorted_outer(), we having case where nestjoinOK = false if there
are
JOIN_RIGHT or JOIN_FULL.

match_unsorted_outer()
{
....
        case JOIN_RIGHT:
        case JOIN_FULL:
            nestjoinOK = false;

..
}

wondering why ?

Regards,
Rushabh Lathia

[EMAIL PROTECTED]