[MCOL-3822] CLONE - count with distinct and 2 columns fails on every other execution Created: 2020-02-20  Updated: 2020-03-16  Resolved: 2020-03-16

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

Type: Bug Priority: Major
Reporter: Patrick LeBlanc (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

 Description   

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

 Comments   
Comment by Daniel Lee (Inactive) [ 2020-03-16 ]

Build verified: 1.2.6-1 BB

engine commit:
d4173ef

MariaDB [tpch1]> use mytest
Database changed
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.
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:45:42 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.