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
    • Similar Issues:
      Show 5 results 

      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

        Activity

        Miguel Pastor created issue -
        Miguel Pastor made changes -
        Field Original Value New Value
        Status Open [ 1 ] In Progress [ 3 ]
        Miguel Pastor made changes -
        Status In Progress [ 3 ] In Review [ 10006 ]
        Git Pull Request https://github.com/juliocamarero/liferay-portal/pull/201
        Assignee Miguel Pastor [ miguel.pastor ] Julio Camarero [ julio.camarero ]
        Julio Camarero made changes -
        Status In Review [ 10006 ] In Review [ 10006 ]
        Git Pull Request https://github.com/juliocamarero/liferay-portal/pull/201 https://github.com/brianchandotcom/liferay-portal/pull/2795
        Assignee Julio Camarero [ julio.camarero ] Brian Chan [ brian.chan ]
        Peer Reviewer Name Julio Camarero
        Peer Review Passed [ 10235 ]
        Review Type Peer Review [ 10233 ] Final Review [ 10310 ]
        Brian Chan made changes -
        Status In Review [ 10006 ] Resolved [ 5 ]
        Resolution Fixed [ 1 ]
        Brian Chan made changes -
        Fix Version/s 6.0.13 EE [ 10764 ]
        Backport Version/s 6.0.x [ 10151 ]
        Backport Committed Committed [ 10048 ]
        Michael Saechang made changes -
        Assignee Brian Chan [ brian.chan ] Michael Saechang [ michael.saechang ]
        Michael Saechang made changes -
        Status Resolved [ 5 ] Closed [ 6 ]
        QA Passed [ 10410 ] Cannot be tested [ 10411 ]
        Michael Saechang made changes -
        Resolution Fixed [ 1 ]
        Status Closed [ 6 ] Reopened [ 4 ]
        Michael Saechang made changes -
        Status Reopened [ 4 ] Closed [ 6 ]
        Resolution Fixed [ 1 ]
        Matthew Kong made changes -
        Link This issue relates LPE-5900 [ LPE-5900 ]
        Andrew Kim made changes -
        Workflow LPS Workflow [ 284382 ] Copy of LPS Workflow [ 428959 ]
        Andrew Kim made changes -
        Workflow Copy of LPS Workflow [ 428959 ] LPS Workflow [ 460568 ]
        Edward Gonzales made changes -
        Component/s DM [ 14491 ]
        Andrew Kim made changes -
        Workflow LPS Workflow [ 460568 ] Copy 2 of LPS Workflow [ 492937 ]
        Andrew Kim made changes -
        Workflow Copy 2 of LPS Workflow [ 492937 ] LPS Workflow [ 524823 ]
        Gergely Mathe made changes -
        Link This issue relates LPP-6711 [ LPP-6711 ]
        Randy Zhu made changes -
        Workflow LPS Workflow [ 524823 ] PUBLIC - LPS Generic Workflow [ 576735 ]
        Randy Zhu made changes -
        Workflow PUBLIC - LPS Generic Workflow [ 576735 ] Copy of PUBLIC - LPS Generic Workflow [ 611044 ]
        Randy Zhu made changes -
        Workflow Copy of PUBLIC - LPS Generic Workflow [ 611044 ] PUBLIC - LPS Generic Workflow [ 642972 ]
        Randy Zhu made changes -
        Workflow PUBLIC - LPS Generic Workflow [ 642972 ] PUBLIC - LPS General Workflow [ 736302 ]
        Randy Zhu made changes -
        Workflow PUBLIC - LPS General Workflow [ 736302 ] PUBLIC - LPS Bugs Workflow [ 831650 ]

          People

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

            Dates

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

              Development

                Structure Helper Panel