Version 12 0 175 - Format error when using CAST function

When SQL files or scripts make use of the CAST function the format option does not work.
Using the command line option it generates an error message.
Exception EAccessViolation in module SqlAssistPrefs.dll at 0000FBE7.
Access violation at address 0810FBE7 in module 'SqlAssistPrefs.dll'. Read of address 6574615F.

A simple example
SELECT CAST ('aaa'

AS

CHAR(10) )

The same SQL code worked fine in version 11.x

Thank you very much for letting us know. We will investigate this issue.

At this moment I am working on another workstation I own, where also version 12 is installed.
At this workstation the formatiing works as expected.
This suggest that it is a local issue, maybe not related to the software.
What is the best option to reset all settings and so on to a really default value?

Keeps getting stranger, at this workstation formatting works in SQL Assistance editor but not in Management Studio 18.9

SELECT @WarrEndDate =
CASE WHEN @WarrPeriodUnit
= 1 THEN dateadd(yy, CAST(@WarrPeriod AS int), @ShipDate)
WHEN @WarrPeriodUnit
= 2 THEN dateadd(mm, CAST(@WarrPeriod AS int), @ShipDate)
WHEN @WarrPeriodUnit
= 3 THEN dateadd(wk, CAST(@WarrPeriod AS int), @ShipDate)
WHEN @WarrPeriodUnit
= 4 THEN dateadd(dd, CAST(@WarrPeriod AS int), @ShipDate)
END;

Can you please unregister The plugin for the Management Studio, and then reregister it. You can use the Options dialog for that purpose.

This does nog help.
I have got mail that your development was also working on it.

I'm sorry. Working on what?

Have you tried that in Run as Administrator mode?

The code formatting issue has been fixed in build 12.0.181, that build can be installed using Check for Updates menu

	SysOp wrote:
	The code formatting issue has been fixed in build 12.0.181, that build can be installed using Check for Updates menu

Checking for updates with 12.0.175 claims there are no updates as of 11/3/21 10:44 Central

	Quote:
	Checking for updates with 12.0.175 claims there are no updates as of 11/3/21 10:44 Central

There was a minor technical issue on our end making the Check for Updates incorrectly report that there are no updates. The cache has been reloaded and now Check for Updates is able to find build 12.0.181

A newer version was released.
I installed it and ran all of my test scripts.
Formatting was completed without issues.
If anyone has simillar problems, updating the software to the latest version will resolve the formatting errors.

Thank you so much for confirming the issue has been resolved.