0049244: Business Partner Search Key accepts duplicate values if it has trailing spaces

Description

If the search key field in Business Partner window contains trailing spaces (before or at the end), then the unique key constraint does not validate duplicate values.

Steps To Reproduce

1. Create one business partner with search key "Test".
2. Create another business partner with search key "Test ".
3. Notice that unique key constraint does not prevent saving the record.

Tags

No tags attached.

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

Notes
(0137071) shankarb (reporter) 2022-05-09 10:59	Changing the severity because of customer escalation

(0137611) aferraz (manager) 2022-05-23 13:33	Unique constraint is working fine as "Test" and "Test " are different values. In case a unique constraint validation wants to be implemented doing a trim of the entered value, a custom EntityPersistenceEventObserver can be defined: http://wiki.openbravo.com/wiki/How_to_implement_a_business_event_handler [^]

Issue History
Date Modified	Username	Field	Change
2022-05-06 09:27	shankarb	New Issue
2022-05-06 09:27	shankarb	Assigned To	=> Triage Omni OMS
2022-05-06 09:27	shankarb	Modules	=> Core
2022-05-06 09:27	shankarb	Triggers an Emergency Pack	=> No
2022-05-09 10:59	shankarb	Note Added: 0137071
2022-05-09 10:59	shankarb	Severity	minor => major
2022-05-23 13:33	aferraz	Review Assigned To	=> aferraz
2022-05-23 13:33	aferraz	Note Added: 0137611
2022-05-23 13:33	aferraz	Status	new => closed
2022-05-23 13:33	aferraz	Resolution	open => no change required