[MCOL-5671] WITH TIES doesn't work with ColumnStore - Jira

XML

Word

Printable

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.

is duplicated by

MCOL-4646 Support SELECT..OFFSET..FETCH..WITH TIES syntax introduced by SQL2008

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