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

          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.