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 Ángel Pastor Olivar created issue -
        Miguel Ángel Pastor Olivar made changes -
        Field Original Value New Value
        Status Open [ 1 ] In Progress [ 3 ]
        Miguel Ángel Pastor Olivar 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 ]
        Hide
        Michael Saechang added a comment - - edited

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

        Show
        Michael Saechang added a comment - - edited Committed on: 6.1.x Revision: 94396. 6.0.x Revision: 94435.
        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 ]
        Transition Time In Source Status Execution Times Last Executer Last Execution Date
        Open Open In Progress In Progress
        1h 59m 1 Miguel Ángel Pastor Olivar 29/Nov/11 1:40 AM
        In Progress In Progress In Review In Review
        1m 54s 1 Miguel Ángel Pastor Olivar 29/Nov/11 1:42 AM
        In Review In Review In Review In Review
        43m 10s 1 Julio Camarero 29/Nov/11 2:26 AM
        In Review In Review Resolved Resolved
        8h 18m 1 Brian Chan 29/Nov/11 10:44 AM
        Resolved Resolved Closed Closed
        23h 26m 1 Michael Saechang 30/Nov/11 10:11 AM
        Closed Closed Reopened Reopened
        8s 1 Michael Saechang 30/Nov/11 10:11 AM
        Reopened Reopened Closed Closed
        15s 1 Michael Saechang 30/Nov/11 10:11 AM

          People

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

            Dates

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

              Development

                Structure Helper Panel