[MCOL-3662] count with distinct and 2 columns fails on every other execution Created: 2019-12-10  Updated: 2020-03-13  Resolved: 2020-02-14

Status: Closed
Project: MariaDB ColumnStore
Component/s: None
Affects Version/s: 1.2.5, 1.4.1
Fix Version/s: 1.4.3

Type: Bug Priority: Major
Reporter: Andrew Hutchings (Inactive) Assignee: Daniel Lee (Inactive)
Resolution: Fixed Votes: 0
Labels: None

Attachments: PNG File count distinct bug.png    
Issue Links:
Relates
relates to MCOL-3738 COUNT DISTINCT should accept multiple... Closed
Sprint: 2020-1, 2020-2

 Description   

Count with distinct and 2 columns triggers a UDAF error message on every other execution. See attached image for details.

 Comments   
Comment by David Hall (Inactive) [ 2020-01-21 ]

InnoDB allows for multiple params on COUNT DISTINCT, Columnstore does not.
In ver 1.1, an appropriate error was generated. After the inclusion of the UDAF API, the code sees the multi-parameter and mistakes it for a UDAF, but the first parameter wasn't part of a UDAF, and the confusing error is generated.

For this JIRA, I'll try to get the proper error message back. I'll also open a JIRA to enable multiple parameters for COUNT DISTINCT.

Comment by Daniel Lee (Inactive) [ 2020-02-14 ]

Build verified: 1.4.3-1 BB nightly

engine commit:
f843e98

MariaDB [mytest]> select count(distinct l_orderkey, l_linenumber) from lineitem;
ERROR 1178 (42000): The storage engine for the table doesn't support IDB-2020: Multiple arguments in aggregate function is currently not supported.
MariaDB [mytest]> select count(distinct l_orderkey, l_linenumber) from lineitem;
ERROR 1178 (42000): The storage engine for the table doesn't support IDB-2020: Multiple arguments in aggregate function is currently not supported.
MariaDB [mytest]> select count(distinct l_orderkey, l_linenumber) from lineitem;
ERROR 1178 (42000): The storage engine for the table doesn't support IDB-2020: Multiple arguments in aggregate function is currently not supported.
MariaDB [mytest]> select count(distinct l_orderkey, l_linenumber) from lineitem;
ERROR 1178 (42000): The storage engine for the table doesn't support IDB-2020: Multiple arguments in aggregate function is currently not supported.

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