Details
-
Bug
-
Status: Confirmed (View Workflow)
-
Major
-
Resolution: Unresolved
-
22.08.2, 6.4.2, 23.02.3
-
None
-
None
-
MariaDB 10.6.9 CS 6.4.3 RHEL 8
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.
InnoDB works flawlessly.
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.