[MCOL-5266] MariaDB 10.5 Columnstore: a generated SQL statement for a Yellowfin view leads to an error when multiple COUNT(DISTINCT)s are present Created: 2022-10-18  Updated: 2022-10-25

Status: Open
Project: MariaDB ColumnStore
Component/s: None
Affects Version/s: 5.5.2
Fix Version/s: Icebox

Type: Bug Priority: Major
Reporter: andreas eschbacher Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: None
Environment:

Mariadb 10.5.10 RHEL 8.2 SC 5.5.2

Attachments: File EBI-736_simple_bug_exposal.sql    

 Description   

Scenario:

YF view reads a DB-view (see EBI-733) that does a SELECT from a single table
on user-hidden IDs, COUNT(DISTINCT)s are created for getting the metrics "Anzahl ..." (via a "simple" computed field using COUNTDISTINCT(...)) in the YF view (not "FREEHAND SQL")
YF produces a SQL statement for the view-definition that countains multiple COUNT(DISTINCT...) statements
an error message pops up due to a MariaDB error
A single count(distinct) does not lead to an error.
Commenting out the (some; which?) columns in the GROUP BY removes the error.

 Comments   
Comment by andreas eschbacher [ 2022-10-18 ]

It's a COLUMNSTORE problem with MariaDB 10.5 (EBI04). The generated SQL works with InnoDB, but not with Columnstore on MariaDB 10.5.
MariaDB 10.6.: works!!!!

Using 10.6 is not an option, our ETL hangs with 10.6 on every Machine.

Generated at Thu Feb 08 02:56:36 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.