[
https://issues.apache.org/jira/browse/HAWQ-1697?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16815261#comment-16815261
]
ASF GitHub Bot commented on HAWQ-1697:
--------------------------------------
huor commented on issue #1427: HAWQ-1697. fix bug of window func unsafe push
down
URL: https://github.com/apache/hawq/pull/1427#issuecomment-482045050
LGTM +1
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
> fix bug of unsafe window function push down
> -------------------------------------------
>
> Key: HAWQ-1697
> URL: https://issues.apache.org/jira/browse/HAWQ-1697
> Project: Apache HAWQ
> Issue Type: Bug
> Components: Planner
> Affects Versions: 2.4.0.0
> Reporter: Zongtian Hou
> Assignee: Radar Lei
> Priority: Major
> Fix For: 2.5.0.0
>
>
> {code:c}
> * Create table aa(a int);
> SELECT t1.sum
> FROM ( SELECT sum(a) OVER() AS sum
> FROM aa
> UNION ALL
> SELECT sum() OVER() AS sum
> FROM aa
> ) t1
> WHERE t1.sum = 1;
> callstack:
>
> ;",0,,"execQual.c",4619,"Stack trace:
> 1 0x10d1e3bce postgres errstart + 0x4fe
> 2 0x10d1e368f postgres elog_internalerror + 0x2f
> 3 0x10ce73662 postgres ExecInitExpr + 0xeb2
> 4 0x10ce76088 postgres ExecInitExpr + 0x38d8
> 5 0x10ce73b21 postgres ExecInitExpr + 0x1371
> 6 0x10ce76088 postgres ExecInitExpr + 0x38d8
> 7 0x10cebc7e4 postgres ExecInitResult + 0x1d4
> 8 0x10ce6b4af postgres ExecInitNode + 0x2bf
> 9 0x10ceb847b postgres ExecInitMotion + 0x8cb
> 10 0x10ce6e0d1 postgres ExecInitNode + 0x2ee1
> 11 0x10cec38c5 postgres ExecInitSort + 0x285
> 12 0x10ce6d6cf postgres ExecInitNode + 0x24df
> 13 0x10cecf60e postgres ExecInitWindow + 0x10e
> 14 0x10ce6d9ab postgres ExecInitNode + 0x27bb
> 15 0x10cec84e1 postgres ExecInitSubqueryScan + 0x4d1
> 16 0x10ce6c9f1 postgres ExecInitNode + 0x1801
> 17 0x10ce992e1 postgres ExecInitAppend + 0x2d1
> 18 0x10ce6b614 postgres ExecInitNode + 0x424
> 19 0x10ceb847b postgres ExecInitMotion + 0x8cb
> 20 0x10ce6e0d1 postgres ExecInitNode + 0x2ee1
> 21 0x10ce5ffa1 postgres InitPlan + 0x551
> 22 0x10ce5e67b postgres ExecutorStart + 0xf2b
> 23 0x10d0c2bbe postgres PortalStart + 0x51e
> 24 0x10d0b91aa postgres exec_simple_query + 0x83a
> 25 0x10d0b72c3 postgres PostgresMain + 0x2023
> 26 0x10d050d78 postgres BackendRun + 0x418
> 27 0x10d04db15 postgres BackendStartup + 0x175
> 28 0x10d04a9c0 postgres ServerLoop + 0x4e0
> 29 0x10d048f73 postgres PostmasterMain + 0x12e3
> 30 0x10cf2128c postgres main + 0x3ac
> {code}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
