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

Can not execute query in "IN" statement for OracleDB

    Details

      Description

      Description
      Setting over 1000 values "IN" statement can not execute query with OracleDB.

      Steps to reproduce

      1. LiferayDXP install and run
      2. make new site.
      3. make 1001 page in a make above site. (DummyFactory)
      4. [Control Panel] -> [Site] -> Choose site created in step 2.

      Expected Results
      Output Internal Server Error.
      (com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.SQLGrammarException: could not execute query)

      Actual Results
      View first page in selected site.

      Reproduced in
      7.0.x(e71aaa99da5893c3bafb97c399c0135230d4c791)

      Cannot test in
      master(b9cd8c2fca5584a4bee6016689be1ceb038dee22) (DummyFactory not working)

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                hong.zhao Hong Zhao
                Reporter:
                arthur.chen Arthur Chen
                Participants of an Issue:
                Recent user:
                Csaba Turcsan
              • Votes:
                0 Vote for this issue
                Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Days since last comment:
                  1 year, 18 weeks ago

                  Packages

                  Version Package
                  7.0.0 DXP FP52
                  7.0.0 DXP SP9
                  7.0.X
                  7.1.0 Beta 3
                  7.1.10 DXP FP1
                  7.1.1 CE GA2
                  7.1.10.1 SP1
                  7.1.X
                  Master