Work at SourceForge, help us to make it a better place! We have an immediate need for a Support Technician in our San Francisco or Denver office.

Close

full outer join problems

PAscal
2011-05-04
2013-04-15
  • PAscal
    PAscal
    2011-05-04

    This statement
    select * from A full outer join B
    on nvl(a.id,0)=nvl(b.id,0)

    generates a wrong graph (hedge is lost)

    and this one:
    select * from A full outer join (select * from T) B
    on a.id=b.id

    doesn't generate any graph at all

    Regards
    PAscal

     
  • alxtoth
    alxtoth
    2011-05-17

    Hi,

    Problem is with simplifier . Both theese work:

    select * from A full outer join B on a.id=b.id
    select * from A full outer join B on 0 and g(a.id)  = f(b.id,0)

    -Alex