[CALCITE-2440] SQL with UNNEST fail in volcano planner in some cases

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Invalid
• Affects Version/s: 1.17.0
• Component/s: core
• Assignee: Julian Hyde
• Reporter: Shuyi Chen
• Created: 03/Aug/18 00:29
• Updated: 02/Oct/19 18:38
• Resolved: 21/Aug/18 06:22

Description

After CALCITE-2291, specifically, this line causes volcano planner to fail to find the best plan for query

SELECT a, s FROM T, UNNEST(T.c) as A (s)

. I'll try to write a unittest in Calcite to reproduce. cshi vvysotskyi HanumathRao, can you provide some context? Thanks a lot.