[MCOL-3973] idbpm inside of aggregate never returns Created: 2020-04-29  Updated: 2023-11-21  Resolved: 2023-10-26

Status: Closed
Project: MariaDB ColumnStore
Component/s: ExeMgr, PrimProc
Affects Version/s: 1.5.2
Fix Version/s: Icebox

Type: Bug Priority: Minor
Reporter: David Hall (Inactive) Assignee: Leonid Fedorov
Resolution: Won't Fix Votes: 0
Labels: None

Sprint: 2020-7

 Description   

Somewhere along the line, working_tpch1_compareLogOnly/misc/pseudoColumns2.sql started locking up. The query

select count(distinct idbPm(l_orderkey)*10000000 + idbExtentRelativeRid(l_orderkey)) from lineitem;

Is the culprit. It can be reduced to 

select max(idbPm(l_orderkey)) from lineitem;

and still cause the problem.

However, if we shoot for a smaller dataset:

select count(distinct idbPm(r_regionkey)) from region;

All is well.

This is a regression from 1.4.4

 Comments   
Comment by David Hall (Inactive) [ 2020-04-29 ]

If we add a where clause that includes the entire dataset, the query works:
MariaDB [tpch1]> select count(distinct idbPm(l_orderkey)) from lineitem where l_orderkey < 100000000;
-----------------------------------

count(distinct idbPm(l_orderkey))

-----------------------------------

1

-----------------------------------
1 row in set (0.596 sec)

MariaDB [tpch1]> select count(distinct idbPm(l_orderkey)) from lineitem;
<lockup>

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