[MCOL-1697] UDAF with DISTINCT Created: 2018-09-06  Updated: 2023-07-02  Resolved: 2023-07-02

Status: Closed
Project: MariaDB ColumnStore
Component/s: N/A
Affects Version/s: 1.2
Fix Version/s: Icebox

Type: New Feature Priority: Minor
Reporter: David Hall (Inactive) Assignee: Todd Stoffel (Inactive)
Resolution: Won't Do Votes: 0
Labels: None

Issue Links:
Relates
relates to MCOL-1698 Add Distinct capability to specific U... Closed
Epic Link: ColumnStore Compatibility Improvements

 Description   

Currently, the DISTINCT keyword only works with COUNT, SUM, AVG, MIN, and MAX. With MIN and MAX, it means nothing. Internally, the difference in processing, both in the Server portion and the Columnstore Portion of processing is completely separate from non-DISTINCT.

This ticket is to add DISTINCT capabilities to the Columnstore code, allowing specific UDAF to be created as DISTINCT, even though the parser won't pass the DISTINCT keyword.

A separate ticket is created for UDAnF Window Functions



 Comments   
Comment by Todd Stoffel (Inactive) [ 2023-07-02 ]

The "create date" on this ticket is pre-convergence with MariaDB server. If the issue still exists in a modern version of the engine/plugin please submit a new ticket.

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