Column constraints that call a scalar function
Dennis 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)
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
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.