#123 Reverse query: select (subquery) x from ... looses alias

2013.09
closed
Bug (147)
2013-09-16
2013-06-12
PAscal
No

Discussion

  • PAscal

    PAscal - 2013-06-12
    • labels: --> Bug
     
  • PAscal

    PAscal - 2013-08-24

    how to reproduce

    file -- new query
    choose a table T1
    rigth click on select icon
    choose add subquery
    open SUBQUERY tree
    choose a field2 and a table T2

    go to syntax window gives something like

    SELECT
         ( SELECT field2 FROM T2 )
    FROM
         T1

    modify it and go back to designer window should work
    except when le subquery as an alias like

    SELECT
         ( SELECT * FROM T2 ) SUB1
    FROM
         T1

    going to designer and comming back to syntax gives

    SELECT
         ( SELECT * FROM T2 ),
         SUB1
    FROM
         T1

    that is different

     
  • PAscal

    PAscal - 2013-09-04

    warning message saying that "Alias : name on subquery is not supported yet"
    available in code commit r136, but no more used as feature is fully implemented

     
    Last edit: PAscal 2013-09-07
  • PAscal

    PAscal - 2013-09-04
    • status: open --> commited
    • assigned_to: Bao Nguyen
    • Milestone: not planned --> 2013.09
     
  • PAscal

    PAscal - 2013-09-09
    • status: commited --> tested
     
  • PAscal

    PAscal - 2013-09-16
    • status: tested --> closed
     

Log in to post a comment.

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

Sign up for the SourceForge newsletter:





No, thanks