Bug in SQL Prompt 9.1.11.5038, Visual Studio 2017 (version 15.7)

VladI

Hello,

I'm using custom formatting style in Visual Studio 2017, version 15.7.

Issue:

After applying the style (Ctrl+K, Ctrl+Y), if target column of reference constraint is named [Id], the case will be changed to lower: [Id] => [id].
I'm not facing with this issue if column has different name.
Also on  Options -> Styles -> Edit Formatting Style -> Casing ("Preview current query" checkbox is turned on) the formatting is displayed as expected.

This issue occurred only with Visual Studio 2017.

Expected behavior:

Keep the case of any column as is:

CONSTRAINT FK_Application_ApplicationType 
           FOREIGN KEY (TypeId) REFERENCES dbo.ApplicationType (Id)
<br>--After (Ctrl+K, Ctrl+Y) the case of Id should be unchanged
<br>CONSTRAINT&nbsp;FK_Application_ApplicationType&nbsp;
           FOREIGN&nbsp;KEY&nbsp;(TypeId)&nbsp;REFERENCES&nbsp;dbo.ApplicationType (<strike><b>id</b></strike>)

Please, let me know if there are any workarounds.
  
Thank you,
Vlad

VladI

UPDATE 1
Same undesirable behavior is applicable to EventId column name.

Russell D

Hi Vladl, are you still seeing this on 9.1.12?

VladI

Confirmed on 9.1.12 - this issue still occurring. 

VladI

UPDATE 2 (9.1.12, VS 2017 only)


Looks like any field name not in PascalCase is converting to lowercase in CREATE NONCLUSTERED COLUMNSTORE INDEX statement.

Examples 
Case is changed to lowercase( but it should not ):
Id => id,
Name => name,
Memo => memo,
Hostname => hostname

Case is  unchanged(as expected):
SourceIp => SourceIp,
HostName => HostName