Red Gate forums :: View topic - Column constraints that call a scalar function
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Source Control 1
SQL Source Control 1 forum

Column constraints that call a scalar function

Search in SQL Source Control 1 forum
Post new topic   Reply to topic
Jump to:  
Author Message
Dennis E Evans



Joined: 23 Nov 2010
Posts: 1

PostPosted: Tue Nov 23, 2010 11:19 pm    Post subject: Column constraints that call a scalar function Reply with quote

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)
Back to top
View user's profile Send private message
Chris Auckland



Joined: 24 Oct 2006
Posts: 757
Location: Red Gate Software Ltd.

PostPosted: Thu Nov 25, 2010 12:10 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group