Learn how easy it is to sync an existing GitHub or Google Code repo to a SourceForge project! See Demo

Close

Same Alias within distinct subqueries

PAscal
2011-03-31
2013-04-15
  • PAscal
    PAscal
    2011-03-31

    Some problems found when a table or its Alias is referenced in many subqueries:

    select *
    from
    (select * from ta A,tb B where A.x=B.y) D1,
    (select * from ta A,tb B where A.x=B.y) D2

    -> 'a' is returned as the error text

    select *
    from
    (select * from A,B where A.x=B.y) D1,
    (select * from A,B where A.x=B.y) D2

    -> graph is wrong

    Regards
    PAscal

     
  • alxtoth
    alxtoth
    2011-04-03

    fixed in v0.42