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

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

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

          is part of

          New Feature - A new feature of the product, which has yet to be developed. MCOL-1052 Implement GROUP BY pushdown support

          • Major - Major loss of function.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. MCOL-3903 Performance regression in INSERT..SELECT

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Task - A task that needs to be done. MDEV-18553 Make LIMIT/OFFSET processing uniform

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Activity

            Transition Time In Source Status Execution Times
            Oleksandr Byelkin made transition -
            Open In Progress
            		222d 3h 45m 1
            Oleksandr Byelkin made transition -
            In Progress Stalled
            		7d 23h 48m 1
            Oleksandr Byelkin made transition -
            Stalled In Progress
            		252d 21h 50m 1
            Oleksandr Byelkin made transition -
            In Progress Closed
            		17d 22h 26m 1

            People

              sanja Oleksandr Byelkin
              drrtuy Roman
              Votes:
              0 Vote for this issue
              Watchers:
              7 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.