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

Closed

Type:	Bug
ID:	777379
Opened:	1/24/2013 5:57:20 AM
Access Restriction:	Public

Workaround(s)

view

User(s) can reproduce this bug

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 (expand)

English

SQL Server 2012 SP1

Data Quality Services

Windows 7 Enterprise

US English

In the DQS client, open the sample DQS Data kb, pick Domain management, select the Country/Region domain, go to the domain rules tab, create a new domain rule
Country/Region Value does not contain
type [ in the textbox next to the rule
Click the 'run the selected domain rule on test data' icon and type some test values with and without a [ symbol in it

all strings meet the rule

only strings without [ meet the rules

X64

File Name	Submitted By	Submitted On	File Size
DQSValidationFailure.png	SQLWaldorf	1/24/2013	13 KB

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

Microsoft