Column constraints that call a scalar function

A SQL Server Management Studio add-in to source control your database in Subversion or Team Foundation Server.

Column constraints that call a scalar function

Postby Dennis E Evans » Tue Nov 23, 2010 10:19 pm

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
Posts: 1
Joined: Tue Nov 23, 2010 10:14 pm

Postby Chris Auckland » Thu Nov 25, 2010 11:10 am

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
Posts: 760
Joined: Tue Oct 24, 2006 1:12 pm
Location: Red Gate Software Ltd.

Return to SQL Source Control Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests