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

Bug With Fillfactor

Hi !

The following syntax will successfully parsed but SQLPrompt will raise an error.

ALTER TABLE one_side ADD CONSTRAINT PKCL_one_side_col1 PRIMARY KEY (col1)
WITH FILLFACTOR = 100;
GO

The official syntax includes FillFactor in square brackets, but SQLPrompt suggests FillFactor without these brackets.

ALTER TABLE one_side ADD CONSTRAINT PKCL_one_side_col1 PRIMARY KEY (col1)
WITH (FILLFACTOR = 100);
GO

Therefore, either remove "FillFactor without brackets" from the proposal, or make sure SQLPrompt does not throw an error if brackets are not used.

Thanks!

Torsten
MVP
torsten.strauss
0

Comments

2 comments

Sort by
  • Alex B
    Hi @torsten.strauss,

    I see this occurring as well and I have reported it to the team as SP-7766.  I will update you when I have further information from the team!

    Kind regards,
    Alex
    Alex B
    0
  • Alex B
    Hi @torsten.strauss,

    This issue should now be fixed in the latest version.  Please update and let me know if you still experience any issues!

    Kind regards,
    Alex
    Alex B
    0

Add comment

Please sign in to leave a comment.