How can we help you today? How can we help you today?

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

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)


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

Comments

4 comments

Sort by
  • VladI
    UPDATE 1
    Same undesirable behavior is applicable to EventId column name.
    VladI
    0
  • Russell D
    Hi Vladl, are you still seeing this on 9.1.12?
    Russell D
    0
  • VladI
    Confirmed on 9.1.12 - this issue still occurring.
    VladI
    0
  • 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
    VladI
    0

Add comment

Please sign in to leave a comment.