Home Dashboard Directory Help
Search

MDS 2012, assign ~NULL~ to a column of only 2 characters by Todd C


Status: 

Closed


3
0
Sign in
to vote
Type: Bug
ID: 786120
Opened: 5/2/2013 9:00:25 AM
Access Restriction: Public
1
Workaround(s)
view
1
User(s) can reproduce this bug

Description

MDS 2008 R2 had no concept of a NULL value. They were actually empty strings.
SQL 2012 MDS allows null, and to ASSIGN a NULL value to an attribute, you actually pass in the value of " ~NULL~ ". This is from Microsoft's own documentation.

But what if the column/attribute you are trying to assign the NULL value is only 2 characters?
Result: ERROR
Details
Sign in to post a comment.
Posted by Microsoft on 6/25/2013 at 10:41 AM
Hello Todd. We’ve looked into this item. While it will not be addressed in the current release cycle, we have added it to a list for consideration for the next. Thank you for the feedback. We will keep track of the suggestion. In the meantime, we hope that difining you state ID or other variables as three characters. This will consume a few extra bits of drive space, but should unblock you until we can work this into a future release.

-Walter A Jokiel, Program Manager, SQL Server (wajokiel@microsoft.com)
Sign in to post a workaround.
Posted by Microsoft on 6/25/2013 at 10:42 AM
Define variables as 3+ characters.