Details
-
Task
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
None
Description
It comes out that server doesn't honors group by handlers that supports OFFSET on their own and the server code in select_send::send_data tries to reapply OFFSET to the set returned by the handler[1]
select i from t1 group by i limit 10,20; # Start from offset 10
There is only engine that supports both group by handler and internal sorting ATM, so one could reproduce this only with columnstore engine built of:
- develop branch columnstore fork of the server's code
- develop branch columnstore engine
Attachments
Issue Links
- is part of
-
MCOL-1052 Implement GROUP BY pushdown support
-
- Closed
-
- relates to
-
MCOL-3903 Performance regression in INSERT..SELECT
-
- Closed
-
-
-
- Closed
-
Activity
| Assignee | Sergei Golubchik [ serg ] |
| Fix Version/s | 10.2 [ 14601 ] |
| Priority | Minor [ 4 ] | Major [ 3 ] |
| Fix Version/s | 10.3 [ 22126 ] | |
| Fix Version/s | 10.2 [ 14601 ] |
| Labels | RM_104_CS_mandatory |
| Fix Version/s | 10.4 [ 22408 ] | |
| Fix Version/s | 10.3 [ 22126 ] |
| Priority | Major [ 3 ] | Critical [ 2 ] |
| Epic Link | PT-81 [ 68562 ] |
| Labels | RM_104_CS_mandatory |
| Description |
It comes out that server doesn't honors group by handlers that supports OFFSET on their own and the server code in select_send::send_data tries to reapply OFFSET to the set returned by the handler[1]
There is only engine that supports both group by handler and internal sorting ATM, so one could reproduce this only with columnstore engine built of: - develop branch columnstore fork of the server's code - develop branch columnstore engine 1. https://hastebin.com/afepesalez.cs |
It comes out that server doesn't honors group by handlers that supports OFFSET on their own and the server code in select_send::send_data tries to reapply OFFSET to the set returned by the handler[1]
select i from t1 group by i limit 10,20; # Start from offset 10 There is only engine that supports both group by handler and internal sorting ATM, so one could reproduce this only with columnstore engine built of: - develop branch columnstore fork of the server's code - develop branch columnstore engine 1. https://hastebin.com/afepesalez.cs |
| Assignee | Sergei Golubchik [ serg ] | Oleksandr Byelkin [ sanja ] |
| Status | Open [ 1 ] | In Progress [ 3 ] |
| Status | In Progress [ 3 ] | Stalled [ 10000 ] |
| Link |
This issue relates to |
| Epic Link | PT-81 [ 68562 ] |
| NRE Projects | RM_104_CS_mandatory |
| Issue Type | Task [ 3 ] | Bug [ 1 ] |
| Fix Version/s | 10.5 [ 23123 ] | |
| Fix Version/s | 10.4 [ 22408 ] |
| Status | Stalled [ 10000 ] | In Progress [ 3 ] |
| Issue Type | Bug [ 1 ] | Task [ 3 ] |
| Component/s | Optimizer [ 10200 ] | |
| Fix Version/s | 10.5.0 [ 23709 ] | |
| Fix Version/s | 10.5 [ 23123 ] | |
| Resolution | Fixed [ 1 ] | |
| Status | In Progress [ 3 ] | Closed [ 6 ] |
| Workflow | MariaDB v3 [ 87559 ] | MariaDB v4 [ 133565 ] |