UDT Table Type requires repeated commit

I have a database under TFS shared development source control. There is one UDT out of about twenty that continuously shows up on the commit tab of source control.

There are no changes being made to this UDT and curiously, the diff at the bottom of the source control tab does not indicate any differences.

However, if this UDT is selected and committed, when the screen is refreshed, it still remains in the list of objects requiring committing.

Any ideas on why this single UDT might always appear to need a commit?

John Palmer June 27, 2012 17:39

Comments

4 comments

I'm not sure. Could you post the DDL for the type and I'll see if I can reproduce it here?

Chris Auckland July 02, 2012 14:53

0

Thanks for the reply, Chris...

After playing with this for a while, I suspect it has to do with default and check constraints, however I find it curious that the compare doesn't find (or at least display) any differences.

This is how the table type scripts out as a CREATE:

USE &#91;dev_cisitem&#93;
GO

CREATE TYPE &#91;stage1&#93;.&#91;common_message_list&#93; AS TABLE&#40;
	&#91;common_message_id&#93; &#91;int&#93; IDENTITY&#40;1,1&#41; NOT NULL,
	&#91;obj_id&#93; &#91;varchar&#93;&#40;32&#41; NULL,
	&#91;obj_type&#93; &#91;varchar&#93;&#40;32&#41; NULL,
	&#91;status_code&#93; &#91;char&#93;&#40;1&#41; NOT NULL DEFAULT &#40;'S'&#41;,
	&#91;msg_source&#93; &#91;varchar&#93;&#40;32&#41; NULL,
	&#91;msg_level&#93; &#91;varchar&#93;&#40;16&#41; NOT NULL DEFAULT &#40;'Informational'&#41;,
	&#91;msg_text&#93; &#91;varchar&#93;&#40;128&#41; NOT NULL,
	&#91;msg_parm&#93; &#91;varchar&#93;&#40;128&#41; NULL,
	CHECK &#40;&#40;&#91;msg_level&#93;='Abort' OR &#91;msg_level&#93;='Error' OR &#91;msg_level&#93;='Warning' OR &#91;msg_level&#93;='Validation' OR &#91;msg_level&#93;='Informational'&#41;&#41;,
	CHECK &#40;&#40;&#91;status_code&#93;='S' OR &#91;status_code&#93;='F'&#41;&#41;
&#41;
GO

John Palmer July 02, 2012 15:09

Sorry for the delay, this is definitely a bug.

I've logged it under the bug tracking code SOC-4068. I'll let you know as soon as I find out when it's expected to be fixed.

Sorry for the inconvenience.

Chris Auckland July 09, 2012 15:48

0
Thanks for the update Chris...

I'll watch for your resolution.

-John

John Palmer July 10, 2012 16:20

0

Add comment

Please sign in to leave a comment.

How can we help you today?

UDT Table Type requires repeated commit

Comments

Add comment