Column constraints that call a scalar function

Dennis E EvansDennis E Evans Posts: 3 Bronze 2
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)

Comments

  • 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
Sign In or Register to comment.