EBI-697_CS_vs_InnoDB_identical_timestamps_different_results_on_views.sql
[MCOL-5238] MariaDB Columnstore: incorrect query results on views grouping identical datetimes via TIMESTAMP keyword Created: 2022-09-29 Updated: 2024-01-12 |
|
| Status: | Confirmed |
| Project: | MariaDB ColumnStore |
| Component/s: | None |
| Affects Version/s: | 22.08.2, 6.4.2, 23.02.3 |
| Fix Version/s: | Icebox |
| Type: | Bug | Priority: | Major |
| Reporter: | andreas eschbacher | Assignee: | Unassigned |
| Resolution: | Unresolved | Votes: | 1 |
| Labels: | None | ||
| Environment: |
MariaDB 10.6.9 CS 6.4.3 RHEL 8 |
||
| Attachments: |
EBI-697_CS_vs_InnoDB_identical_timestamps_different_results_on_views.sql
|
| Description |
|
Special Analyzer/Mondrian-generated queries using datetime column (containing only identical values) and grouping on the datetimes work on Columnstore tables, but not on views when they include a CASE WHEN for null replacement in the view definition. The problem was found out after dragging "Beladungszeit" (having only identical values) into an Analyzer report resulting in emptying out the whole report ("keine Berichtsdaten"). Example-File attached. |