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

              summer.zhang Summer Zhang
              istvan.dezsi Istvan Dezsi
              Kiyoshi Lee Kiyoshi Lee
              Istvan Dezsi Istvan Dezsi
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:
                2 years, 6 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.10 DXP FP1
                  7.3.10.1 DXP SP1
                  7.3.6 CE GA7
                  7.3.X
                  7.4.13 DXP GA1
                  Master