Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-4646

Support SELECT..OFFSET..FETCH..WITH TIES syntax introduced by SQL2008

    XMLWordPrintable

Details

    • New Feature
    • Status: Confirmed (View Workflow)
    • Major
    • Resolution: Unresolved
    • 6.1.1
    • Icebox
    • ExeMgr, MDB Plugin
    • None

    Description

      SQL2008 introduces a new syntax that extends the functionality of SELECT..LIMIT..OFFSET.

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

      WITH TIES tells the engine to return additional rows that tie for the last place accordith with the ORDER BY clause used.

      Attachments

        Issue Links

          duplicates

          Bug - A problem which impairs or prevents the functions of the product. MCOL-5671 WITH TIES doesn't work with ColumnStore

          • Major - Major loss of function.
          • Closed
          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

          Activity

            People

              maxmether Max Mether
              drrtuy Roman
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

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