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

SQLChecker fails to parse valid SQL on Hypersonic

    Details

      Description

      Only for HSQLDB.
      PACL Security Manager SQLChecker fails to parse valid SQL, for example:

      select limit ? ? someTable.someField from someTable

      because net.sf.jsqlparser.parser.JSqlParser cannot parse "select limit" statement correctly and throws an exception on line 64 of com.liferay.portal.security.pacl.checker.SQLChecker, this results in false return of SQLChecker.

        Attachments

          Issue Links

            Activity

              People

              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Days since last comment:
                  6 years, 14 weeks, 6 days ago

                  Packages

                  Version Package
                  6.1.2 CE GA3
                  6.1.30 EE GA3
                  6.1.X EE
                  6.2.0 CE B2