Custom SQL function for Sybase assumes all values passed in are varchar

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 5.1 EE SP4 (5.1.7), 5.2 EE SP2 (5.2.6)
• Fix Version/s: 5.1 EE SP5 (5.1.8), 5.2 EE SP3 (5.2.7)
• Component/s: Environments > Databases
• Labels:
  • 5.2_release_notes
• Environment: All

The custom SQL function for Sybase in portal.properties assumes that all values passed in are of type varchar. In certain circumstances, such as when the Announcement portlet is in use, this is not the case. The SQL function needs to convert the passed in value to a varchar before the comparison is made.