#193 reverse query: loosing function when column and alias are the sames

not planned
open
nobody
Bug (148)
3
2014-04-02
2014-03-26
PAscal
No

select count(z.dummy) as dummy
from
(SELECT
    dummy
FROM
    DUAL) z

after reversing sql is:
SELECT
    z.dummy
FROM
    (SELECT
        dummy
     FROM
        DUAL) z

count() is lost

Discussion

  • PAscal

    PAscal - 2014-03-26
    • Description has changed:

    Diff:

    --- old
    +++ new
    @@ -1,4 +1,4 @@
    -select count(z.dummy) dummy
    +select count(z.dummy) as dummy
     from
     (SELECT
         dummy 
    
     
  • PAscal

    PAscal - 2014-04-02

    workarround:
    change alias name

     
  • PAscal

    PAscal - 2014-04-02
    • priority: 2 --> 3
     

Log in to post a comment.