[MCOL-1463] Columnstore provided udf median()/avg_mode() not working Created: 2018-06-08  Updated: 2018-06-08  Resolved: 2018-06-08

Status: Closed
Project: MariaDB ColumnStore
Component/s: ExeMgr
Affects Version/s: 1.1.4
Fix Version/s: 1.1.5

Type: Bug Priority: Major
Reporter: Dalu (Inactive) Assignee: David Hall (Inactive)
Resolution: Not a Bug Votes: 0
Labels: None
Environment:

Debian


Sprint: 2018-12

 Description   

Enabled median udf provided on article:
https://mariadb.com/kb/en/library/columnstore-user-defined-aggregate-and-window-functions/

But mostly 90% of the time that error appears when calling a query with median:

Error Code: 1815. Internal error: prep2PhasesAggregate: A UDAF function is called but there's no UDAFColumn

Query is kinda simple:

SELECT v1, median(v2) as a FROM testtable
group by v1;

 Comments   
Comment by David Hall (Inactive) [ 2018-06-08 ]

This has been fixed in 1.1.5.

1.1.4:
MariaDB [dhall]> SELECT v1, median(v2) as a FROM testtable group by v1;

ERROR 1815 (HY000): Internal error: prep2PhasesAggregate: A UDAF function is called but there's no UDAFColumn
MariaDB [dhall]>

1.1.5:
MariaDB [dhall]> SELECT v1, median(v2) as a FROM testtable group by v1;
----------+

v1 a

----------+

1 2
2 3

----------+
2 rows in set (0.13 sec)

Comment by David Hall (Inactive) [ 2018-06-08 ]

Since this was already fixed, I closed as not a bug,

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