Check constraints are broken in Table designer

[sommarskog]

• Azure Data Studio Version: 1.50.0
• OS Version: Windows 11 24H2

Steps to Reproduce:

1. Find a table in Object Explorer. The table should have a string column.
2. Right-click, select Design. Choose the Check Constraints tab.
3. Select New Check Constraint.
4. Try to enter the constraint text [action]='REMOVE' OR [action]='STOP' OR [action]='START' (Replace action with a column in your table.)
5. This results in the error message: The input validation failed with error: The expression "[action]=''REMOVE'' OR [action]=''STOP'' OR [action]=''START''" is not a valid boolean expression.

Notes 1: The expression is legal. 2: In the error message the single quotes have been replaced by double quotes. (So the expression is now only legal if there are columns with those names. It is still a legal boolean expression, though.)

Does this issue occur when all extensions are disabled?: Yes

[kburtram]

Thanks for reporting this issue! I was able to reproduce the behavior in Azure Data Studio. It looks like this is a bug in the Table Designer’s validation layer, as the same input passes validation in other tools like SQL Server Data Tools (SSDT).

We’ll take a look and investigate a possible fix. Thanks again for bringing this to our attention!