[MCOL-952] UDAF incorrect error on some joins Created: 2017-10-03  Updated: 2018-02-07  Resolved: 2018-02-07

Status: Closed
Project: MariaDB ColumnStore
Component/s: ExeMgr
Affects Version/s: 1.1.0
Fix Version/s: 1.1.3

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

Sprint: 2017-20, 2017-21, 2017-22, 2017-23, 2017-24, 2017-25, 2018-01, 2018-02, 2018-03

 Description   

The following query should return a valid value. It creates an error:

MariaDB [ssb]> select
-> ssq(lo_linenumber)
-> from (select lo_linenumber, lo_custkey
-> from lineorder where lo_custkey in (29998,29999,30000)) a,
-> customer where c_custkey = lo_custkey;
ERROR 1815 (HY000): Internal error: An unexpected condition within the query caused an internal processing error within InfiniDB. Please check the log files for more details. Additional Information: error in TupleAggregateStep.
MariaDB [ssb]>

The problem appears to be that when processing a large dataset in this particular case, one rowgroup is left on a queue and is processed without the user data. I have checked and it appears all the PM processing is correct.

 Comments   
Comment by Daniel Lee (Inactive) [ 2018-02-07 ]

Build verified: Github source 1.1.3-1

/root/columnstore/mariadb-columnstore-server
commit e5499e513d88a3dfefbe9a356e20a1bceb1bde38
Merge: 99cdb0a 4840a43
Author: david hill <david.hill@mariadb.com>
Date: Wed Jan 31 16:53:52 2018 -0600

Merge pull request #92 from mariadb-corporation/MCOL-1152

MCOL-1152: Change the debian package names.

/root/columnstore/mariadb-columnstore-server/mariadb-columnstore-engine
commit ffcc4e94ccd07b6bbdfc47531c4c2f065f3fab47
Merge: 05431bf 3fb5dde
Author: benthompson15 <ben.thompson@mariadb.com>
Date: Mon Feb 5 22:37:05 2018 -0600

Merge pull request #398 from mariadb-corporation/statuscontrol-fix

add ProcStatusControl to postConfigure setup

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