[HAWQ-402] Core dumped in random table since sortcl is NULL in tlist.c

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 2.0.0.0-incubating
• Component/s: Core
• Assignee: Zhenglin Tao
• Reporter: Zhenglin Tao
• Created: 05/Feb/16 07:00
• Updated: 14/Jul/16 18:23
• Resolved: 14/Jul/16 18:23

Description

Reproduce step:
create table sale
(
cn int not null,
vn int not null,
pn int not null,
dt date not null,
qty int not null,
prc float not null

) WITH (appendonly=true, orientation = parquet);

insert into sale values
( 2, 40, 100, '1401-1-1', 1100, 2400),
( 1, 10, 200, '1401-3-1', 1, 0),
( 3, 40, 200, '1401-4-1', 1, 0),
( 1, 20, 100, '1401-5-1', 1, 0),
( 1, 30, 300, '1401-5-2', 1, 0),
( 1, 50, 400, '1401-6-1', 1, 0),
( 2, 50, 400, '1401-6-1', 1, 0),
( 1, 30, 500, '1401-6-1', 12, 5),
( 3, 30, 500, '1401-6-1', 12, 5),
( 3, 30, 600, '1401-6-1', 12, 5),
( 4, 40, 700, '1401-6-1', 1, 1),
( 4, 40, 800, '1401-6-1', 1, 1);

explain select COUNT(DISTINCT floor(sale.pn-sale.vn)),COUNT(DISTINCT floor(sale.qty)) from sale GROUP BY (sale.cn,sale.pn),(sale.dt,sale.cn),(sale.dt,sale.cn),(sale.vn),(sale.pn,sale.qty,sale.pn),CUBE((sale.vn,sale.cn),(sale.cn,sale.qty),(sale.vn)),();

Core dump:

frame #8: 0x003ec623 postgres`get_sortgroupclause_expr(sortClause=0x00000000, targetList=0x1cdc8f84) + 24 at tlist.c:281

• frame #9: 0x003ec665 postgres`get_sortgrouplist_exprs(sortClauses=0x1c764928, targetList=0x1cdc8f84) + 55 at tlist.c:302
  frame #10: 0x006902c7 postgres`add_motion_to_dqa_child(plan=0x1cdc99a8, root=0x071d8a40, motion_added=0xbfffe333) + 199 at cdbgroup.c:6801
  frame #11: 0x006873e2 postgres`join_dqa_coplan(root=0x071d8a40, ctx=0xbfffe54c, outer=0x1cdc99a8, dqa_index=1) + 809 at cdbgroup.c:2330
  frame #12: 0x00685fc1 postgres`make_three_stage_agg_plan(root=0x071d8a40, ctx=0xbfffe54c) + 1308 at cdbgroup.c:1690
  frame #13: 0x00684520 postgres`cdb_grouping_planner(root=0x071d8a40, agg_counts=0xbfffe75c, group_context=0xbfffe708) + 4512 at cdbgroup.c:899
  frame #14: 0x003b90c1 postgres`grouping_planner(root=0x071d8a40, tuple_fraction=0) + 2666 at planner.c:1809
  frame #15: 0x003b79d2 postgres`subquery_planner(glob=0x07270020, parse=0x1c760b34, parent_root=0x00000000, tuple_fraction=0, subroot=0xbfffe948, config=0x1c764ea0) + 1859 at planner.c:1011
  frame #16: 0x003b6dd3 postgres`standard_planner(parse=0x1c760b34, cursorOptions=0, boundParams=0x00000000) + 516 at planner.c:600
  frame #17: 0x003b6ada postgres`resource_negotiator(parse=0x0726fd90, cursorOptions=0, boundParams=0x00000000, resourceLife=QRL_ONCE, result=0xbfffea64) + 79 at planner.c:477
  frame #18: 0x003b633e postgres`planner(parse=0x0726fd90, cursorOptions=0, boundParams=0x00000000, resourceLife=QRL_ONCE) + 473 at planner.c:303
  frame #19: 0x0046d477 postgres`pg_plan_query(querytree=0x0726fd90, boundParams=0x00000000, resource_life=QRL_ONCE) + 86 at postgres.c:816