[MCOL-3738] COUNT DISTINCT should accept multiple columns Created: 2020-01-21  Updated: 2021-09-20  Resolved: 2021-06-29

Status: Closed
Project: MariaDB ColumnStore
Component/s: ExeMgr, PrimProc
Affects Version/s: 1.4.2
Fix Version/s: 6.1.1

Type: Bug Priority: Blocker
Reporter: David Hall (Inactive) Assignee: Daniel Lee (Inactive)
Resolution: Fixed Votes: 2
Labels: Compatibility

Issue Links:
Relates
relates to MCOL-3662 count with distinct and 2 columns fai... Closed
relates to MCOL-3822 CLONE - count with distinct and 2 col... Closed
relates to MCOL-3857 CLONE - count with distinct and 2 col... Closed
Epic Link: Tech debt
Sprint: 2021-7, 2021-8, 2021-9

 Description   

MariaDB Server allows COUNT(DISTINCT col1,col2...). Columnstore does not support more than one column for COUNT DISTINCT.

As part of convergence, we need to have COUNT DISTINCT handle multiple columns.



 Comments   
Comment by Daniel Lee (Inactive) [ 2021-06-29 ]

Build verified: 6.1.1 ( Drone #2669 )

Testing on 1gb dbt3 lineitem table, 1 to 3 columns.

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