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

Candidates
open
nobody
Bug (75)
2
1 day ago
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
    2014-03-27

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

     
  • PAscal
    PAscal
    2014-04-02

    • priority: --> 3
     
  • PAscal
    PAscal
    1 day ago

    • Milestone: not planned --> Candidates
     
  • PAscal
    PAscal
    1 day ago

    • priority: 3 --> 2