[DRILL-6212] A simple join is recursing too deep in planning and eventually throwing stack overflow.

• Type: Bug
• Status: Resolved
• Priority: Critical
• Resolution: Fixed
• Affects Version/s: 1.12.0
• Fix Version/s: 1.14.0
• Component/s: Query Planning & Optimization
• Labels: ready-to-commit
• Assignee: Gautam Parai
• Reporter: Hanumath Rao Maduri
• Reviewer: Hanumath Rao Maduri
• Created: 06/Mar/18 03:52
• Updated: 27/Sep/19 18:29
• Resolved: 17/Jun/18 18:12

Description

Create two views using following statements.

create view v1 as select cast(greeting as int) f from dfs.`/home/mapr/data/json/temp.json`;
create view v2 as select cast(greeting as int) f from dfs.`/home/mapr/data/json/temp.json`;

Executing the following join query produces a stack overflow during the planning phase.

select t1.f from dfs.tmp.v1 as t inner join dfs.tmp.v2 as t1 on cast(t.f as int) = cast(t1.f as int) and cast(t.f as int) = 10 and cast(t1.f as int) = 10;

Issue Links

• is related to: CALCITE-2223 ProjectMergeRule is infinitely matched when is applied after ProjectReduceExpressionsRule
• links to: GitHub Pull Request #1319