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

Lead Window Function Returns Incorrect Results

    XMLWordPrintable

    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

            People

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

              Dates

              Created:
              Updated:
              Resolved:

                Git Integration