Chat portlet leaves empty database entries in Oracle database

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 5.1 EE SP2 (5.1.5), 5.2 EE (5.2.4)
• Fix Version/s: 5.1 EE SP3 (5.1.6), 5.2 EE SP1 (5.2.5)
• Component/s: Chat, Performance
• Labels: None
• Environment: Oracle database

The Chat portlet leaves empty database entries in Oracle database because the search for empty content searches for an empty string. However, some databases like Oracle adds the entry with a null content instead. As a result, the empty content are not deleted and reduces performance.