[
https://issues.apache.org/jira/browse/HAWQ-402?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
zhenglin tao closed HAWQ-402.
-----------------------------
> Core dumped in random table since sortcl is NULL in tlist.c
> -----------------------------------------------------------
>
> Key: HAWQ-402
> URL: https://issues.apache.org/jira/browse/HAWQ-402
> Project: Apache HAWQ
> Issue Type: Bug
> Components: Core
> Reporter: zhenglin tao
> Assignee: zhenglin tao
>
> 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
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
