Bug in SQL Compare with built-in function concat_ws

HugoDeVreugd

I created a computed column on a table with function concat_ws.
SQL Server Management Studio generates this code:

[FullName]  AS (concat_ws(' ',[CallName],[MiddleName],[LastName])),

SQL Compare generates this code:

[FullName] AS ([concat_ws](' ',[CallName],[MiddleName],[LastName]))
The brackets around concat_ws cause a syntax error.

Tianjiao_Li

Thanks for reporting this issue!

We have reproduced it and logged as SC-10625. We'll keep here posted with any further update.

Alex B

Hi @HugoDeVreugd,

Apologies for the late reply here, the issue in the bug tracking system wasn't updated until just now.

This has been released (for a little while now, since 13.7.21) so if you have not already, please update to the a version later than this (the latest is currently 14.0.6).

Kind regards,
Alex