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

As a developer I would like an alternative execution path in Dynamic queries for negative start bounds that does not fail on DB2.

    Details

      Description

      DB2 does not contain LIMIT syntax found in other databases, instead it uses FETCH FIRST, which has stipulates on its arguments to prevent them from being non-zero. In dynamic query cases this occurs when both bounds of the query are negative - in these cases we should not hit database at all (we already know there will be no results)

        Attachments

          Activity

            People

            Assignee:
            beck.liu Beck Liu
            Reporter:
            william.newbury William Newbury
            Participants of an Issue:
            Recent user:
            Brian Wulbern
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:
              Days since last comment:
              5 years, 26 weeks, 4 days ago

                Packages

                Version Package
                7.0.0 M7