[SYNCOPE-1664] JSONB: Inconsistent search query when is used a pull correlation rule

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.1.10, 3.0.0-M0
• Fix Version/s: 2.1.11, 3.0.0-M0
• Component/s: core
• Labels: jsonb postgresql
• Assignee: Francesco Chicchiriccò
• Reporter: Samuel Garofalo
• Created: 24/Feb/22 09:32
• Updated: 18/Mar/22 07:37
• Resolved: 25/Feb/22 08:51

Description

1. Create an AnyObject with at least 2 plain attributes, the name of the AnyObject must be the concatenation of the values of the two attributes separated by a character like '_'. In the second AnyObject the value of the first attribute must contains the value of the first attribute of the first AnyObject.
2. Create a pull correlation rule using 2 plain attributes for the created AnyObject and assign that on a resource.
3. Pull the AnyObjects from the choosen resource.
4. Having a pull correlation rule the created query use a like_regex and during the pull of the first AnyObject both the AnyObjects will match the query generating a remediation.

Issue Links

• links to: GitHub Pull Request #317
• links to: GitHub Pull Request #318