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

Bug in SQL Compare with built-in function concat_ws

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.
Hugo de Vreugd
0

Comments

2 comments

Sort by
  • 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.
    Tianjiao_Li
    0
  • Alex B
    Hi @...,

    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
    Alex B
    0

Add comment

Please sign in to leave a comment.