[FORMATTING] TSQL with COLLATE is inconsistent

[svantek-admin]

Input data

Which SQL and options did you provide as input?

sql-formatter --language tsql file.sql

SELECT [Code] COLLATE Polish_CI_AS as [Code]
      ,[OwnerCode] COLLATE Polish_CI_AS as [OwnerCode]
      ,[Name] COLLATE Polish_CI_AS as [Name]
      ,[Code] COLLATE Polish_CI_AS as [Code]
      ,[FullName] COLLATE Polish_CI_AS as [FullName]
      ,[IsRecipient]
      ,[IsShipper]
      ,[IsSupplier]
      ,[Nip] COLLATE Polish_CI_AS as [NIP]
      ,[AddressCountry] COLLATE Polish_CI_AS as [Country]
      ,[AddressTown] COLLATE Polish_CI_AS as [Town]
      ,[AddressStreet] COLLATE Polish_CI_AS as [Street]
      ,[AddressHouse] COLLATE Polish_CI_AS as [House]
      ,[AddressZipcode] COLLATE Polish_CI_AS as [ZipCode]
      ,[AddressPost] COLLATE Polish_CI_AS as [Post]
      ,[AddressPhone] COLLATE Polish_CI_AS as [Phone]
      ,[AddressEmail] COLLATE Polish_CI_AS as [Email]
      ,[AddressContact] COLLATE Polish_CI_AS as  [Contact]
  FROM [Tiger4_SVANTEK_PROD].[dbo].[ContractorListItemView]
  order by code

Expected Output

I'm not sure how this should be formatted, it should probably follow the formatting when COLLATE is not used.

SELECT
  [Code] COLLATE Polish_CI_AS as [Code],
  [OwnerCode] COLLATE Polish_CI_AS as [OwnerCode],
  [Name] COLLATE Polish_CI_AS as [Name],
  [Code] COLLATE Polish_CI_AS as [Code],
  [FullName] COLLATE Polish_CI_AS as [FullName],
  [IsRecipient],
  [IsShipper],
  [IsSupplier],
  [Nip] COLLATE Polish_CI_AS as [NIP],
  [AddressCountry] COLLATE Polish_CI_AS as [Country],
  [AddressTown] COLLATE Polish_CI_AS as [Town],
  [AddressStreet] COLLATE Polish_CI_AS as [Street],
  [AddressHouse] COLLATE Polish_CI_AS as [House],
  [AddressZipcode] COLLATE Polish_CI_AS as [ZipCode],
  [AddressPost] COLLATE Polish_CI_AS as [Post],
  [AddressPhone] COLLATE Polish_CI_AS as [Phone],
  [AddressEmail] COLLATE Polish_CI_AS as [Email],
  [AddressContact] COLLATE Polish_CI_AS as [Contact]
FROM
  [Tiger4_SVANTEK_PROD].[dbo].[ContractorListItemView]
order by
  code

Actual Output

SELECT
  [Code]
COLLATE Polish_CI_AS as [Code],
[OwnerCode]
COLLATE Polish_CI_AS as [OwnerCode],
[Name]
COLLATE Polish_CI_AS as [Name],
[Code]
COLLATE Polish_CI_AS as [Code],
[FullName]
COLLATE Polish_CI_AS as [FullName],
[IsRecipient],
[IsShipper],
[IsSupplier],
[Nip]
COLLATE Polish_CI_AS as [NIP],
[AddressCountry]
COLLATE Polish_CI_AS as [Country],
[AddressTown]
COLLATE Polish_CI_AS as [Town],
[AddressStreet]
COLLATE Polish_CI_AS as [Street],
[AddressHouse]
COLLATE Polish_CI_AS as [House],
[AddressZipcode]
COLLATE Polish_CI_AS as [ZipCode],
[AddressPost]
COLLATE Polish_CI_AS as [Post],
[AddressPhone]
COLLATE Polish_CI_AS as [Phone],
[AddressEmail]
COLLATE Polish_CI_AS as [Email],
[AddressContact]
COLLATE Polish_CI_AS as [Contact]
FROM
  [Tiger4_SVANTEK_PROD].[dbo].[ContractorListItemView]
order by
  code

Usage

• How are you calling / using the library?

sql-formatter --language tsql file.sql

• What SQL language(s) does this apply to?

TSQL

• Which SQL Formatter version are you using? (The exact version number.)

Version: 15.6.9

[nene]

Thanks for reporting. Fixed.

Though really this whole Transact-SQL support needs a proper overhaul.

[nene]

Fixed in 15.6.10