[MCOL-3519] group by not working as expected - returns varying results with each query run Created: 2019-09-27 Updated: 2023-03-06 Resolved: 2023-03-06 |
|
| Status: | Closed |
| Project: | MariaDB ColumnStore |
| Component/s: | N/A |
| Affects Version/s: | 1.2.5 |
| Fix Version/s: | Icebox |
| Type: | Bug | Priority: | Major |
| Reporter: | David Hill (Inactive) | Assignee: | Unassigned |
| Resolution: | Won't Do | Votes: | 1 |
| Labels: | None | ||
| Environment: |
2um 3pm system |
||
| Description |
|
Customer reported issue when running a specific query and it was returning different results sets. Supported was able to reproduce the issue on 1.2.5 2um 2pm root install system. From customer issue: When running a query with a group by outside of a temporary table that also used a group by, unexpected results are returned. It does not appear that the outside group by is working correctly and actually returns varying results with each run. The query is as follows: For info will be added to make it confidential for the customer data. |
| Comments |
| Comment by Todd Stoffel (Inactive) [ 2023-03-06 ] |
|
This ticket was opened prior to convergence with the server. It may have been rendered obsolete. If this issue still exists in a modern version, please open a new request. |