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

Implement SELECT ... OFFSET ... FETCH ...

Details

    Description

      The 2008 SQL standard introduced the following syntax:

      OFFSET start { ROW | ROWS }
      		 
      FETCH { FIRST | NEXT } [ count ] { ROW | ROWS } { ONLY | WITH TIES }

      See https://www.postgresql.org/docs/13/sql-select.html#SQL-LIMIT for a description.

      This would also allow does not include the non-standard LIMIT WITH TIES.

      Attachments

        Issue Links

          causes

          Bug - A problem which impairs or prevents the functions of the product. MDEV-29376 The return rows has error when a statement has group by, order by and fetch with ties

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

          New Feature - A new feature of the product, which has yet to be developed. MCOL-4645 Support basic SELECT..OFFSET..FETCH syntax introduced by SQL2008

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-25430 ROW | ROWS should be a required keyword after OFFSET start

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-25481 Memory leak in Cached_item_str::Cached_item_str upon query WITH TIES involving a blob

          • Blocker - Blocks development and/or testing work, production could not run.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-21286 bison warnings on ubuntu 20.04 on deprecated directive in sql_yacc.yy

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-25441 WITH TIES is not respected with SQL_BUFFER_RESULT and constant in ORDER BY

          • Major - Major loss of function.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            cvicentiu Vicențiu Ciorbaru added a comment -

            The patch is pushed for review here:
            https://github.com/MariaDB/server/compare/30dc4287ec3d46bae7593f56383b9f3738e3c4e6..cf2e494bbb9b07f5847fd64cbb9029045c39236f

            bb-10.6-refactor-limit

            cvicentiu Vicențiu Ciorbaru added a comment - The patch is pushed for review here: https://github.com/MariaDB/server/compare/30dc4287ec3d46bae7593f56383b9f3738e3c4e6..cf2e494bbb9b07f5847fd64cbb9029045c39236f bb-10.6-refactor-limit
            greenman Ian Gilfillan added a comment -

            This doesn't include LIMIT WITH TIES, as implemented by PostgreSQL, and which would probably be more familiar for MariaDB users to use.

            greenman Ian Gilfillan added a comment - This doesn't include LIMIT WITH TIES, as implemented by PostgreSQL, and which would probably be more familiar for MariaDB users to use.
            cvicentiu Vicențiu Ciorbaru added a comment -

            greenman I'll push a follow-up fix, this shouldn't be too hard. It'll make it into 10.6.1

            cvicentiu Vicențiu Ciorbaru added a comment - greenman I'll push a follow-up fix, this shouldn't be too hard. It'll make it into 10.6.1
            serg Sergei Golubchik added a comment -

            I'd rather suggest to stay within the sql standard syntax here.

            serg Sergei Golubchik added a comment - I'd rather suggest to stay within the sql standard syntax here.
            ralf.gebhardt Ralf Gebhardt added a comment -

            I agree with Sergei. It should not be difficult to switch to the new Syntax used by the standard if WITH TIES is needed

            ralf.gebhardt Ralf Gebhardt added a comment - I agree with Sergei. It should not be difficult to switch to the new Syntax used by the standard if WITH TIES is needed

            People

              cvicentiu Vicențiu Ciorbaru
              greenman Ian Gilfillan
              Votes:
              0 Vote for this issue
              Watchers:
              6 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.