Details

    • Branch Version/s:
      6.0.x, 5.2.x, 5.1.x
    • Backported to Branch:
      Committed
    • Similar Issues:
      Show 5 results 

      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

          Activity

          Hide
          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 added a comment - One solution is to replace column aliases with the real column name in the OVER(ORDER BY).
          Hide
          Michael Hashimoto added a comment -

          Backported to 6.0.6 at revision 71597.

          Show
          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:
                4 years, 32 weeks ago

                Development

                  Subcomponents

                    Structure Helper Panel