[FORMATTING] TSQL with COLLATE is inconsistent
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