Line Break / Bug

Hi Regate Team,

I did not find any solution to ensure the line break will look like this

before

[code]

SELECT
    shipperid, YEAR(shippeddate) AS shipyear, COUNT(*) AS numorders
FROM
    Sales.Orders
GROUP BY
    GROUPING SETS((shipperid, YEAR(shippeddate)), (shipperid), (YEAR(
                                                                    shippeddate
                                                                    )), ());

[/code]

after

[code]

SELECT
    shipperid, YEAR(shippeddate) AS shipyear, COUNT(*) AS numorders
FROM
    Sales.Orders
GROUP BY
    GROUPING SETS((shipperid, YEAR(shippeddate)), (shipperid),
    (YEAR(shippeddate)), ());

[/code]

It seems that the general! issue is that the line break will not work correctly when the setting Wrap lines long than (80) characters. It is not the expected behavior because after the line break the code has again 80 (in my example) characters to place the remaining code.

It would be nice to see a fix - thanks!

Torsten

torsten.strauss May 11, 2019 09:20

Comments

4 comments

Another good example is the formatting of the following code

SELECT
    CustomerKey
  , YEAR(OrderDate) AS OrderYear
  , SalesAmount
  , LEAD(SalesAmount, 1, 0) OVER (PARTITION BY CustomerKey
                                  ORDER BY
                                      YEAR(OrderDate)
                                 )
FROM
    FactInternetSales
WHERE
    SalesTerritoryKey = 1
    AND YEAR(OrderDate) = 2014;

it should look something like this

SELECT
CustomerKey
, YEAR(OrderDate) AS OrderYear
, SalesAmount
, LEAD(SalesAmount, 1, 0) OVER
(
PARTITION BY CustomerKey ORDER BY YEAR(OrderDate)
)
FROM
FactInternetSales
WHERE
SalesTerritoryKey = 1
AND YEAR(OrderDate) = 2014;

torsten.strauss May 12, 2019 09:26

0
@torsten.strauss

Can you share your format style file with us?

Tianjiao_Li May 13, 2019 10:43

0
Hi Tianjiao,

thanks for looking into this!

Please find attached the style.

Torsten

torsten.strauss May 13, 2019 13:40

0
Hi @torsten.strauss

Thanks for your patience!

The development team has triaged this issue. We accept this isn't right, but there are more impact issues we are currently working on so I'm afraid this behaviour won't get changed any time soon.

We apologize for the inconvenience caused.

Tianjiao_Li May 17, 2019 08:13

0

Add comment

Please sign in to leave a comment.

How can we help you today?

Line Break / Bug

Comments

Add comment