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

WITH TIES doesn't work with ColumnStore

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Duplicate
    • 23.10.0
    • N/A
    • ExeMgr

    Description

      First, I'll show you that there are at least 5 identical rows with the lowest values for columns a and b:

      MariaDB [test]> SELECT a, b FROM example ORDER BY a, b LIMIT 5;
      +------+------+
      | a    | b    |
      +------+------+
      |    1 |    2 |
      |    1 |    2 |
      |    1 |    2 |
      |    1 |    2 |
      |    1 |    2 |
      +------+------+
      5 rows in set (29.887 sec)
      

      Si, if I run the corresponding query with WITH TIES, I expect to see at least 5 rows:

      MariaDB [test]> SELECT a, b FROM example ORDER BY a, b FETCH FIRST 1 ROWS WITH TIES;
      +------+------+
      | a    | b    |
      +------+------+
      |    1 |    2 |
      +------+------+
      1 row in set (26.122 sec)
      

      It would seem that ColumnStore inores WITH TIES.

      CS should support it or, at least, issue an error.

      Attachments

        Issue Links

          Activity

            drrtuy Roman added a comment -

            Right,
            We discussed this syntax with Vicentiu when this syntax was implemented in MDB itself but at that point postponed the syntax for later time.
            JFYI this issue is one of those in the shortlist for the next dev period.

            drrtuy Roman added a comment - Right, We discussed this syntax with Vicentiu when this syntax was implemented in MDB itself but at that point postponed the syntax for later time. JFYI this issue is one of those in the shortlist for the next dev period.
            drrtuy Roman added a comment - - edited

            We will take a look at the linked issue in the next sprint.

            drrtuy Roman added a comment - - edited We will take a look at the linked issue in the next sprint.

            People

              Unassigned Unassigned
              f_razzoli Federico Razzoli
              Votes:
              0 Vote for this issue
              Watchers:
              2 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.