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
reopened because problem on case in GROUP BY is not fixed
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
this is fixed for case in select with 2015.04 release
Case WHEN VALUE between 0 and0.99 THEN ...
was returning Case WHEN length( env ) 0 and0.99 THEN 1 end AS between
Log in to post a comment.
reopened because problem on case in GROUP BY
is not fixed
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
this is fixed for case in select
with 2015.04 release
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
this is fixed for case in select
with 2015.04 release