Using TEXT column for extraSettings cause problems in Oracle when using the column in string comparation

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 6.1.0 CE RC1
• Fix Version/s: --Sprint 12/11, 6.1.0 CE RC1, 6.0.X EE
• Component/s: DM, DM > Document Library Display, Legacy > Control Panel menu
• Labels: None
• Branch Version/s:
  6.0.x
• Backported to Branch:
  Committed
• Similar Issues: Show 5 results ; ;

  LPS-29671	Kaleo web + oracle = Fail when upgrade
  LPS-174	Oracle 10g throws "Invalid column name" exception when running 5.2.0 upgrade script
  LPS-12222	MySQLSyntaxErrorException: Unknown column '' in 'field list'
  LPS-9388	service fails in a plugin when primitive wrappers are used as column type
  LPS-12198	CLONE -service fails in a plugin when primitive wrappers are used as column type

Using TEXT column for extraSettings cause problems in Oracle when using the column in string comparation.

For example: using this query

SELECT
				COUNT(DISTINCT DLFileEntry.fileEntryId) AS COUNT_VALUE
			FROM
				DLFileEntry, DLFileVersion
			WHERE
				(CAST_TEXT(DLFileEntry.extraSettings) != '') OR
				(
					(DLFileVersion.fileEntryId = DLFileEntry.fileEntryId) AND (CAST_TEXT(DLFileVersion.extraSettings) != '')
				)

will cause an error in Oracle because we are comparing CLOB with String

[Michael Saechang]

Committed on:
6.1.x Revision: 94396.
6.0.x Revision: 94435.