Home Dashboard Directory Help
Search

Data Quality Services (DQS) domain rule validation ignores [ in does not contain test by SQLWaldorf


Status: 

Closed


1
0
Sign in
to vote
Type: Bug
ID: 777379
Opened: 1/24/2013 5:57:20 AM
Access Restriction: Public
0
Workaround(s)
view
0
User(s) can reproduce this bug

Description

When I create a DQS Domain rule 'Value does not contain ' with as value [, and I test the rule, the test always succeeds, even with [ values in the test string, even if the test string is nothing but the [.
Details
Sign in to post a comment.
Posted by Microsoft on 4/12/2013 at 10:39 AM
We're closing this issue as "Won't Fix" as we do not plan to address it for SQL Server 2012 DQS. We will keep the feedback on file for future releases of DQS.
Posted by Microsoft on 3/1/2013 at 2:48 PM
Hi SQLWaldorf,

Thanks for the feedback. We apologize for the delay in responding.

While we’re investigating the problem you’ve reported, can you please test a potential workaround? You should be able to achieve the desired functionality by using a domain rule with a Regular Expression rather than a “Does Not Contain” rule. A Regular Expression that may provide the functionality you need is \A[^\[]*\z.

If you could test this and let us know if it unblocks you we would appreciate it greatly. Thanks in advance!

DQS Team
Sign in to post a workaround.
File Name Submitted By Submitted On File Size  
DQSValidationFailure.png 1/24/2013 13 KB