Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-11697

Lead Window Function Returns Incorrect Results

Details

    Description

      Lead Function is returning incorrect results for larger test table. Logs and example are attached. Expected results are as follows.

      +------+---------+
      		 
      | id   | next_id |
      		 
      +------+---------+
      		 
      |    1 |       2 |
      		 
      |    2 |       3 |
      		 
      |    3 |       4 |
      		 
      |    4 |       5 |
      		 
      |    5 |       6 |
      		 
      |    6 |       7 |
      		 
      |    7 |       8 |
      		 
      |    8 |       9 |
      		 
      |    9 |      10 |
      		 
      |   10 |      11 |
      		 
      +------+---------+

      Attachments

        Activity

          Ascending order - Click to sort in descending order
          absolutesantaja Shawn Weeks added a comment -

          Thank you I couldn't get the formatting to work.

          absolutesantaja Shawn Weeks added a comment - Thank you I couldn't get the formatting to work.
          elenst Elena Stepanova added a comment -

          Thanks for the report and test case.

          elenst Elena Stepanova added a comment - Thanks for the report and test case.
          cvicentiu Vicențiu Ciorbaru added a comment -

          Sergey, please check that this reproduces again as it seems to be a big table issue.

          cvicentiu Vicențiu Ciorbaru added a comment - Sergey, please check that this reproduces again as it seems to be a big table issue.
          cvicentiu Vicențiu Ciorbaru added a comment -

          This is fixed by the fix for MDEV-10092.

          cvicentiu Vicențiu Ciorbaru added a comment - This is fixed by the fix for MDEV-10092 .
          cvicentiu Vicențiu Ciorbaru added a comment -

          Test case added for the bug to catch regressions.
          https://github.com/mariadb/server/commit/88ddb1ea4e4c7ce4816026d9a64b3f8b1cc59072

          cvicentiu Vicențiu Ciorbaru added a comment - Test case added for the bug to catch regressions. https://github.com/mariadb/server/commit/88ddb1ea4e4c7ce4816026d9a64b3f8b1cc59072
          absolutesantaja Shawn Weeks added a comment -

          Checked it in the most recent 10.2.5 build it looks fine. Thanks

          absolutesantaja Shawn Weeks added a comment - Checked it in the most recent 10.2.5 build it looks fine. Thanks

          People

            cvicentiu Vicențiu Ciorbaru
            absolutesantaja Shawn Weeks
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.