[
https://issues.apache.org/jira/browse/CALCITE-2343?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16816996#comment-16816996
]
Chunwei Lei commented on CALCITE-2343:
--------------------------------------
{quote}Technically speaking, RexOver must not be pushed into JOIN / UNION /
FILTER since it might produce wrong result.
{quote}
Agree with it.
[~laurentgo], I would like to look into the issue if you don't mind.
> PushProjector with OVER expression causing infinite loop
> --------------------------------------------------------
>
> Key: CALCITE-2343
> URL: https://issues.apache.org/jira/browse/CALCITE-2343
> Project: Calcite
> Issue Type: Bug
> Reporter: Laurent Goujon
> Assignee: Laurent Goujon
> Priority: Major
> Labels: pull-request-available
>
> When applying the {{ProjectJoinTransposeRule}} on a project with a Rex
> expression containing a RexOver call (using HepPlanner), this might cause an
> infinite loop (and ultimately a StackOverflowError exception) as
> PushProjector identify the RexOver call as to be push down under the join,
> but doesn't not rewrite correctly the top Project expression.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
