[CALCITE-5333] Query with "WITH" clause is failing after calcite upgrade

• Type: Bug
• Status: In Progress
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.31.0
• Component/s: core, extensions
• Assignee: Unassigned
• Reporter: Rish K
• Created: 13/Oct/22 20:51
• Updated: 29/Mar/23 06:01

Description

I have a simple query using "WITH" clause:
"WITH tempTable AS (SELECT * FROM PCOLLECTION WHERE PCOLLECTION.`user_info`.`name` = 'User1') SELECT * FROM tempTable"

and schema such as:

{ "doc":"More information on the user", "name":"user_info", "type":["null", "user_info"], "default":null }

This query was running properly with Calcite 1.20. But after upgrade to Calcite 1.31, the above query is failing with the error:
"java.lang.AssertionError: fieldList must not be null, type = VARCHAR"

Issue Links

• relates to: CALCITE-4217 Unlock RelCrossType#getFieldCount()