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

Column constraints that call a scalar function

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)
Dennis E Evans
0

Comments

1 comment

Sort by
  • 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 Auckland
    0

Add comment

Please sign in to leave a comment.