Dr. Sum 5.0: Performing Search in In-memory with Multiple Conditions Enclosed in NOT Operator Yields Invalid Results

Last Updated: 11/Sep/2018

Affected Products:

• All models of Dr. Sum Ver. 5.0 (Build=5.0.00.0000 to 5.0.00.0030)

Summary:

Performing search on any objects moved into in-memory may return invalid results. This occurs when all of following conditions are met:

1. Multiple conditions connected by AND is enclosed with NOT operator
   E.g. NOT(<condition_A> AND <condition_B>).
2. Target values of extract condition include NULL in above condition.

Note: Extract condition described in #1 cannot be specified in Datalizer and Motionboard. 

It ends up with either of followings:

• Records are included in extract target though they don't meet the search condition.
• Records are not included in extract target though they meet the search condition.

Workaround: 

Please do either of following workarounds. 

• Use tables and views without moving them into in-memory.
• Change search condition as follows:  NOT (condition_A) OR NOT(condition_B)

Solution:

We've released a patch (5.0.00.0033) to address the issue. Please submit a request to WingArc1st Support if you need to apply the patch.