Uploaded image for project: 'PUBLIC - Liferay Portal Community Edition'
  1. PUBLIC - Liferay Portal Community Edition
  2. LPS-23523

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

    Details

    • Branch Version/s:
      6.0.x
    • Backported to Branch:
      Committed

      Description

      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

        Attachments

          Activity

            People

            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:
                Days since last comment:
                5 years, 47 weeks, 3 days ago