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

Backport the the usage of CAST_CLOB_TEXT for the order by clauses to ee-6.2.x

    Details

    • Fix Priority:
      3

      Description

      We should backport the following commits from the LPS-56674 Story:

      1ee4ae93b97dc91bcdff1b2967ea58d9edf8b526
      b9bc7f4205d45b2ce5d39eb4ebf296eeaf581788
      53cc89aad20f7d88da75009b1791b921d1dc4482
      637026435ff95167f3395c22ea07330d8ac169e8
      d1dcb9953c011d58501f29406a7a3ae767840315
      4a4485ef7e4fac31df8e3634589604cf937a70a8

      (Obviously the autogenerated commits should be done by manually rerunning service builder.)

      This is needed to get the pseudo function CAST_CLOB_TEXT applied to CLOB columns used in ORDER BY clauses of finder queries, in order to avoid getting ORA-00932 and ORA-00920 errors when using Oracle database.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                raven.song Raven Song
                Reporter:
                gergely.mathe Gergely Mathe (Inactive)
                Participants of an Issue:
                Recent user:
                Raven Song
              • Votes:
                0 Vote for this issue
                Watchers:
                0 Start watching this issue

                Dates

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

                  Packages

                  Version Package