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

     

Log in to post a comment.

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:

JavaScript is required for this form.





No, thanks