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

ORA-01795: maximum number of expressions in a list is 1000 with "IN" statement

    Details

      Description

      Steps to reproduce:

      1. Set up 7.0 with latest fixpack and with DB Oracle 12 r2.
      2. Go to server admin and run the following script:

       

      import com.liferay.portal.kernel.service.UserLocalServiceUtil
      import java.util.stream.Collectors 
       import java.util.stream.LongStream
      simulateSQLOracleError()
      protected void simulateSQLOracleError() {
      List<Long> range = LongStream.rangeClosed(1000, 2100) 
       .boxed().collect(Collectors.toList())
      long[] groupIds = range.stream().toArray()
      try { 
       UserLocalServiceUtil.searchCounts( 
       20115, 1, groupIds) 
       } 
       catch (Exception e) { 
       out.println(e.printStackTrace(out))
       }
       }
      

       

      Expected behavior: API calls that use "IN" on DB side are running correctly.
      Actual behavior: ORA-01795: maximum number of expressions in a list is 1000 is thrown.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              summer.zhang Summer Zhang
              Reporter:
              istvan.dezsi Istvan Dezsi
              Participants of an Issue:
              Recent user:
              Yunlin "Steven" Sun
              Engineering Assignee:
              Istvan Dezsi
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Days since last comment:
                25 weeks, 5 days ago

                  Packages

                  Version Package
                  7.0.0 DXP FP97
                  7.0.X
                  7.1.10 DXP FP20
                  7.1.10.5 SP5
                  7.1.X
                  7.2.X
                  7.3.X
                  7.3.10 DXP FP1
                  7.3.10.1 DXP SP1
                  7.3.6 CE GA7
                  Master