Column constraints that call a scalar function

[Dennis E Evans]

Using TFS

When a column has a default value constraint that calls a scalar function that looks like this

dbo.someFunc(param1, DEFAULT)

the word default is stripped and yhis gets committed

dbo.someFunc(param1, )

System then shows the table as having changes that are not commited.

work around is to write the constraint as

dbo.someFunc(param1, 0)

[Chris Auckland]

Thanks for your post.

I've recreated this, and it seems that we're not expecting the DEFAULT keyword to be supplied as a parameter, and are ignoring it.

I have logged this as a bug with SQL Source Control (SOC-1873)

Thanks for taking the time to report this.
_________________
Chris