#72 Query Builder: reverse "case when ..." is wrong

2015.04
closed
PAscal
Bug (137)
2
2015-04-18
2012-09-18
PAscal
No

Reverse
select case when DUMMY = 'X' then 1 else NULL end from dual

gives

SELECT
case when DUMMY='X'then1else NULL end
FROM
DUAL

blanks are losts

Discussion

  • Bao Nguyen

    Bao Nguyen - 2013-08-17
    • status: open --> accepted
    • assigned_to: Bao Nguyen
     
  • PAscal

    PAscal - 2013-08-18
    • status: accepted --> commited
    • Milestone: not planned --> 2013.09
     
  • PAscal

    PAscal - 2014-01-31

    reopened because problem on case in GROUP BY
    is not fixed

     
  • PAscal

    PAscal - 2014-03-26

    other problem to fix:

    case when t.l in ('A') then 'One' when t.l in ('B') then 'Two' end col
    from t

    returns

    case when t.l in ('A')('B') as col
    from t

     
    • PAscal

      PAscal - 2015-04-11

      this is fixed for case in select
      with 2015.04 release

       
  • PAscal

    PAscal - 2014-03-27

    Case WHEN VALUE between 0 and0.99 THEN ...

    was returning
    Case WHEN length( env ) 0 and0.99 THEN 1 end AS between

     
    Last edit: PAscal 2015-04-11
    • PAscal

      PAscal - 2015-04-11

      this is fixed for case in select
      with 2015.04 release

       
  • PAscal

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

    PAscal - 2014-04-16
    • Milestone: not planned --> Candidates
     
  • PAscal

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

    PAscal - 2015-04-11
    • status: open --> commited
    • assigned_to: PAscal
    • Milestone: Candidates --> 2015.04
     
  • PAscal

    PAscal - 2015-04-18
    • status: commited --> closed
     

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

Sign up for the SourceForge newsletter:





No, thanks