Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Duplicate
-
23.10.0
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
- is duplicated by
-
MCOL-4646 Support SELECT..OFFSET..FETCH..WITH TIES syntax introduced by SQL2008
-
- Confirmed
-
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.