7.0.3 beta - nested case expressions not correct beautified

[orca777]

SELECT k.Kdnr AS Bskunde,
       CASE
         WHEN k.Kdnr IS NULL THEN
          NULL
         ELSE
          Sys_Guid()
       END AS Bskunde_Id,
       CASE
         WHEN k.Kdnr IS NULL THEN
          NULL
         ELSE
          0
       END AS Bskunde_Type,
       --
       k.Gskdnr AS Gskunde,
       CASE
         WHEN k.Gskdnr IS NULL THEN
          NULL
         ELSE
          Sys_Guid()
       END AS Gskunde_Id,
       CASE
         WHEN k.Gskdnr IS NULL THEN
          NULL
         ELSE
          1
       END AS Gskunde_Type,
       --
       k.Gbkdnr AS Gbkunde,
       CASE
         WHEN k.Gbkdnr IS NULL THEN
          NULL
         ELSE
          Sys_Guid()
       END AS Gbkunde_Id,
       CASE
         WHEN k.Gbkdnr IS NULL THEN
          NULL
         ELSE
          2
       END AS Gbkunde_Type,
       --
       Nvl(k.Tvbkdnr,
           k.Vbkdnr) AS Tvkunde,
       CASE
         WHEN k.Tvbkdnr IS NULL THEN
          CASE
         WHEN k.Vbkdnr IS NULL THEN
          NULL
         ELSE
          Sys_Guid()
       END ELSE Sys_Guid() END AS Tvkunde_Id,
       CASE
         WHEN k.Tvbkdnr IS NULL THEN
          CASE
         WHEN k.Vbkdnr IS NULL THEN
          NULL
         ELSE
          3
       END ELSE 3 END AS Tvkunde_Type,
       CASE
         WHEN (k.Tvbkdnr IS NULL AND k.Vbkdnr IS NOT NULL) THEN
          1
         ELSE
          0
       END AS Tv_Virtual,
       k.Tvbkdbez,
       --
       k.Vbkdnr AS Vbkunde,
       CASE
         WHEN k.Vbkdnr IS NULL THEN
          NULL
         ELSE
          Sys_Guid()
       END AS Vbkunde_Id,
       CASE
         WHEN k.Vbkdnr IS NULL THEN
          NULL
         ELSE
          4
       END AS Vbkunde_Type,
       k.Vbkdbez
  FROM Imp_Baskund k
 WHERE (k.Gskdnr IS NOT NULL OR k.Gbkdnr IS NOT NULL OR k.Tvbkdnr IS NOT NULL OR
       k.Vbkdnr IS NOT NULL)
   AND k.Kdkoinkz = 'N';

Greetings
Karl

 

[orca777]

Hi,
look for

CASE
         WHEN k.Tvbkdnr IS NULL THEN
          CASE
         WHEN k.Vbkdnr IS NULL THEN
          NULL
         ELSE
          Sys_Guid()
       END ELSE Sys_Guid() END AS Tvkunde_Id,

Karl

 

[Marco Kalter]

This is indeed a known problem with nested case expressions. It will be fixed.