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.

Moderators: Chris Auckland, David Atkinson, sherr, PhilScrace

Column constraints that call a scalar function

Postby Dennis E Evans » Tue Nov 23, 2010 11: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 11:14 pm

Postby Chris Auckland » Thu Nov 25, 2010 12:10 pm

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


Return to SQL Source Control 1

Who is online

Users browsing this forum: No registered users and 0 guests