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

              hong.zhao Hong Zhao (Inactive)
              arthur.chen Arthur Chen
              Kiyoshi Lee Kiyoshi Lee
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:
                4 years, 24 weeks, 5 days 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