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

Fix pagination in Microsoft SQL Server when using alias columns

        Details

        • Branch Version/s:
          6.0.x, 5.2.x, 5.1.x
        • Backported to Branch:
          Committed

          Description

          In SQL Server 2008, even though ORDER BY recognizes column aliases, OVER(ORDER BY) does not. As a result of LPS-9903, pagination does not work if the ORDER BY uses column aliases.

            Issue Links

            is duplicated by

            Bug - A problem which impairs or prevents the functions of the product. LPS-14538 Reindexing functionality for users doesnt work properly

            • Closed
            is related to

            Bug - A problem which impairs or prevents the functions of the product. LPS-9903 SQLServer2008Dialect to enhance the pagination performance with row_number for SQL Server 2005 and 2008

            • Closed
            relates

            Regression Bug - Used by Liferay QA to indicate an issue discovered during regression testing LPS-15015 Fix pagination in Microsoft SQL Server for queries using UNION

            • Closed

              Activity

              Ascending order - Click to sort in descending order
              Hide
              Permalink
              minhchau.dang Minhchau Dang added a comment -

              One solution is to replace column aliases with the real column name in the OVER(ORDER BY).

              Show
              minhchau.dang Minhchau Dang added a comment - One solution is to replace column aliases with the real column name in the OVER(ORDER BY).
              Hide
              Permalink
              michael.hashimoto Michael Hashimoto added a comment -

              Backported to 6.0.6 at revision 71597.

              Show
              michael.hashimoto Michael Hashimoto added a comment - Backported to 6.0.6 at revision 71597.

                People

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

                  Dates

                  • Created:
                    Updated:
                    Resolved:
                    Days since last comment:
                    5 years, 35 weeks, 2 days ago

                    Development

                      Subcomponents