Bug With Fillfactor

torsten.strauss

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

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

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