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

Server doesn't account for engines that supports OFFSET on their own.

    XMLWordPrintable

    Details

      Description

      It comes out that server doesn't honors group by handlers that supports OFFSET on their own and the server code in select_send::send_data tries to reapply OFFSET to the set returned by the handler[1]

      select i from t1 group by i limit 10,20; # Start from offset 10

      There is only engine that supports both group by handler and internal sorting ATM, so one could reproduce this only with columnstore engine built of:

      • develop branch columnstore fork of the server's code
      • develop branch columnstore engine

      1. https://hastebin.com/afepesalez.cs

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              sanja Oleksandr Byelkin
              Reporter:
              drrtuy Roman
              Votes:
              0 Vote for this issue
              Watchers:
              7 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: