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

      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:
                7 years, 51 weeks, 6 days ago

                Packages

                Version Package
                6.0.X EE
                --Sprint 12/11
                6.1.0 CE RC1